My question was more about what the absolute minimum requirements, lowest entry barrrier, for a web2py ERP would be. What if the ERP was to be used by an organisation that doesnt have a budget for a VPS yet, it would be great if they could start using it on the free GAE, maybe not perfect, but it works. Once they organisation grows, they can still rent a VPS, but even then they might prefer a scalable PAAS solution. Will web2py ERP's work on GAE out of the box?
On Nov 23, 4:33 pm, Vinicius Assef <vinicius...@gmail.com> wrote: > +1 > > If we just use DAL, we can count on web2py's transaction management to > make the app portable among supported databases. > > So, Sqlite may be used in development and testing environments. > If you want to run in a really small business, Sqlite could be acceptable, > too. > > I know some systems developed in Delphi using Paradox as database > working for years, now. > And they don't imagine what a transaction is. :-( > > -- > Vinicius Assef. > > On Tue, Nov 23, 2010 at 1:20 PM, Michele Comitini > > > > <michele.comit...@gmail.com> wrote: > > I agree, it is true that in many little environments, there is only > > one person writing and a few reading so sqlite would be > > more than enough. > > > 2010/11/23 mdipierro <mdipie...@cs.depaul.edu>: > >> yes it should use dal and work with all supported databases, yet I > >> would not run an ERP on a system without transactions. > > >> On Nov 23, 9:07 am, Michele Comitini <michele.comit...@gmail.com> > >> wrote: > >>> IMHO the question is not about having a database, the question is that > >>> the ERP must > >>> use only DAL for data management and must run on any supported > >>> database not only relational ones. > > >>> mic > > >>> 2010/11/23 mdipierro <mdipie...@cs.depaul.edu>: > > >>> > I think a relational database for an ERP is a must and those ERPs all > >>> > support them. > >>> > At the university we have peoplesoft+oracle and ~30,000 users. Turns > >>> > out the ERP is not a high traffic app and it runs on one VPS (with > >>> > replication for high availability). I am sure any web2py ERP will be > >>> > just fine on a VPS with postgresql. > > >>> > Massimo > > >>> > On Nov 23, 8:14 am, newnomad <uti...@gmail.com> wrote: > >>> >> It's really great that there are 3 ERP's in the works, I'd love to > >>> >> switch from tryton to a web2py based system; > > >>> >>http://code.google.com/p/gestionlibre/https://bitbucket.org/yamandu/y... > >>> >> and a number 3 which I cannot find... > > >>> >> However will any of those ever work without a relational database, or > >>> >> doesn't it make any sense at all for an ERP to work without one? > >>> >> If postgre is an absolute must, what are the recommended PAAS/cloud > >>> >> options? > >>> >> - amazon ec2 > >>> >> - Google App Engine for > >>> >> businesshttp://code.google.com/appengine/business/ > > >>> >> An alternate solution may be to use mysql, so that it's still easy to > >>> >> deploy web2py on a shared lamp host with phyton enabled, but without > >>> >> shell access.