On Thursday, December 10, 2015 at 3:03:23 PM UTC-8, Sam Heather wrote: > > Just the kind of tweaks where I might want to edit a value. I'm trying to > allow that kind of admin access to non-techies who don't know SQL, so the > kind of GUI that allows them to view the database like a spreadsheet (as is > available for MySQL) would ideal. I read I can actually switch Web2PY to > use proper SQL instead of SQLite here > <https://realpython.com/blog/python/web2py-migrating-from-sqlite-to-mysql/> > .... is that correct? >
Web2Py works with several databases, and the common relational databases with SQL interfaces (MySQL, Postgres, Oracle, and the Windders one) are frequently used underneath Web2Py. SQLite3 is just the one shipped "in the box". Postgres seems to be the one most favored for production databases, if you have a choice. For such databases, the actual storage will probably not be in your application directory. SQLite3 is a fairly robustly featured DB, but is best suited for small databases and development work. All of my current efforts fit into that description; my only use of Postgres was where I didn't have to set up the server. But before you go running around looking for Big Iron to set your DB up on, note that the AppAdmin interface allows values to be exported and imported as CSV files which your users can edit in a spreadsheet; worksfor all backends. If this sort of maintenance is frequent, though, it might be just as well to provide a form (like using SQLFORM and SQLFORM.grid) that make it easy for them to *find* and *edit* the values of interest. Such a form would work with any of the backends. /dps ᐧ > -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
