Hey @U2E12TNLF this is a big topic, but the short answer is that 'yes' XT supports arbitrary ACID requirements, although there's a bit of spectrum as to what's possible (including performance/throughput implications). If you wouldn't mind re-posting the question on https://discuss.xtdb.com/ I will respond back with more detail there shortly 🙂 I know there's been a lot of good discussion about this stuff on this channel before, but nothing comprehensive has made it into the docs as yet...

XT uses a single-threaded writer model without interactive transactions, so has a 'serializable' consistency level

(sorry @U899JBRPF, messages crossed 🙂)

Thank you, I created a topic here in http://discuss.xtdb.com - https://discuss.xtdb.com/t/clarification-on-xtdbs-acid-transaction-behavior/69 @U050V1N74 what do you mean by interactive transactions? I wonder if we are talking about the same thing. For example, in an rdbms you can open a transaction, do multiple read and write queries and can expect ACID compliance. Does XTDB support transactions with multiple read and write queries?

replied over there - do let us know if you have further questions 🙂