Good writeup on the rise of document and columnar databases, including Amazon SimpleDB, Apache CouchDB, Google App Engine, and Persevere.
I’ve been watching the weekly changelogs and there were a ton of performance tweaks. The FreeBSD port landed today as well.
Rut-roh. The RDBMS crowd is none too happy about the recent MapReduce talk. This article suggests they’ve solved all these problems a long time ago and that MapReduce is basically retarded. This discussion will get interesting over the next few weeks.
Oops: “At $1 billion … Sun paid a multiple of 10 times sales for MySQL today. Optimistically assuming a 20% profit margin, they are looking at a multiple of 50 times earnings for a return on investment of around 2% per year. Optimistically.”
Steve does the Sun/MySQL aquisition Q&A and speculates on some interesting effects of the deal: “… YouTube sold for $1.6 billion, and consumed virtually no software. If that acquisition was to take place today, they would have been buying from Sun.”
What?!
Wonderful PostgreSQL cheat sheet with PDF and HTML versions.
Yep. I can’t think of a single piece of technology that’s been less of a PITA than postgres. In fact, when I think about “solid software,” postgres is the first thing that comes to mind.
Patrick’s right: even if you never build a DW related application, Kimball’s articles on dimensional database design are enlightening and applicable to a million other tasks. Reading Kimball, for me, was not unlike reading Paul Graham or Richard Gabriel.
“v1.8.0 represents nearly a year of development and testing to bring you a host of new features and improvements”
How long has this been here?
We moved from Windows / MS SQL Server to FreeBSD / PostgreSQL about 5 months ago and I’ve been nothing but completely happy with the transition. 8.2 is a pretty nice upgrade if you’re doing data warehousing style stuff.