The purpose of web2py is not actually to build form to create/update/read/deletet database value?
If you want to connect to another database then the default one that is definte in application/welcome/models/db.py connection string which should be sqlite if you don't have change the welcome app, you can user another database engine by using the appropriate connection string... Doc here : http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Connection-strings--the-uri-parameter- You will have to define your database schema into web2py models... Doc here : http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Table-constructor Then chapter 7 of the book will allow you to learn how create a simple form with database Richard On Thu, Dec 10, 2015 at 6:02 PM, Sam Heather <s...@heather.sh> 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? > Sam > ᐧ > > On 10 December 2015 at 22:54, Dave S <snidely....@gmail.com> wrote: > >> On Thursday, December 10, 2015 at 2:38:23 PM UTC-8, Sam Heather wrote: >>> >>> Thanks for the tip. I'm specifically looking for a GUI, but as far as I >>> can tell you have to install one on the local server - it can't be done >>> remotely without downloading the db, editing it, and re-uploading it :( >>> Kinda a shame - doesn't seem a very scalable way of making small tweaks. >>> ᐧ >>> >> >> What sort of small tweaks are you interested in? If you're >> adding/deleting records or editing them, the appadmin page can provide >> that, and with the right https settings you can do that remotely. If >> you're changing the field properties, then you'd be editing the model files >> and using the migrate settings. >> >> /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 a topic in the >> Google Groups "web2py-users" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/web2py/BPyJ8zCFvec/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> web2py+unsubscr...@googlegroups.com. >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > *Sam Heather* | m: +44 7585 441757 <00447585441757> | e: s...@heather.sh > > -- > 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. > -- 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.
