When I moved over from Dreamhost to Slicehost, one of the (minor) motivators was the option to use something different than MySQL. Don't get me wrong, though: MySQL is a nice system, fast, relatively memory-efficient and so on. But what drove and still drives me nuts is that not every storage engine within MySQL supports transactions. MyISAM can be as fast as it gets, if it lacks transaction support, I won't use it for at least some of my tables. And having to manually check that every time I write a new app really started to annoy me. But how to move a site like this, that is using Django, from one database system to another (or to be specific, PostgreSQL in this scenario) as simply as possible?
Read more about "Move a Django site to PostgreSQL: check" ...Archive for [<Tag: mysql>]
-
Move a Django site to PostgreSQL: check
-
Batch-renaming MySQL tables
Ever felt the need to batch-rename quite a few tables in a MySQL database? Sadly phpMyAdmin doesn't offer renaming of all the tables in a specific database. So I first started renaming them manually using the commandline interface but got soon quite tired of the whole process.
A quite ugly but IMO pragmatic workaround for this limitation is to build a small query file holding all the RENAME TABLE statements you want. To generate this query listing first of all get a list of all the tables you want to rename.
Read more about "Batch-renaming MySQL tables" ...
