• Post Reply Bookmark Topic Watch Topic
  • New Topic

Linux DB's - seeking opinions  RSS feed

 
Guy Allard
Ranch Hand
Posts: 776
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All - Am looking for informed opinions regarding data base managers on Linux.
Would like pro's/con's for: postgres, mysql, msql, and any others you have had hands on experience with.
Especially would like to hear from those who have used two or more of the above.
Regards, Guy
 
James Hobson
Ranch Hand
Posts: 140
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have used postgrSQL, and thought it was fine (no GUI if that sort of thing bothers you).
It has actually been about 18months since then, so perhaps things have changed, but as I said, it was fine then. (It was on Debian).
People who use mySql tell me things about foreign keys and weak typing that make me very, very worried, but I cant say that I have ever actually used it.
 
Tim Holloway
Saloon Keeper
Posts: 18799
74
Android Eclipse IDE Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
MySQL is probably the most popular open-source DBMS and it's used to drive a lot of websites. Historically, however it hasn't had industrial-strength things like transaction management. That's a problem they've been devoting much effort towards lately, however, so it may soon cease to be an issue.
PostgreSQL has better transaction management and has been positioned as a "bulletproof" system. It often comes in second in benchmarks, but they've been putting considerable stress on reliability concerns and international language support.
You can occasionally find comparisons in magazines and on the web, though I'd check the age of the review before making serious judgments, since neither is sitting still.
 
Michael Ernest
High Plains Drifter
Sheriff
Posts: 7292
Netbeans IDE VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Here's a comparison of mySQL and PostGreSQL I found useful. It's a web-centric perspective, of course.
------------------
Michael Ernest, co-author of: The Complete Java 2 Certification Study Guide
 
James Hobson
Ranch Hand
Posts: 140
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
A friend of mine raves about sapDB (from http://www.sapdb.org/) -- has anybosy had expecience of it, and if so, how does it compare??
 
Guy Allard
Ranch Hand
Posts: 776
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
All - thanks for the replies.
Michael - in the interim I had stumbled across the same article. Indeed it was useful.
Of course Postgres and MySQL came with my OS. I've fooled a little with both. This is not an urgent requirement.
I also have a 'trial' copy of DB2 on order.
Anyone ever work with that on Linux??
Much like DB2 on mainframes I suspect (am quite familiar with that stuff). I'm somwhat attracted to that because of IBM's -very large- commitment to supporting Java.
Regards, Guy


[This message has been edited by Guy Allard (edited December 18, 2001).]
 
Eric Handbury
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
For me, its a no-brainer... use Interbase (or Firebird).
Its an industry-strength DBMS with transactions, stored procedures, triggers, events, etc. Everything you need for your data with very little maintenance required. I use it for my web-site, my telephony/realtime apps, and standard Windows client/server stuff.
I've tried mySQL. It's good... a little slow if your database has lots of writes (good for reads though). But I changed to Interbase and will never look back. Having stored procedures makes a world of difference.
Best of all, its free and runs on Linux/Solaris/Windows.
Eric.
 
Andre Mermegas
Ranch Hand
Posts: 158
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Theres always the Oracle option out there now. Free for non-commercial use.
 
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!