Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re: Re: Re: Re: Database File Advice

by astaines (Curate)
on Jan 13, 2004 at 23:12 UTC ( #321136=note: print w/ replies, xml ) Need Help??


in reply to Re: •Re: Re: Database File Advice
in thread Database File Advice

In fairness to both of you, while chromatic is correct, and there is a PostgreSQL gotchas, it only has two entries, while the MySQL gotchas is a lot longer.

MySQL is highly optimised for data retrieval, and is often the best choice for write-once read-many databases. This is what I ususally have, so I use it a lot. It is not necessarily the best choice for other situations. However, if you know it well, it is quite well-behaved.

PostgreSQL is closer to something like Oracle in functionality, but that assumes that Oracle is what you want. Sometimes you do, but quite often you don't.

There's a nice discussion from Philo Vivero has an interesting (and similar) perspective.

--

Anthony Staines


Comment on Re: Re: Re: Re: Database File Advice

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://321136]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (11)
As of 2015-07-28 23:06 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (260 votes), past polls