On Thu, Dec 18, 2008 at 3:06 PM, Jim Starkey <[email protected]> wrote: > Has anyone given any deep thought to the database / schema issue? In MySQL, > schema is a synonym for database (I presume for a checkmark on somebody's > database comparison grid). It would be nice to know what semantics attach > to database, what semantics attach to a schema, and, maybe, recognize that > they aren't two names for the same thing.
and don't forget that there's this thing called a catalog that some databases support, and in fact some of the mysql connectors equate database and catalog, not database and schema. i hope that some thought is going into how some of the standard apis (jdbc, odbc) expect to be able to access metadata. it would be nice if drizzle could avoid the horrible slowness of information_schema, and some of the impedance mismatches between what is available from the server and what the standard apis expect to have available. jim _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
