Category Archives: Database

Oracle…

Working with Oracle is always an adventure. The error messages are usually not very helpful, so you have to guess a lot. What I’ve seen today is an extreme though. Oracle allows you to create a table with a column … Continue reading

Posted in Database, Rants | Tagged , , | Leave a comment

“MySQL server has gone away”

I have written a few Twisted scripts at work that parse incoming data from a socket and save it in a MySQL database, using the MySQLdb package. It’s a well-known fact that the MySQL server will close connections that are … Continue reading

Posted in Database | Tagged , , | Leave a comment

UUID generator in PL/pgSQL

While writing an SQL script to upgrade the MusicBrainz database for the last release, I needed a way to generate new UUIDs from SQL. PostgreSQL has a native UUID data type and a contrib module for generating UUIDs since version … Continue reading

Posted in Database, MusicBrainz, Programming | Tagged , , , , | Leave a comment