ads' corner

Wie gut repariert man eine Datenbank in MySQL

Letztens in einem IRC Channel:


Atomisch oder doch lieber atomar?

Diese wannabe Datenbank macht immer alles anders:

Google Suche nach “mysql” + “atomisch”


Why you should use schemata instead of multiple databases

Just a week ago I had a discussion with a MySQL fellow about pro and contra for schemata (schema.table as example in PostgreSQL) or use of multiple databases (database.table in MySQL).

Today I found this article.

And of course this is another big argument against the possibility of accessing two or more databases in one query statement.


frisch am Morgen

Da öffnet man nichtsahnend eine Newsgroup und schon wird einem der Tag verschönt:


Backups ... properly

Today I found this little script which does backups on a server:


MySQL and Foreign Keys

If you ever try to use Foreign Keys in MySQL (of course, only the InnoDB engine supports this), don’t forget, that the columns in both tables must have exactly the same definition.