LinuxQuestions.org
Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
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


View Poll Results: Which is the best choice?
MySQL 5 35.71%
PostgreSQL 8 57.14%
Oracle 1 7.14%
Interbase (or other) 0 0%
Voters: 14. You may not vote on this poll

Reply
  Search this Thread
Old 05-24-2002, 04:49 PM   #1
Noerr
Member
 
Registered: May 2002
Location: Dalec, HU
Distribution: Redhat 7.3
Posts: 696

Rep: Reputation: 30
Arrow MySQL of PostgreSQL that is the question?


What do you think is the best choice in Linux if you want to make an accounting program?

Why did RedHat choose PostGreSQL for database distro, when mySQL is much more popular, and lightning fast? Is it due to relations?

Are relations a must have, with semi and more sophisticated databases? Or is it just an easier/wiser choice?
 
Old 05-26-2002, 02:44 AM   #2
rverlander
Member
 
Registered: May 2002
Distribution: A few
Posts: 488

Rep: Reputation: 30
PostgreSQL

Speed is the same as MySQL
PostgreSQL is better for large or accessed a lot databases
 
Old 05-27-2002, 11:20 AM   #3
Noerr
Member
 
Registered: May 2002
Location: Dalec, HU
Distribution: Redhat 7.3
Posts: 696

Original Poster
Rep: Reputation: 30
Common guys gime some feedback!!
 
Old 05-27-2002, 12:31 PM   #4
viniosity
Member
 
Registered: Oct 2001
Location: Washington, DC
Distribution: Debian, Archlinux, Ubuntu, Sidux
Posts: 244

Rep: Reputation: 30
Thumbs up PostgreSQL

I asked some programmers the same question once and the reply I got was that MySQL did not support sub-queries. Apparently PostgreSQL does which is what makes it better suited for databases with lots and lots of info that needs to be accessed quickly in different ways.
 
Old 05-29-2002, 01:29 AM   #5
Noerr
Member
 
Registered: May 2002
Location: Dalec, HU
Distribution: Redhat 7.3
Posts: 696

Original Poster
Rep: Reputation: 30
but isn't postgresql much slower than mySQL
 
Old 05-29-2002, 01:24 PM   #6
glalu
LQ Newbie
 
Registered: May 2002
Location: Trivadrum/Kerala/India
Distribution: RedHat 7.2
Posts: 13

Rep: Reputation: 0
MySQL won't support nested queries and procedures , but its fast also its not a transactional atabase
 
Old 05-29-2002, 03:33 PM   #7
jISV
Member
 
Registered: Feb 2002
Location: England
Distribution: MDK8.2
Posts: 128

Rep: Reputation: 15
I don't know the details of each of them, but I'd say if you're after accounting stuff, you might like to have subqueries and transactions.
 
Old 05-30-2002, 12:07 AM   #8
Noerr
Member
 
Registered: May 2002
Location: Dalec, HU
Distribution: Redhat 7.3
Posts: 696

Original Poster
Rep: Reputation: 30
Yes I have my database set up in m$ access, and it seems to me that without relations, would not be OK. Or I'm not taking a good aproach
 
Old 05-30-2002, 01:07 AM   #9
sewer_monkey
Member
 
Registered: May 2002
Location: Toronto, ON, Canada
Distribution: Ubuntu, Debian, RedHat/CentOS
Posts: 624

Rep: Reputation: 31
From what I've heard, MySQL and PGSQL both have their strengths and weaknesses when it comes to performance, but in addition to that, MySQL does not support several features (subqueries, transactions, e.t.c.) that PGSQL does...

I guess that's why PGSQL is ahead (at the time of posting).
 
Old 05-30-2002, 02:28 AM   #10
MartBrooks
Member
 
Registered: May 2002
Location: London
Distribution: Debian
Posts: 388

Rep: Reputation: 31
Use Oracle when you need it, use Postgres when you don't.

MySQL is a a glorified filesystem and should not be used for anything when data integrity is important.

Regards
 
Old 05-30-2002, 09:21 AM   #11
Noerr
Member
 
Registered: May 2002
Location: Dalec, HU
Distribution: Redhat 7.3
Posts: 696

Original Poster
Rep: Reputation: 30
Mart:
Using Oracle isn't really cheap, so unless you have a big consumer, you have a tough time explaining them, that they are paying money for SQL when they don't even now what that means.
 
Old 05-30-2002, 09:40 AM   #12
Rashkae
Member
 
Registered: May 2002
Distribution: Slackware
Posts: 125

Rep: Reputation: 15
Well, lets see, looking at the MySQL web site, and seeing things like "To avoid any any possible rollbacks, if you try to write a value that is out of bounds, MySQL will instead record the closest value and continue the transaction." I would say that makes it a very *poor* choice for Accounting. MySQL is great for weblogs and other services that require Lots of data access at highspeed with little regard to integrity.

P.S. I took that quote from memory.. It's probably not exactly the same wording as MySQL. (Chances are, it's not even close), but the idea is the same. Otherwise, someone please correct me.

Last edited by Rashkae; 05-30-2002 at 09:42 AM.
 
Old 05-31-2002, 04:45 PM   #13
Noerr
Member
 
Registered: May 2002
Location: Dalec, HU
Distribution: Redhat 7.3
Posts: 696

Original Poster
Rep: Reputation: 30
you are right, but I'm supprised how come most of the web related php progs are using mySQL.
Forum like this isn't that trivial with relations isn't it
 
Old 06-01-2002, 03:18 PM   #14
RecoilUK
Member
 
Registered: Jul 2001
Location: Southampton, England
Distribution: Mandrake 8.2 , Slackware 8.1, $LFS
Posts: 270

Rep: Reputation: 30
Hi guys

I use MySQL for my web design work.

You dont really need relationships, because your supposed to design good PHP code.

However, if you need an accountancy database, then MySQL does provide support for transactions and other features in the form of Inno DB tables and another form of table (cant remember the name). You have to get the MySQL Max version for these.

RecoilUK
 
Old 06-01-2002, 03:35 PM   #15
Noerr
Member
 
Registered: May 2002
Location: Dalec, HU
Distribution: Redhat 7.3
Posts: 696

Original Poster
Rep: Reputation: 30
but entire purpose of rdbm is to let db make as much work, with tables not interface
 
  


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 x PostgreSQL Thakowbbery Linux - Enterprise 5 09-06-2005 09:30 AM
PHP with MySQL and PostgreSQL ? Boby Linux - Software 2 05-25-2005 05:11 AM
MySQL,PostgreSQL and dbm. cranium2004 Linux - Software 1 03-10-2005 03:48 PM
MYSQL, PostgreSQL, Access ezra143 Linux - Software 7 02-17-2004 11:33 PM
PostgreSQL vs. MySQL mikeshn Programming 1 07-08-2002 12:23 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

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