LinuxQuestions.org
LinuxAnswers - the LQ Linux tutorial section.
Go Back   LinuxQuestions.org > Forums > LinuxQuestions.org > Linux - News > Syndicated Linux News
User Name
Password
Syndicated Linux News This forum is for the discussion of Syndicated Linux News stories.

Notices

Reply
 
Search this Thread
Old 04-16-2007, 05:46 PM   #1
LXer
LXer NewsBot
 
Registered: Dec 2005
Posts: 74,459

Rep: Reputation: 87
LXer: Is the relational database now a commodity?


Published at LXer:

For those of us who were around in the industry during the mid to late 80s, it is interesting to think back to a time when vendors of relational database management systems (RDBMS) were struggling to be taken seriously.

Read More...
 
Old 04-16-2007, 06:32 PM   #2
fjd
Member
 
Registered: Apr 2006
Distribution: Ubuntu 10.10
Posts: 39

Rep: Reputation: 15
I'm one of those vintage developers that remembers the early days. I'll like choice in technology and I like competition among DB vendors. If they become interchangeable I'm all for it. In retrospect there are a few major technology differences with then vs now. In the old days your system was usually built around a single database (single vendor) and the technology was usually deep and narrow. The programs were usually a single language like C++ or C and was focused on a single database platform Oracle, DB2, or Sybase. Fast forward to today and the applications have depth and breadth. Applications often are truly distributed over a fabric of various technologies and databases - even physical locations. You can have Java, .NET, Cobol, EAI, ETL, Oracle, DB2, raw IMS, MS SQL Server, etc - all to run an enterprise application.

I'm amazed that MySQL works so well, but I also know when I'm working on high volume enterprise database work I'm thankful I use Oracle. I'm not trying to start a preference war - just making an observation (or two). And yes I hope MySQL (and others) continue to grow and prosper - developers benefit. Yes I hate paying for Larry Elisons private island and mega yacht, but when I need various triggers that can be exectued, before, during and after a insert oracle provides for it. Even MS SQL which has come a long way still fall short on many of the features we take for granted in the Oracle world (or some other DB's as well).

I've been doing work with MySQL lately and it really does have some nice functionality and great performance. From a development standpoint I like that I can use it from a shell command prompt like sqlplus and I like the GUI admin and workbench. Those tools alone will help with the proliferation of MYSQL. But little productivity drawbacks: ex: When I went to set the createdate field of a table initially I assumed you could just set default=today() (or some variant) when creating the table DDL. unfortunately I found out you need to create a trigger on the table to so something as basic as set date. I know it's on a list of todo's in some develpers taskbar, but it's the little things that make a difference. Now java is comming out with Derby to have a local database in the Java tech stack.

Thanks LXer - interesting article.

Last edited by fjd; 04-16-2007 at 06:55 PM.
 
  


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 On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: Is your code ready for the next wave in commodity computing? LXer Syndicated Linux News 0 07-10-2006 07:54 AM
LXer: Open Source Relational Database, PostgreSQL Version 8.1.1 Launches LXer Syndicated Linux News 0 12-30-2005 09:16 PM
LXer: Latest Firebird Relational Database Released (Pre Final) LXer Syndicated Linux News 0 12-23-2005 07:31 PM
a good book for relational database design? kpachopoulos General 3 11-20-2004 08:14 AM
Relational Database on Linux Ronw Linux - Software 10 11-11-2003 02:40 PM


All times are GMT -5. The time now is 01:17 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