From: Jim Starkey Date: December 18 2008 11:06pm Subject: Re: [Drizzle-discuss] dropping databases List-Archive: http://lists.mysql.com/falcon/324 Message-Id: <494AD76B.2050000@nimbusdb.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Brian Aker wrote: > Hi! > On Dec 18, 2008, at 2:33 PM, Jim Starkey wrote: > >> Now, all that said, I wish each engine had a directory under the >> datadir to avoid cross engine confusion. I regret that it is >> probably too late to introduce this now. > > > Not for us :) > > Stewart is working out what to pass engines for discovery. Right now I > believe the current plans were to pass database and tablename... aka > no longer pass in "directory path" > > So it should now be viable for an engine to decide to keep its files > to itself. > Hurray! Hurray! Sanity prevails! 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. Or is this asking for too much? -- Jim Starkey President, NimbusDB, Inc. 978 526-1376