LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)
-   -   MySQL of PostgreSQL that is the question? (https://www.linuxquestions.org/questions/linux-software-2/mysql-of-postgresql-that-is-the-question-21751/)

Noerr 05-24-2002 04:49 PM

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?

rverlander 05-26-2002 02:44 AM

PostgreSQL

Speed is the same as MySQL
PostgreSQL is better for large or accessed a lot databases

Noerr 05-27-2002 11:20 AM

Common guys gime some feedback!!

viniosity 05-27-2002 12:31 PM

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.

Noerr 05-29-2002 01:29 AM

but isn't postgresql much slower than mySQL

glalu 05-29-2002 01:24 PM

MySQL won't support nested queries and procedures , but its fast also its not a transactional atabase

jISV 05-29-2002 03:33 PM

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.

Noerr 05-30-2002 12:07 AM

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

sewer_monkey 05-30-2002 01:07 AM

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).

MartBrooks 05-30-2002 02:28 AM

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

Noerr 05-30-2002 09:21 AM

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.

Rashkae 05-30-2002 09:40 AM

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.

Noerr 05-31-2002 04:45 PM

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

RecoilUK 06-01-2002 03:18 PM

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

Noerr 06-01-2002 03:35 PM

but entire purpose of rdbm is to let db make as much work, with tables not interface


All times are GMT -5. The time now is 03:48 AM.