Xaprb

You have about 14 more hours to submit session proposals to the O’Reilly MySQL conference, which is soliciting sessions about all open-source databases: PostgreSQL, CouchDB, Riak, Hadoop, Firebird, you name it. The last-minute proposals are coming fast and furious, as usual, and we have a great selection to choose from, but we need more!

I keep a file of notes, one per line, for reference. The real reason is for source material if I ever write a 3rd edition of High Performance MySQL, but hardly a day goes by that I don’t look something up. At the very top, I have a section that I want to share with you. It’s a list of URLs that are invaluable sources of information and insight.

• http://blogs.sun.com/realneel/
• http://developer.cybozu.co.jp/kazuho/
• http://www.chriscalender.com/
• http://www.facebook.com/notes.php?id=102841356695
• http://mysqlha.blogspot.com/
• http://torum.net/
• http://yoshinorimatsunobu.blogspot.com/
• http://explainextended.com/
• http://mtocker.livejournal.com/
• http://blogs.sun.com/LinuxJedi/
• http://rpbouman.blogspot.com/
• http://jan.kneschke.de/
• http://www.xarg.org/
• http://rackerhacker.com/
• http://ronaldbradford.com/
• http://code.openark.org/blog/
• http://datacharmer.blogspot.com
• http://sql-error.microbecal.com/en/index.html
• http://kristiannielsen.livejournal.com/

At the very end, I have this note: All emails from Yasufumi! Unfortunately that’s not a resource I can share with the world.

I wish I could go to PGWest this year. A lot of great work has been done on PostgreSQL in the last year and a half. There’s a new release with built-in replication, and there are in-place upgrades. That solves two of what I think are its three biggest shortcomings in many large-scale database deployments. (Lack of index-only queries is the third shortcoming.)

PGWest is the first major conference about Postgres since the 9.0 release, so all the cool stuff is happening there. I encourage MySQL users to go to it as well — there is a lot to learn from PostgreSQL. Just remember to be polite and don’t start, encourage, or tolerate any sniping between MySQL and Postgres fans.