LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)
-   -   I have problem in choosing a data base working with open source linux (https://www.linuxquestions.org/questions/linux-software-2/i-have-problem-in-choosing-a-data-base-working-with-open-source-linux-620563/)

rm22 02-12-2008 09:12 AM

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?

Tinkster 02-13-2008 02:44 AM

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

DBabo 02-13-2008 08:30 AM

Quote:

Originally Posted by rm22 (Post 3054531)
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

tronayne 02-13-2008 08:51 AM

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.

rm22 02-14-2008 02:44 AM

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

Tinkster 02-14-2008 11:30 AM

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

apolinsky 02-14-2008 03:53 PM

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.


All times are GMT -5. The time now is 03:55 AM.