This post originated from an RSS feed registered with Python Buzz by Victor Ng. Original Post: data migration sucks Feed Title: Victor Ng's Weblog Feed URL: https://blog.crankycoder.com/feed/atom/ Feed Description: Python Feed Latest Python Buzz Posts Latest Python Buzz Posts by Victor Ng Latest Posts From Victor Ng's Weblog

ugh... just finished normalizing and migrating a whole pile of data.

Also learned yet another stupid thing about MySQL - columns are case insensitive by default.

http://www.mysql.com/doc/en/Case_sensitivity.html

Heh?

You need to specify a varchar column as binary for case sensitivity to kick in.

I also learned that psycopg can't bind to Postgresql when you're using a Postgresql 7.4 client and a Postgresql 7.2 server.

blech... I hate databases.

We should all go back to using etch-a-sketch.