Hi Paul,
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
issue?
Regards,
Sheena.
-----Original Message-----
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 1:19 PM
To: Sheena Sidhu; [EMAIL PROTECTED]
Subject: Re: Choosing between Databases.
At 11:10 AM -0700 8/27/01, Sheena Sidhu wrote:
>Hello,
>I am looking into choosing between Innodb and BDB. One thing about BDB
which
>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
>non-standard. "
>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
>wrong here?
>Thanks in advance,
>Sheena.
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, [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
