February 9, 2008

moved

For those who don’t already know, my blog now lives here. Thank you.

•
January 27, 2008
“ this reminds me what made tumblr seem exciting. this was what blogging was all about. mundane? sure. but personal? absolutely. tumblr brought sexy back.
Wow, tumblr sucks. I can’t respond to a post without reblogging? I can’t reblog without tumblr thinking I want to quote the original quote. Damn. Anyway, Quang, if you see this, check out my blog for sexy. •
January 11, 2008
converting mysql to postgresql
•
Google’s Time spent downloading a page (in milliseconds).That sharp drop in the middle of December is when we switched to the PostgreSQL.

Google’s Time spent downloading a page (in milliseconds).
That sharp drop in the middle of December is when we switched to the PostgreSQL.

•
http://www.postgresql.org/docs/techdocs.83

“The basic design philosophy of PostgreSQL is to produce errors or warnings in similar situations where an operation is ambiguous or unsupported.”

Why there’s a novel concept.

•
http://dev.mysql.com/doc/refman/5.1/en/create-table.html

mySQL silently ignores certain parameters passed when creating a table. This is, effectively, silent failure.

“The CHECK clause is parsed but ignored by all storage engines.

Important

The inline REFERENCES specifications where the references are defined as part of the column spoecification are silently ignored by InnoDB. InnoDB only accepts REFERENCES clauses when specified as part of a separate FOREIGN KEY specification. “

Also, this little gem:
“Partitioned tables do not support foreign keys.”

•