Well I try to only use DB admin tools to examine the data and occasionally edit it and perhaps create and optimise indexes etc, usually once my app is stable.
Bear in mind that anything you do in a DB admin tool will make it more difficult to migrate your app to another database, so try to accomplish everything possible via web2py. The one I use and recommend for Firebird is IbExpert. I have used various ones for MySql but do not have a strong recommendation. There are lots of tools for Sqlite. Just google for suitable tools for the DB of your choice. On Feb 17, 2:56 pm, stargate <kyoukh...@gmail.com> wrote: > So saying that how do I add a username and password to the database > and give the user permissions to insert delete view records. I also > what to be able to connect to the database using a db tool to examine > and administrate my db. Which one would you recommend. > > On Feb 17, 7:15 am, villas <villa...@gmail.com> wrote: > > > You can use ANY suitable tool to examine/administrate your DB > > independently of web2py. > > > On Feb 17, 4:04 am, stargate <kyoukh...@gmail.com> wrote: > > > > It's just a database admin tool for mysql. I just want to be able to > > > access the mysql lite database that comes with web2py using mysqlfront > > > > On Feb 16, 10:22 pm, Richard Vézina <ml.richard.vez...@gmail.com> > > > wrote: > > > > > I think you should provide information about mysqlfront and how you > > > > think it > > > > could work with Web2py. > > > > > Personnaly I am not aware of anything about mysqlfront... > > > > > Richard > > > > > On Wed, Feb 16, 2011 at 9:40 PM, stargate <kyoukh...@gmail.com> wrote: > > > > > Is it possible to do this > > > > > > On Feb 16, 9:51 am, stargate <kyoukh...@gmail.com> wrote: > > > > > > When running web2py how do i access the mysql database using a > > > > > > applicaiton like > > > > > > >http://www.mysqlfront.de/wp/download/ > > > > > > > Also when creating a new application using the application wizard it > > > > > > has no indication to specify a user login for the database. Where > > > > > > can > > > > > > i change this. > >
