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. >> >>