Try http://code.google.com/p/wwwsqldesigner/
On Mon, Dec 3, 2012 at 7:17 AM, David <wencuiq...@googlemail.com> wrote: > Hi guys, > > I'm new to web2py, and got a question here. I want to design a database with > sqlite for my app, but I prefer to design it on a visualiable tool e.g. GEA, > which is recommended in web2py admin panel. But after some trials, I can't > get the generated script work in web2py, especially for tables with foreign > keys. > > My question is, do you have the same issue here? Or can you please tell me > the normal workaround to design a sqlite database in web2py without writing > the define_table script directly? > > Thanks, > David > > -- > > > --