State of the Postgres project

http://blog.endpoint.com/2010/01/state-of-postgres-project.html

by blasdel • 17 years ago

70 25 17 years ago

blog.endpoint.com

forkandwait3• 17 years ago

I think the PostgreSQL project might become even more robust with the coming mass defection away from MySQL. Except for easy replication and the ability to explain it to a know-nothing manager, MySQL has nothing on Postgres these days.

Maciek416• 17 years ago

Can you explain your comment about "mass defection away from MySQL"? Do you think that's something that's about to practically happen? Thanks.

tentonova2• 17 years ago

We started making plans to migrate away to PostgreSQL when Oracle embarked on a clear strategy to buy/control MySQL by purchasing InnoDB, and then Sleepycat.

There were already plenty of technical justifications to abandon MySQL, but the potential of dealing with Oracle sealed the business case. From past experience, Oracle was not a company whose licensing, development, or business strategy we wanted to be beholden to.

With Oracle now (nearly) owning MySQL proper, the move seems correct. There's the potential that they'll improve on MySQL, but any significant improvements will eat at Oracle sales unless they're also countered with licensing changes or other revenue-boosting strategies -- such as splitting into enterprise/open source open/closed versions.

Better to use PostgreSQL where we don't need to pay client library licensing fees, and aren't locked to a vendor.

forkandwait3• 17 years ago

I meant the comment mostly to be funny, but "much truth is said in jest". Yes, I think it will happen -- especially if a few of the important devs in the MySQL world get frustrated with the whole Cluster F---, make a change, and start to write about it. Quality wins, but only in the long run; it took forever for C to become the standard it rightly is, but it happened. The entire universe is finally waking up to what crap Java is, why not finally realize that MySQL has fewer features, less reliability, AND is more constrained Postgres?

...

ducks head

tdavis• 17 years ago

Replication is coming in 8.5 :)

(and I think it's already in the Alpha)

thristian• 17 years ago

The Hot Standby feature is in the recently-released PostgreSQL 8.5alpha3, and what it means is that you can have a read/write master and several read-only slaves; if the master goes down, you can start switch one of the slaves to be the new master without a restart.

For more information, see the development-version documentation:

http://developer.postgresql.org/pgdocs/postgres/hot-standby....

rimantas3• 17 years ago

MySQL has nothing on Postgres these days.

Except for some engines you can choose from.

WorkerBee3• 17 years ago

As far as I understand mySQL

- You have to choose engines

- Some features (e.g. ACID Transactions) don't work in some engines.

I'm not sure exactly why this is a feature. In PostgreSQL (and in most sane DB software)

- You don't have to choose engines

- All features work all the time. There's no posiblity of foolery like, say, beginning a transaction and then updating two tables, then finding that one of the tables will ignore the transaction but the other won't.

rufugee• 17 years ago

As a long time user of both PostgreSQL and MySQL, I can't begin to compliment PostgreSQL enough. It runs just about everything in our company, from ticketing systems to an ERP system with over 1000 users...and it does so without flinching or making a fuss.

It's stored procedure support is very nice, and allows you to write procedures in the built in PGPSQL. However, if that syntax doesn't sit well with you, you can also write them in Tcl, or Perl, or PHP, or Ruby, or Java, or...you get the idea. Our ERP's stored procedures are all written in Java, for the record.

The stability has been incredible...the community support, wonderful.

And it's really, really free, to boot.

I haven't really faced a lot of the problems others have with MySQL, but that's probably because for the applications that have mattered, I've always gone back to PostgreSQL. And the whole commercial/non-commercial licensing FUD MySQL AB historically spread about when you actually had to buy a license just left a bad taste in my mouth. I'm ok with buying licenses and am happy to, but don't enjoy or appreciate that need being fabricated by sales staff.

mahmud2• 17 years ago

Used my Christmas holiday converting my personal database library from MySQL to Postgres; I have about 10 projects depending on it. I am still ironing out the small details of the process, but the Lisp ORMs make things easier.

Postgres, keep getting things right, please.

mattyb• 17 years ago

Used my Christmas holiday converting my personal database library from MySQL to Postgres

Why?

mahmud2• 17 years ago

Found out the hard way that MySQL not only runs fast, but also fails just as fast.

forkandwait3• 17 years ago

Can't somebody (besides me) write an online mysql to postgres schema converter?

rbanffy3• 17 years ago

Relational databases are sooo 20th century...

wendroid• 17 years ago

Well exercised, mature and stable?

pilif2• 17 years ago

I doubt that an automatic schema conversion would really help you as some stuff just works too different between the two databases. An automatic migration can leave you with the false security of having ported your code successfully.

What I'd try is to feed the MySQL schema into postgres (after removing the awful ` quotes around field names) and see what happens.

In cases where postgres doesn't accept the MySQL schema dump, you will have to manually check what you are doing and fix it manually anyways (the exception being auto_increment which you can fix with an easy search and replace process).

Stuff like that "timestamp not null default '0000-00-00'" comes to mind for example. I wouldn't know whether I would drop the invalid default or both the not null and the invalid default - that pretty much depends on the application.

zby• 17 years ago

I am a big supporter of the PostgreSQL project, and I have been using it exclusively for my own projects (recently I started using SQLite for all the experimental ones) - but competition is a good thing and this schadenfreude about MySQL problems is not a mature thing.

pilif2• 17 years ago

Since the end of 2000 (the 7.1 beta period), I'm an avid PostgreSQL user. All new projects I started were using PostgreSQL and I never had any issues with that configuration.

Meanwhile, MySQL, which I had running for various third-party products like Wordpress, required some maintenance here and then, corrupted on-disk table files (and indexes), produced invalid dumps that were not restorable (and no warnings about that fact) and annoyed me with the inferior command line tool (better by now).

One thing I wish PostgreSQL would add is to set a collation order on a specific index. Right now, in one of my applications, I can't rely on Postgres doing the sorting, forcing me to retrieve all rows and sort on the client side which is a) annoying and b) anything but fast.

But whereas earlier, we had to set LC_COLLATE at initdb-time, now we can do it at createdb time and who knows - maybe we can do it at create index time in the future? I certainly lack the skill to contribute this particular feature.

State of the Postgres project

Related Stories