SQLite is by design an excellent embedded database, better suited for single user implementation and targeted at small datasets. For larger datasets there is no reason not to use PostgreSQL, it's free, well supported by web2py, handles very large datasets and it's easy to setup.
Migration from SQLite to any other db supported by web2py is very easy and explained on the web2py book 2015-01-02 6:49 GMT+01:00 Eric Taw <[email protected]>: > From reading a lot of web2py tutorials and guides, they always say SQLite > is good for small implementations of databases, whereas other SQL flavors > are better suited for larger uses. Is there any reason why? Can I still use > SQLite if I have a lot of information to store? > > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2py (Source code) > - https://code.google.com/p/web2py/issues/list (Report Issues) > --- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
