> Will not contest your claim at all since you must have tried it to make
>that claim. So if I agree with you, then don't you think that the statement
>which is posted earlier :"Berkeley DB does not support SQL queries. All
>access to data is through the Berkeley DB API." is misleading esp. to a
>novice like me or is it that I misunderstood?
BDB used directly without some kind of interface does not support SQL.
The MySQL server is an interface to BDB. When you use BDB tables in
MySQL, you're not interacting with BDB directly.
You're making the mistake of interpreting a statement on the Berkeley DB
Web site as though it was posted on the MySQL Web site.
>From: Paul DuBois [mailto:paul@stripped]
>Sent: Monday, August 27, 2001 1:38 PM
>To: Sheena Sidhu; Mysql (E-mail)
>Subject: RE: Choosing between Databases.
>At 1:23 PM -0700 8/27/01, Sheena Sidhu wrote:
>> Thanks for responding. I am not sure if I understand you fully here. SO
>>you mean to say that BDB DOES support SQL, meaning that I send statements
>>like 'Select * from user' to a BDB table from my C++ code? If that is
>>possible, then great. If not, then kindly let me know if Innodb has the
>You're not interacting directly with the BDB or InnoDB table handlers.
>You're interacting with the MySQL server. You send the server SQL
>statements, it performs the appropriate translation from SQL onto the
>operations supported by the table handlers. It doesn't matter whether
>the table handlers understand SQL as long as the MySQL server does -- which
>You can easily convince yourself of this by writing a C++ program that
>talks to the MySQL server to manipulate a BDB table.
>>From: Paul DuBois [mailto:paul@stripped]
>>Sent: Monday, August 27, 2001 1:19 PM
>>To: Sheena Sidhu; mysql@stripped
>>Subject: Re: Choosing between Databases.
>>At 11:10 AM -0700 8/27/01, Sheena Sidhu wrote:
>>>I am looking into choosing between Innodb and BDB. One thing about BDB
>>>I am quoting from the official site :"
>>>Berkeley DB does not support SQL queries. All access to data is through
>>>Berkeley DB API. Developers must learn a new set of interfaces in order to
>>>work with Berkeley DB. Although the interfaces are fairly simple, they are
>>>has me worried. When I looked into Innodb, I see not similar reference so
>>>can I assume that it supports SQL. Can someone please let me know if I am
>>>Thanks in advance,
>>The MySQL server maps SQL statements onto the internals of the BDB or
>>InnoDB table handlers. The BDB statement is probably more with reference
>>to accessing it directly rather than through a SQL engine.
>>Paul DuBois, paul@stripped
>Paul DuBois, paul@stripped
Paul DuBois, paul@stripped