[web2py] Re: sqlite <---> postgresql

2014-02-06 Thread Gour
On Thu, 06 Feb 2014 20:55:20 + Carlos Correia wrote: > Also with Postgresql (unless you're in Windows). I'm know...since the time when I was running Bacula (backup) and recently I moved from linux (Debian Sid) to Free/PC-BSD, one still has to take care when upgrading server versions as well

[web2py] Re: sqlite <---> postgresql

2014-02-06 Thread Alan Etkin
> This is even better. No rush here, but just curious if there is any ETA > for it? > ETA: uncertain. It is not a trivial change. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issue

Re: [web2py] Re: sqlite <---> postgresql

2014-02-06 Thread Carlos Correia
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Em 06-02-2014 18:27, Gour escreveu: > On Thu, 6 Feb 2014 06:27:36 -0800 (PST) > Cliff Kachinske wrote: > >> Maybe I'm missing something, but why would you develop on one back >> end if your production target is another? > > It's easy to work with sq

[web2py] Re: sqlite <---> postgresql

2014-02-06 Thread Gour
On Thu, 6 Feb 2014 06:27:36 -0800 (PST) Cliff Kachinske wrote: > Maybe I'm missing something, but why would you develop on one back > end if your production target is another? It's easy to work with sqlite. > Postgres is not that hard to set up and use. MariaDB/MySQL is equally > easy. That's

[web2py] Re: sqlite <---> postgresql

2014-02-06 Thread Cliff Kachinske
And maybe there's no need to switch. SQLite is not a toy. http://www.sqlite.org/whentouse.html On Wednesday, February 5, 2014 3:02:50 PM UTC-5, Gour wrote: > > Hello, > > Do you consider it's safe to work with web2py on localhost machine and > use sqlite3 database as storage (which greatly simp

[web2py] Re: sqlite <---> postgresql

2014-02-06 Thread Cliff Kachinske
Gour, Maybe I'm missing something, but why would you develop on one back end if your production target is another? If you switch back ends you will need to go through a complete regression test before you deploy. Postgres is not that hard to set up and use. MariaDB/MySQL is equally easy. On

[web2py] Re: sqlite <---> postgresql

2014-02-06 Thread Gour
On Thu, 6 Feb 2014 04:06:55 -0800 (PST) Alan Etkin wrote: > I've posted a module for web2py shell which automates the migration > here: > https://groups.google.com/d/msg/web2py-developers/QxeJNByj6qc/cpBHsa1ymUkJ Thanks a lot. Just what I need. ;) > BTW: there is a work-in-progress modification

[web2py] Re: sqlite <---> postgresql

2014-02-06 Thread Alan Etkin
> > Hello, > > Do you consider it's safe to work with web2py on localhost machine and > use sqlite3 database as storage (which greatly simplifies setup) and > then deploy application on the production server by using e.g. > PostgreSQL database? > There are some difficulties when you need to