So, I developed what I considered a mini application for my department
back in June. I used SQLite3. The file is still very small - about 2.5
megs - but I’d like to move to something else which supports multiple
simultaneous read/writes better than SQLite3.
What do I need to do? Clearly, rake will be my friend, but I haven’t
used it much.
I’m sure I’ll need a rake db:schema:dump, but then… what? how do I tell
the new database to get on with it, and then import all the data?
This would be done at a time when no transactions are to occur. Of