Am 14.02.12 20:41, schrieb Robin Sheat:
Op 15-02-12 08:37, Marc Balmer schreef:
Turns out that MySQL indeed has no schema support. But it supports cross-database-queries.
A "database" in MySQL is very similar, if not the same, as a "schema" in PostgreSQL.
Noo, not quite. I mean, they can be used like that, but I would be strongly be against using databases as schema. That way lies terrible madness.
In particular, all the tools expect to deal with a database as the unit of data for an application, all permissions are associated with that database, and so on. Also, if you're using a database server administered by someone who isn't you, they'll hate you forever if you do it that way.
Oh, I was not suggesting using MySQL databases like PostgreSQL schemas, I was merely pointing out the similarity.