Microsoft Access, the database I've been using since version 2.0, isn't available for OS X, even though the rest of Office is. So I need an alternative.
MySQL is free (at least, the Community Edition is free), so I installed that on mork this evening. It works nicely, though its user interface (all command-line, all the time) is a bit retro.
Now I just need to migrate my databases (all eight of them). Access has a table-export function, but it doesn't work very well: it will generate csv text files, but isn't bright enough to escape any quotation marks that appear in text fields. I suppose I should have exported everything as fixed-width fields. Oops.
I had the idea that exporting the tables manually would be too much work, so I tried instead to write some VBScript that would do it for me. Access 2000 has an automation interface, but it's completely useless; there's also ADO, but that's such a train wreck that I gave up after an hour and just exported everything by hand. It took less time than untangling ADO would have taken.
People might grumble about, say, PHP's interface to MySQL, but it has advantages: first, it may be ugly, but it works; second, it can be learned in small pieces; third, its developers don't replace it every [censored] year with an all-new, completely incompatible API in some mad, hopeless pursuit of the Ultimate Data-Access API.