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?

PostgreSQL

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

Common guys gime some feedback!!

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.

but isn't postgresql much slower than mySQL

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

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.

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

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

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

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.

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.

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

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

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