An Error in a Query
After a data migration we had some duplicated rows in a table. I wrote a simple query for finding the duplicates, and then removing the duplicated rows. All went fine.
You should always do that in a transaction, so you can rollback all changes. The general work flow I use looks like this:
DELETE FROM x...
SELECT * FROM x...
This leaves an open transaction, so I can check all the data without changing that.
Example of The Problem
After writing the Part 1, and the new Part 2 of the Virtualenv Tutorial, I have created a simple video showing how to install the Virtualenv Wrapper on a fresh Ubuntu installation, and create the first virtual environments.
Some time ago I was using the Records, a library loved by so many people. This library is simple, it’s just a proxy to some other libraries. That’s fine.
I was really not impressed with the library interface.
After some time of using the library I got the feeling that the interface is not too good, it looked like some random ad hoc bunch of functions.
So I have decided to implement my own version, mainly to find out if it is possible to create the kind of interface I described here.
That’s why the DBRows Project has been born.