Fork me on GitHub
#xtdb
<
2022-02-01
>
johnnyillinois17:02:03

Could someone explain or send a link to documentation on xtdb’s consistency behavior for transactions? Mainly, I’m curious if xtdb supports ACID guarantees when performing read/write transactions against “arbitrary” data stored inside xtdb (vs a client can only use 1 CAS per transaction)

refset17:02:07

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...

jarohen17:02:28

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

jarohen17:02:49

(sorry @U899JBRPF, messages crossed 🙂)

🙏 1
johnnyillinois17:02:33

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?

🙏 1
🙇 1
👌 1
jarohen17:02:26

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

🙏 2