RE: [sqlite] Re: SQLite and Columnar Databases

2007-12-18 Thread Tom Briggs 

Ahh yes, the obvious answer.  Duh.  Thanks. :)

> -Original Message-
> From: Trevor Talbot [mailto:[EMAIL PROTECTED] 
> Sent: Tuesday, December 18, 2007 8:27 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Re: SQLite and Columnar Databases
> 
> On 12/18/07, Tom Briggs <[EMAIL PROTECTED]> wrote:
> 
> >This implies that there are databases that provide 
> multiple storage
> > mechanisms and allow users to choose between the options.  
> Does such a
> > database exist?
> 
> It may not be exactly what you had in mind, but see MySQL:
> http://dev.mysql.com/doc/refman/5.1/en/storage-engine-overview.html
> 
> --
> ---
> To unsubscribe, send email to [EMAIL PROTECTED]
> --
> ---
> 
> 

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Re: SQLite and Columnar Databases

2007-12-18 Thread Trevor Talbot 
On 12/18/07, Tom Briggs <[EMAIL PROTECTED]> wrote:

>This implies that there are databases that provide multiple storage
> mechanisms and allow users to choose between the options.  Does such a
> database exist?

It may not be exactly what you had in mind, but see MySQL:
http://dev.mysql.com/doc/refman/5.1/en/storage-engine-overview.html

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

RE: [sqlite] Re: SQLite and Columnar Databases

2007-12-18 Thread Tom Briggs 
 

> If a DBMS is smart enough, it can automatically pick the best storage 
> method for performance and you don't have to think about it.
> 
> However, many DBMS are not that smart and so typically users find 
> themselves making explicit changes to their schemas, specifying the 
> storage method explicitly, in order to compensate and/or give the 
> DBMS hints.  

   This implies that there are databases that provide multiple storage
mechanisms and allow users to choose between the options.  Does such a
database exist?

   Or am I being too literal?

   -T

-
To unsubscribe, send email to [EMAIL PROTECTED]
-