I'd like to announce the release of my SQLite export plugin for MySQL Workbench. The plugin is available under GPL, just like the Community Edition (OSS) of Workbench for which it was developed.
With this plugin, one can combine the visual database design capabilities of MySQL Workbench together with the high-performance, stand-alone SQLite database.
The plugin creates a SQL create script from a Workbench model. It already supports some advanced features like:
- Creates INTEGER PRIMARY KEY where possible (as a fast alias for rowid)
- Uses the .genfkey feature of sqlite3 command-line client for foreign keys (>=3.6.14 required)
- Exports project metainformation, schema, table and column comments
- Table and column comments are stored right in the SQLite file for persistent documentation
Since I just started this project, room for improvement is surely there.
I'm always open for suggestions, bug reports or feature wishes.
SQLite export plugin for MySQL Workbench: