An Error in A Query Removed All Data

Author: Szymon Lipiński
Published at: 2017-11-28

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:

BEGIN;

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

Read more...

Why I Created DBRows

Author: Szymon Lipiński
Published at: 2017-02-15

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.

Read more...