4 ms·
Ask HN: Apart from Expensify, anyone else using BedrockDB in production?
I am evaluating FoundationDB, TiKV and BedrockDB. BedrockDB really looks nice. BedrockDB is built on top of SQLite and supports MySQL protocol. So that is a huge plus. But I was wondering what is the performance like and what are the gotchas, for example:
0. What happens to the local commit if the node goes down before that commit is replicated to other nodes?
1. Does the DB support multiple write nodes?
2. What is the average time it takes for a commit to be available at other nodes?
3. Under the hood it works like a blockchain, so what happens if a chain of transactions splits from the main branch? Does the DB client have to retry all those transactions again from the split chain?
What is your experience?
Also, does anyone know how to add unique constraint on a column in an existing table in SQLite?