I have problem in choosing a data base working with open source linux
Linux - SoftwareThis 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
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.
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?
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).
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.
Location: Northeastern Michigan, where Carhartt is a Designer Label
Distribution: Slackware 32- & 64-bit Stable
Posts: 3,541
Rep:
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.
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.
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.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.