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 same
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 the
>>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