LinuxQuestions.org
Go Job Hunting at the LQ Job Marketplace
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > Programming
User Name
Password
Programming This forum is for all programming questions.
The question does not have to be directly related to Linux and any language is fair game.

Notices

Reply
 
Search this Thread
Old 01-04-2005, 02:54 AM   #1
hk_michael
LQ Newbie
 
Registered: Oct 2004
Posts: 22

Rep: Reputation: 15
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
 
Old 01-04-2005, 02:10 PM   #2
Mara
Moderator
 
Registered: Feb 2002
Location: Grenoble
Distribution: Debian
Posts: 9,536

Rep: Reputation: 148Reputation: 148
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.
 
Old 01-04-2005, 02:27 PM   #3
acid_kewpie
Moderator
 
Registered: Jun 2001
Location: UK
Distribution: Gentoo, RHEL, Fedora, Centos
Posts: 43,386

Rep: Reputation: 1963Reputation: 1963Reputation: 1963Reputation: 1963Reputation: 1963Reputation: 1963Reputation: 1963Reputation: 1963Reputation: 1963Reputation: 1963Reputation: 1963
depends how embedded you're talking.. maybe sqllite might be useful? http://www.sqlite.org/
 
Old 01-05-2005, 08:33 PM   #4
hk_michael
LQ Newbie
 
Registered: Oct 2004
Posts: 22

Original Poster
Rep: Reputation: 15
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
 
Old 01-10-2005, 05:07 PM   #5
Mara
Moderator
 
Registered: Feb 2002
Location: Grenoble
Distribution: Debian
Posts: 9,536

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


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
sql naflan Programming 6 11-13-2005 11:53 PM
Migrating from MS-SQL server to My-SQL emailssent Linux - Networking 2 02-07-2005 02:20 PM
my sql................ apenguinlinux Programming 2 01-24-2005 10:39 PM
what to do with -> ' <- in SQL? kvasarnomad Programming 3 10-16-2004 10:51 AM
Embedded SQL -Unable to connect to PostgreSQL database vikram_cvk Linux - Software 1 05-30-2004 06:14 AM


All times are GMT -5. The time now is 09:27 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration