Atomic conditional inserts with complex conditions

I was going to blog about the software I’m currently writing, but that’s not happening, yet (although it’s been beta-test-ready for about a week and, given that I’ve made just under 100 subversion larger-than-ideal check-ins in the last seven days, it’s been getting refinements literally almost by the hour).  Instead, I’m going to share a little trick I came up with to do atomic conditional insertions into a database without using triggers or conflicts.  Indeed, I’m using little old sqlite3, so there’s nothing fancy going on in this database at all.  Sure, the software I’m currently working on is probably going to be open sourced at some point, but this would just get buried in there.

Continue reading “Atomic conditional inserts with complex conditions”