LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
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
  Search this Thread
Old 01-28-2004, 03:43 PM   #1
Peds
LQ Newbie
 
Registered: Nov 2003
Distribution: Red Hat 9
Posts: 4

Rep: Reputation: 0
MySQL or PostGres ??


Dear forum,

I am looking to enter into Linux database programming, having come from a WIndows VB.Net and SQL Server background (although I have a bit of exposure to Ingres from my uni course).

I am looking to write a database application that would be suitable to offer as a product in the future.

At the moment I am trying to decide between MySQL and Postgres. I have decided to choose between these 2 as they are the most common open source databases.

I would therefore like to know peoples opinions on which database to choose, considering the following points:

i) Availability of Triggers.
ii) Availability of User defined functions / stored procedures.
iii) User-friendly database management tools.
iv) Important! Concurrent users, e.g. which can have more users accessing the system, and/or which is fastest and most reliable.

Finally, is there any suggested developemnt tools / languages for developing database apps with these databases.

Thanks in advance,

Peds
 
Old 01-28-2004, 03:44 PM   #2
php
Member
 
Registered: Jun 2001
Location: USA
Distribution: Slackware
Posts: 825

Rep: Reputation: 30
Both are well documented.. I would go with postgres though
 
Old 01-28-2004, 03:47 PM   #3
david_ross
Moderator
 
Registered: Mar 2003
Location: Scotland
Distribution: Slackware, RedHat, Debian
Posts: 12,047

Rep: Reputation: 66
I would probably go with mysql - you may be interested in:
http://www.linuxquestions.org/questi...hreadid=116360
 
Old 01-28-2004, 04:05 PM   #4
awesomejt
LQ Newbie
 
Registered: Jan 2004
Location: Flowery Branch, GA
Distribution: Fedora Core 1, various others
Posts: 26

Rep: Reputation: 15
PostgreSQL more true to SQL

PostgreSQL has all the features you want or well known free addons are available.

Both databases are nice, BUT PostgreSQL has support for transaction management and isolation, much better and standard compliance for ANSI SQL 99. Both have diversions or "enhancements" to the standard SQL language, but I think PostgreSQL allows you to do more without resorting to non-standard SQL.

MySQL's main goal was to be FAST. So, things like transaction management, and other advanced items are either an afterthough or completely unsupported. In the end, effeciently written complex SQL can outrun MySQL of similar complex SQL broken into more simple/iterative SQL statements. That can be done with any database that support complex SQL. But with the improvements of both databases, the speed issue is not that big to me any more -- both are reasonably fast under average load.

Have the MySQL folks fixed the crappy locking support yet? When the only tranaction management they have is locking an entire table seems abit too crude. Deadlocks anyone? Most folks don't bother with it. Don't consider it if you are building a banking application. :-) I think it has only recently that they have opened more support for JOINing tables.

On thing for the MySQL camp is that it seems like most open software, specially web-related scripts or programs assume you will be running MySQL. Many projects now support either database or are written to be database-independent -- but more support MySQL right now.

One thing I did notice -- even Fedora only ships with MySQL 3.x series because of the license change. This might be a consideration, I'm not sure if MySQL is becoming more commercial and closed or what. PostgreSQL remains unquestionabily open source. I think RedHat has shifted it's preferred database to PostgreSQL.

I've worked with both and my personal preference is PostgreSQL, although I can work with either. Yeah, I noticed the poll with MySQL in the lead. I would not give that much weight. Evaluate your needs and consider the strengths of each database. I have found PostgreSQL to be a bit more robust.

Last edited by awesomejt; 01-28-2004 at 04:15 PM.
 
Old 01-29-2004, 01:42 PM   #5
Peds
LQ Newbie
 
Registered: Nov 2003
Distribution: Red Hat 9
Posts: 4

Original Poster
Rep: Reputation: 0
I think with my research so far, I will probably opt for PostGres. It appears to have more functionality, and has positiives such as User defined functions, and triggers.

My quest is now to download and install the latest version, and try and figure out which tools to use for the application front end. This could be even more difficult than determning the DB to use.

Are there any commonly used tools for Linux database application development? I guess I am trying to find something along the lines of Windoze forms as I've been used to in the past such as in VB or Access.

Peds
 
Old 02-18-2004, 12:43 AM   #6
jdtiede
Member
 
Registered: Apr 2003
Location: Baton Rouge, LA
Distribution: Kubuntu 12.04, 12.10, 13.04a
Posts: 244

Rep: Reputation: 30
Tcl/Tk and Qt are both useful for building forms, etc. Both can be supported in C++, Perl or Python, though extra downloads may be needed to get the needed bindings. Qt requires a license if you're going to sell software. Tk doesn't yet have combo boxes. There is a package from NZ that offers them, but I haven't been able to get it to install (Pmw for Python Mega Widgets--Google Pmw if you want to try it).
 
  


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



Similar Threads
Thread Thread Starter Forum Replies Last Post
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 09:44 AM
mysql AND postgres on same server kosuke Linux - Software 3 03-19-2005 08:45 PM
postgres and mysql varun_33 Linux - Software 1 02-12-2005 08:54 AM
Converting MySQL to Postgres usef Linux - Software 0 06-12-2004 10:50 PM
how do I Add multiple columns mysql in postgres Bheki Linux - Software 1 08-28-2003 03:30 PM


All times are GMT -5. The time now is 01:15 PM.

Main Menu
Advertisement
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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration