How good is POSTGRE SQL
Say, i am extremely impressed when i see PostGRESQL site. How come it has not dethroened the biggies still. I have never used it, but if it actually does whatever it claims, it should be dethroning the biggies maybe with the next one decade. Also it seems to be light years ahead of MySQL.
It's a matter of what you're looking for, what you're already tied into, and who you want to support it, and whether you can hire people to support it who have real production experience.
It is good. OpenACS has a lot to say about it. They took a large ERP/CRM software designed for Oracle and ported it to PostgreSQL. It is a real RDBMS.
Why is that no one even wants to google before posting questions like this is beyond me but...
It is about the only way in the developed world you can get 50,000 honest to god real RDBMS servers running in your TakeOverTheWorld.Com server farm installed without paying for a single use-license. You'll have access to full source. So for that it's great. It is slower than MySQL, but you can get what pay for. All that extra processing time exist for PG because it's a real RDBMS and has to account for all sorts of computations and jobs real RDBMSes have to deal with.
Tim Perdue's article is really great, I don't mean to imply that MySQL sucks or anything, because it's great. I am sure you'll figure out which you need, so don't rule out MySQL. It really depends on your project and the run-time environment you expect to run the database in.
My experiences with PostgreSQL were mostly negative. Very slow in general, ineffective and inflexible query planner, features not working as advertised. Dev team seems to be more concerned with making something cool than solving real-world problems. I have elaborated on this in another thread here a few days ago, so please don't ask me to repeat it, take it for what it's worth.
There are only a few instances where MySQL is faster than PostgreSQL. These cases generally involve using MySQL as a really fast indexed read-only flat file system.
4 out of 5 dentists...oops, wrong product.
Spock the Vulcan JockBox
We use PostgreSQL (voluntarily) for our fairly-large-volume production systems. My complaints are generally what you'd expect from an open-source system - the features it has are generally the ones that people thought would fun to implement, not necessarily the ones that you really need in a production environment.
For my part, the only reason we haven't switched to PostGreSQL yet is because it does not have a native Windows version. Such a thing has been promised but has not yet seen distribution.
1/4 Ain't Bad
Yes PostrgreSQL is nice but I wonder how much you have used other DB's if you wonder why it hasn't conquered the World yet. SQL server is much easier to use, mySQL is better documented, etc. Open source still has a stigma in the enterprise space and people just don't change their database just like that.
What about firebird?
I second Firebird. Most of the complaints against PostgreSQL are addressed in Firebird.
> SQL server is much easier to use, mySQL is better documented, etc
Today's Joel article seems appropriate. Why does every dev. that has cobbled up a SELECT statement feel they are on top of what makes a good DBMS?
Just me (Sir to you)
"> SQL server is much easier to use, mySQL is better documented, etc
Actually, I read the bit about SQL Server developers being paid better as an appeal not to support programmers who undermine your own salary--a "fair trade" for programmers type of thing, not as OS advocacy.
Chris -- ;)
Firebird would have been an excellent choice as well, except that it doesn't have a native boolean/logical field data type. By itself, that missing aspect rendered it completely inelligible for our purposes.
1/4 Ain't Bad
What is the problem with using short int as a boolean field. 1=true, 0=false?
Re: Short int as Boolean
1/4 Ain't Bad
>Firebird would have been an excellent choice as well, except that it doesn't have a native boolean/logical field data type. By itself, that missing aspect rendered it completely inelligible for our purposes. <
Data conversion is not a problem, code conversion is. My kingdom for a boolean field.
1/4 Ain't Bad
I HV NOT USED IT YET
Fog Creek Home