Which SQL is suitable for EMbedded SQL on C?
 

Hi all! I'm doing a project on remoting the AV devices using mobile phone and PDA. The main program is written on C. As the target is that I can select one of the devices to be remoted, I will use SQL embedded on C. I wish to ask that which one of SQL is the best--MySQL, PostgreSQL or Oracle? And is the Toolkit for Oracle in Red Hat 9.0 useful? Should I use the kit or install the other SQL? And is there any guide to embed SQL in C? Thank you very much.
Michael

It depends how much you want to spend on licenses and which subset of SQL you need. How much does Oracle cost you probably know. PostgreSQL uses BSD license, so the cost is 0, even for commercial programs. MySQL requires a separate license if your ptogram will not be GPLed.

I can say from my personal experience and for similier (and GPLed) tasks MySQL or correct. If I need triggers and such things I go for PostgreSQL.

All databases have libraries in C to pass SQL queries to database. Functions are different, but thy work more or less the same.

depends how embedded you're talking.. maybe sqllite might be useful? http://www.sqlite.org/

Actually, my case is that I have to access the database that is for the AV Devices, with tpye, brand name and model code, and it will not be changed i.e. static. So, there is no need for the user to insert, update or delete the items in database. But what I have to is to get the plenty of items that I need to store in my main program and then to show it. So, is MySQL enough? Or is it better if I use PostgreSQL? Thank you very much again.
Michael

So the most imprtant thing is how many features you want and how fast must the database be (how many questies per minute).