Tag Archives: MySQL

Locking a row, portable between databases, with JDBC

Posted on February 13, 2010 by Jesper Udby

A couple of years ago I was with a project designing a system to manage Investor Meetings. An Investor must have a valid Pass in order to join a Meeting. Each Pass has a unique serial number. It was a … Continue reading →

Posted in Databases, Java | Tagged , , , , , | 1 Comment

Implementing a simple database semaphore

Posted on February 6, 2010 by Jesper Udby

In this article I will describe a simple technique that enables you to implement an “exclusive lock” in a distributed, even clustered, environment. The technique works with all major databases, and should work with any database that has a reasonable … Continue reading →

Posted in Databases, Java | Tagged , , , , , , , , | 11 Comments

The “changing the database” experience

Posted on June 17, 2007 by Jesper Udby

I have been involved in Enterprise JAVA projects since 1998. Almost all projects have had an RDBMS “behind” it, mostly Oracle and DB2. All the projects have been some custom defined application often based on existing infrastructure, and the database … Continue reading →

Posted in Databases, Java | Tagged , , , , , , , , , | Leave a comment

Why I love PostgreSQL

Posted on May 22, 2007 by Jesper Udby

Now, I’ve written some ranting about why I hate MySQL, now it is time to write about another Open Source RDBMS, PostgreSQL. In this blog I am going through why I think PostgreSQL is a great database – comparable with … Continue reading →

Posted in Databases, Open Source | Tagged , , , | 7 Comments

Why I Hate MySQL

Posted on December 30, 2006 by Jesper Udby

MySQL databases have been offered by most web hosting companies for a couple of years. This is the main reason I still have to deal with this product, which claims to be an “enterprise ready” relational database. Unfortunately these companies … Continue reading →

Posted in Databases, Open Source | Tagged , , , | 1 Comment