ProgrammingThis forum is for all programming questions.
The question does not have to be directly related to Linux and any language is fair game.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
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.
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
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.