Database Management
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesDatabase Management

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old October 31st, 2003, 09:00 PM
clowns119 clowns119 is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Sep 2003
Posts: 95 clowns119 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 51 m 51 sec
Reputation Power: 5
Which SQL should I use?

I have a quick question and I know ultimatly the answer will come down to personal prefrence but i figured I should get some opinions. I just have been teaching myself c++ for a while now and I want to write a functional simple program. I was moving into my house and found boxes and boxes of comic books, so i figured I would attempt to write a program that would be a database for storing and orginizing my comic books. I have been searching the internet and I don't want to have to purchace something like MS SQL if I don't have to and I again want to rpogram to be compiled in c++ since thats the only language that I know. Any suggestions On were to begin as far as which database libraries to use? I was reading about SQLite but i have heard that their are better libraries out their.

Reply With Quote
  #2  
Old November 1st, 2003, 10:20 AM
rycamor rycamor is offline
Gödelian monster
Dev Shed Regular (2000 - 2499 posts)
 
Join Date: Jul 1999
Location: Pembroke Pines, Florida, USA
Posts: 2,300 rycamor User rank is Sergeant Major (2000 - 5000 Reputation Level)rycamor User rank is Sergeant Major (2000 - 5000 Reputation Level)rycamor User rank is Sergeant Major (2000 - 5000 Reputation Level)rycamor User rank is Sergeant Major (2000 - 5000 Reputation Level)rycamor User rank is Sergeant Major (2000 - 5000 Reputation Level)rycamor User rank is Sergeant Major (2000 - 5000 Reputation Level) 
Time spent in forums: 3 Days 3 h 12 m 27 sec
Reputation Power: 53
Do you want this database engine to be embedded in your compiled application, or do you want to connect to an external SQL server, running as a daemon?

I believe SQLite is an embedded database system, while the more commonly used open source database server systems are

1. MySQL -- if you want quick and easy, without being too theoretically rigorous

2. PostgreSQL -- if you want something that can compete in features and syntax with Oracle, Sybase or MSSQL

3. FireBird -- another very capable SQL DBMS, not quite as full-featured or mature as PostgreSQL (IMHO), but with some interesting advantages. Actually, I Firebird also has an embedded version, which is perfect for compiling inside your C/C++ application. I seem to recall that it was fairly small, something like 750K . (Not sure about this, so you should do some searching on the Firebird site.)
__________________
The real n-tier system:

FreeBSD -> PostgreSQL -> [any_language] -> Apache -> Mozilla/XUL

Amazon wishlist -- rycamor (at) gmail.com

Reply With Quote
  #3  
Old November 1st, 2003, 11:08 AM
clowns119 clowns119 is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Sep 2003
Posts: 95 clowns119 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 51 m 51 sec
Reputation Power: 5
I want it to be embedded in my compiled application, can they all do this?

Reply With Quote
  #4  
Old November 1st, 2003, 12:14 PM
HarrisonF HarrisonF is offline
Contributing User
Dev Shed Novice (500 - 999 posts)
 
Join Date: Oct 2002
Location: Binghamton, NY
Posts: 536 HarrisonF User rank is Sergeant (500 - 2000 Reputation Level)HarrisonF User rank is Sergeant (500 - 2000 Reputation Level)HarrisonF User rank is Sergeant (500 - 2000 Reputation Level)HarrisonF User rank is Sergeant (500 - 2000 Reputation Level)HarrisonF User rank is Sergeant (500 - 2000 Reputation Level) 
Time spent in forums: 1 Day 15 h 35 m 55 sec
Reputation Power: 19
Are you sure you want to embed the server right in your program? This means there is no external server, only a single client can use it, etc... With stand-alone servers, you will still embed the SQL calls in your C++ code, just not the entire server.

Of the above open source servers he mentioned, SQLite can only be embedded. Both FireBird and MySQL can be either embedded or run externally.

Reply With Quote
  #5  
Old November 1st, 2003, 04:04 PM
clowns119 clowns119 is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Sep 2003
Posts: 95 clowns119 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 51 m 51 sec
Reputation Power: 5
Well the ultimate goal of the program is for their to be a large database server that the clients databases will be uploaded into, so I guess I want the stand alone server. MY only q would be would everyone who has a copy of my app need to also have MYSQL on their computers?

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesDatabase Management > Which SQL should I use?


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 6 hosted by Hostway