[ex3ndr]

We are actually spend two weeks rewriting our code from SQL to FoundationDB (we have built our own simple ORM).

One of the huge problems is a lack of consistency constraints. Since during development data make became broken in various ways (and we have done several times). And right now there are no way to implement simplest constraints on database level.

[ryanworl]

Could you give an example of what you mean? This is very relevant for my talk.

[ex3ndr]

I mean we have built a nice ORM for FoundationDB, but eventually we found several bugs in it and we just didn't write to our indexes correctly or put several indexes in the same subspace. Then we started to migrate our data (we were so crazy that moved large chunk of our production data already!) and we found that our migrators are also have problems. Basically our data was not consistent at all.

There are almost no easy way to ensure that everything is OK.

Also I have fear that we probably deleted something and there are no way to prohibit modification of certain keys.