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.