LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
LinkBack Search this Thread
Old 02-12-2008, 09:12 AM   #1
rm22
LQ Newbie
 
Registered: May 2006
Posts: 14

Rep: Reputation: 0
I have problem in choosing a data base working with open source linux


Hi,

I have to choose an open source data base to work with it on Linux, but I have many criteria, first it must be open source, and stable working, which accept a great amount of data going untill 500 table, which works with sql and jdbc and of course with GNU/Linux.

is there any one who have an idea about what i search, I was thinking in MySql, Ingrs and Postgresql what do you think about these program, are they compatible with what i search, are they stable and accept a big charge?

Last edited by rm22; 02-12-2008 at 09:38 AM.
 
Old 02-13-2008, 02:44 AM   #2
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 22,950
Blog Entries: 11

Rep: Reputation: 860Reputation: 860Reputation: 860Reputation: 860Reputation: 860Reputation: 860Reputation: 860
I can vouch for postgres, have seen ingres (commercial version) work reasonably
well, and personally stay clear from MySQL (even though some will argue that it
qualifies).



Cheers,
Tink
 
Old 02-13-2008, 08:30 AM   #3
DBabo
Member
 
Registered: Feb 2003
Distribution: Scientific Linux 6
Posts: 372

Rep: Reputation: 33
Quote:
Originally Posted by rm22 View Post
Hi,

I have to choose an open source data base to work with it on Linux, but I have many criteria, first it must be open source, and stable working, which accept a great amount of data going untill 500 table, which works with sql and jdbc and of course with GNU/Linux.

is there any one who have an idea about what i search, I was thinking in MySql, Ingrs and Postgresql what do you think about these program, are they compatible with what i search, are they stable and accept a big charge?
It would be useful to have more details about your project - jdbc and 500 tables is not sufficient, but a good start.

for now your parameters are :


open source
sql interface
jdbc connectivity


i would need to know where you want to run it, how much data you want to put in and out - what's the profile of the application - dss, oltp etc. is it a distributed env, how many clients will be connected etc. in other words - the more details you give, the more qualified answer you will expect to receive.

good luck
 
Old 02-13-2008, 08:51 AM   #4
tronayne
Senior Member
 
Registered: Oct 2003
Location: Northeastern Michigan, where Carhartt is a Designer Label
Distribution: Slackware 32- & 64-bit Stable
Posts: 2,865

Rep: Reputation: 698Reputation: 698Reputation: 698Reputation: 698Reputation: 698Reputation: 698
Don't know if it'll help you but I run multiple data bases with MySQL with no problems. One of these is roughly 50 tables where about 90% of them contain upwards of 10 million rows (a few over 40 million rows) and I've found query performance more than acceptable even with multi-table joins and the like. I also run GIS data bases with upwards of 20 million rows in tables and have no complaints there either. I have found MySQL to be robust, reliable and efficient. And, combined with Apache and PHP, well, no complaints on either Linux or Solaris (SPARC) platforms.
 
Old 02-14-2008, 02:44 AM   #5
rm22
LQ Newbie
 
Registered: May 2006
Posts: 14

Original Poster
Rep: Reputation: 0
Hello

I believe that it misses some details and this what I have to add, i need to argument my choice:

The database will work with a java program
the load is very hight it is biger than one hundred user and more.
the size will be very hight, because it will work for at least 3 years, so maybe it will reach many GO.
Sure it will work under Linux and we don't care for the distribution.
I don't know with which machines they will work.

I know that Ingres can do this, but is it the best to do this, I knew that there is other open source data base like: Postgresql, FireBird Entreprise DB and if there is other choice with resonable argument it will be welcome.

So I am waiting for your help freinds.

for any specific details, do not hesitate
 
Old 02-14-2008, 11:30 AM   #6
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 22,950
Blog Entries: 11

Rep: Reputation: 860Reputation: 860Reputation: 860Reputation: 860Reputation: 860Reputation: 860Reputation: 860
You're not really asking for anything specific, still.

Go to each RDBMs web-site and check out the testimonies of
people who use them?

http://www.postgresql.org/about/casestudies/
http://www.postgresqlfr.org/?q=node/1538



Cheers,
Tink
 
Old 02-14-2008, 03:53 PM   #7
apolinsky
Member
 
Registered: Oct 2004
Location: Brooklyn
Distribution: Slackware 13.1,12.1,12.2; Debian Sqeeze; Centos 5,6
Posts: 250

Rep: Reputation: 34
Postgresql and Mysql are each quite fine products. Each of them will handle large databases without flinching. You might find that Mysql will be a bit easier to administer. You might check to see with a Google person to verify their table sizes. Google and Nasa use Mysql significantly. 100 users does not sound like a very large number. Good luck with your exploration.
 
  


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
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: Open Source Development Labs’ Carrier Grade Linux Working Group ... LXer Syndicated Linux News 0 01-17-2007 04:33 PM
LXer: Mapping the Future of Open Source Data LXer Syndicated Linux News 0 11-17-2006 06:21 PM
LXer: Choosing an open source CMS LXer Syndicated Linux News 0 06-24-2006 11:33 PM
LXer: Enterprise Data Protection Goes Open Source LXer Syndicated Linux News 0 06-03-2006 05:54 PM
KDE 3.2.2 (base tarball) Source Compile Problem gccslix Linux - Newbie 1 05-14-2004 09:44 PM


All times are GMT -5. The time now is 09:01 AM.

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