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

[Marc Balmer]

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.