I would like to know which tool do you use for modeling tables, relationships, etc, generic database modeling, in Ubuntu.
It would be good if that tool generate SQL scripts, and a plus with those scripts are SQLite compatible, but thats not necessary.
Currently, I am using Enterprise Architect for that under a virtual machine, which kind of sucks. I was able to run it under Wine, but not as good as I want to. It is a complete tool for modeling anything in this world, and right now I do not need so much.
Best Answer
You may try DIA. You can use UML to create/model Databases and use one of the officially supported Scripts to convert it to SQL.
For instance you can find a basic How-To using DIA and TeDia2SQL at http://left.subtree.org/2007/12/05/database-design-with-dia/