Re: [web2py] Re: Accessing / connecting to web2py database with GUI

2015-12-10 Thread Richard Vézina
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, y

Re: [web2py] Re: Accessing / connecting to web2py database with GUI

2015-12-10 Thread Dave S
On Thursday, December 10, 2015 at 3:39:07 PM UTC-8, Dave S wrote: > > [...] SQLite3 is a fairly robustly featured DB, but is best suited for small > databases and development work. Note that this has to do with scaling, not features. It's built to use a conventional filesystem, and uses

Re: [web2py] Re: Accessing / connecting to web2py database with GUI

2015-12-10 Thread Dave S
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

Re: [web2py] Re: Accessing / connecting to web2py database with GUI

2015-12-10 Thread Sam Heather
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 us

Re: [web2py] Re: Accessing / connecting to web2py database with GUI

2015-12-10 Thread Dave S
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 :( >

Re: [web2py] Re: Accessing / connecting to web2py database with GUI

2015-12-10 Thread Sam Heather
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. ᐧ On 10 D

[web2py] Re: Accessing / connecting to web2py database with GUI

2015-12-10 Thread Dave S
On Thursday, December 10, 2015 at 3:42:09 AM UTC-8, Niphlod wrote: > > if you're using sqlite, by default the file is stored under the databases/ > directory of your app. > > And for a shell running on the webserver machine, cd to that directory allows you to use the standard SQLite3 command li

[web2py] Re: Accessing / connecting to web2py database with GUI

2015-12-10 Thread Niphlod
if you're using sqlite, by default the file is stored under the databases/ directory of your app. On Thursday, December 10, 2015 at 11:41:27 AM UTC+1, Sam Heather wrote: > > Hi there, > Is it possible to access the Web2Py database remotely using a GUI tool? > Web2Py doesn't seem to use the norm