[Koha-devel] [Discussion tech] database table naming

[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.

Robin.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 262 bytes
Desc: OpenPGP digital signature
URL: </pipermail/koha-devel/attachments/20120215/362a2383/attachment.pgp>