Skip to content

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: http://mysqlmusings.blogspot.com/2006/09/replication-and-disappearing.html

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

Trackbacks

No Trackbacks

Comments

Display comments as Linear | Threaded

No comments

Add Comment

Enclosing asterisks marks text as bold (*word*), underscore are made via _word_.
E-Mail addresses will not be displayed and will only be used for E-Mail notifications.
To leave a comment you must approve it via e-mail, which will be sent to your address after submission.
Form options