Databases suck

acme on 2004-07-27T13:12:09

Recently we've been having problems with MySQL at work. Looks like Alan Burlison is experiencing the same kind of thing. If you're at OSCON, can you bop the free database developers on the head? How can they load everything into memory by default? No cursors? They all suck! All! Suck! Software! Graahahahgggh.

Hmmmm, maybe this post should have been on hates-software...


I agree, agree, agree!

ambs on 2004-07-27T20:10:00

But I would say, relational databases. As one of my recent posts on my journal says, DB_File and MLDBM rockz :)

Lose MySQL... use PostgreSQL instead

merlyn on 2004-07-27T20:24:31

PostgreSQL is real. Cursors, etc. Why anyone still chooses MySQL for a reason other than legacy (people compatibility, software compatibility) in this day and age still confuses me.

Re:Lose MySQL... use PostgreSQL instead

vek on 2004-07-28T04:41:16

PostgreSQL is real. Cursors, etc.

But I thought Leon's point was that DBD::Pg's support of cursors is the problem here.

From the DBD::Pg docs (emphasis mine):

Although PostgreSQL has a cursor concept, it has not been used in the current implementation. Cursors in PostgreSQL can only be used inside a transaction block. Because only one transaction block at a time is allowed, this would have implied the restriction, not to use any nested SELECT statements. Hence the execute method fetches all data at once into data structures located in the frontend application. This has to be considered when selecting large amounts of data!