intertwingly

James Duncan Davidson: My opinion is tha Rails needs to follow the same model as EOF uses in Web Objects and Core Data uses in Tiger: Use some abstract data model definition, not database specific SQL, that can be adapted at runtime for the particular data store in use.  Furthermore, Rails in development mode should keep the internal structure of the database in sync with the data model, adding and dropping columns and tables as required.

I’m not to sure of that (particularly the comment about altering tables), but meanwhile, it is fair to observe that scripting language tend to excel at text processing.  Here is a script that will convert the DDL you have to one that can be used by SQLite.  While it currently only handles a small subset of MySQL’s DDL, the script should be fairly easy to extend.