3 ms·
> - have a snapshot of data Being able to see a snapshot is good, and I would hope to see a higher-level abstraction that can offer that on top of something Ka
by lmm 5y ago
> - have a snapshot of data
Being able to see a snapshot is good, and I would hope to see a higher-level abstraction that can offer that on top of something Kafka-like. But making the current state the primary thing is a huge step backwards, especially when you don't get a history at all by default.
> - query data, including ad-hoc querying
OK, fair, ad-hoc queries are one thing that relational databases are legitimately good at. Something that can maintain secondary indicies and do query planning based on them is definitely useful. But you're asking for trouble if you use them in your live dataflow or allow ad-hoc queries to write to your datastore.
> - have trasactional updates to data
I do think this one is genuinely a mistake. What do you do when a transaction fails? All of the answers I've heard imply that you didn't actually need transactions in the first place.
- irl_chad 5y agoYou think transactional updates are a mistake? I guess you’ve never had to worry about the integrity of your data? Bank -> debit card purchase -> perform all required database work in a transaction -> transaction fails -> decline debit card purchase Without transactions, in this scenario, maybe the debit card transaction fails but money is still taken out of your account? Doesn’t sound very pleasant.
- lmm 5y agoDatabase transactions would be useless for banks - you'll notice that if you try to pay while not having enough money in your account, the attempt doesn't simply disappear. What banks actually do is something akin to what Kafka-based systems do - the attempt to charge is recorded in a leger, and then fulfilment of that happens asynchronously.
- KptMarchewa 5y agoThat's seriously one of the worst takes I've seen on this website. >the attempt to charge is recorded in a leger Hint: how do you think this attempt is recorded and fulfilled? Or, do you think "it's just appended" and bank recalculates your balance from scratch every time you spend 1$ on coke can? Only bank I've heard of that's not using traditional relational database for ledger is Monzo [1] - but they still use Cassandra's transactions. [1] https://www.scaleyourapp.com/an-insight-into-the-backend-infrastructure-of-a-modern-digital-bank-monzo-architecture/ https://www.scaleyourapp.com/an-insight-into-the-backend-inf...
- lmm 5y ago> Hint: how do you think this attempt is recorded and fulfilled? Or, do you think "it's just appended" and bank recalculates your balance from scratch every time you spend 1$ on coke can? That's how the bank I worked with did it. Of course there was caching in place so we didn't actually recompute everything every time, but the implementation of that was a lot closer to "commit a kafka offset" than an RDBMS-style transaction. (E.g. we didn't overwrite the "current balance" in-place, we appended a new "current balance as of time x").
- dmitriid 5y ago> Of course there was caching in place so we didn't actually recompute everything every time I think you've proved our point
- johnthescott 5y agoevery large ingest app i have worked on had something akin to kafka, from raw 3d seismic broadcast via sat, to RF tower motion detection, to carrier grade cellular billing. common denominator was a replayable ingest queue. yes, kafka is a "great" idea. however, it is not a replacement for querying.
- marcosdumay 5y agoThe reason the things are called "transactions" is because they were invented for banks. Bank ledgers must always be appended in pairs or not at all, never in any other number. The entire finance system is dependent on that feature. Transactions were kept by humans, literally for a few centuries, before the algorithm was adapted for computers.
- lmm 5y agoRDBMS "transactions" work nothing like banking transactions; when you abandon a banking transaction you don't erase it as though it never happened, you keep a full record of what happened but the downstream consequences change. In fact the way traditional accounting is done, with transactions first committed to journals and then later asynchronously propagated into ledgers, is more closely akin to how Kafka-based systems work.
- dmitriid 5y ago> But making the current state the primary thing is a huge step backwards Why? When is "I need to query all of my log to get the current view of data" is a step forward? All businesses operate on the current view of data. > OK, fair, ad-hoc queries are one thing that relational databases are legitimately good at. Not just ad-hoc queries. Any queries. > But you're asking for trouble if you use them in your live dataflow or allow ad-hoc queries to write to your datastore. In our "live datafows" etc. we use a pre-determined set of queries that are guaranteed to run multiple orders of magnitude faster in a relational database on the current view of data than having to reconstruct all the data from an unbounded stream of raw events. > What do you do when a transaction fails? I roll back the transaction. As simple as that.
- lmm 5y ago> All businesses operate on the current view of data. All businesses operate in response to events. Most of the things you do are because x happened rather than because the current state of the world is y. > In our "live datafows" etc. we use a pre-determined set of queries that are guaranteed to run multiple orders of magnitude faster in a relational database on the current view of data than having to reconstruct all the data from an unbounded stream of raw events. If you have a pre-determined set of queries, you can put together a corresponding set of stream transformations that will compute the results you need much faster than querying a relational database. > I roll back the transaction. As simple as that. And then what, completely discard the attempt without even a record that it happened?
- dmitriid 5y ago> All businesses operate in response to events. Yes, but once an event happens, business needs access to current state of data. > If you have a pre-determined set of queries, you can put together a corresponding set of stream transformations that will compute the results you need much faster than querying a relational database. No, it won't. Because you won't be able to run "a corresponding set of transformations" on, say, a million clients. You can, however, easily query this measly set on a laptop with an "overengineered" relational database. > completely discard the attempt without even a record that it happened? Somehow in your world audit logging doesn't exist.
- Ma8ee 5y ago> But making the current state the primary thing is a huge step backwards Yeah, who could need to know exactly how many items of a particular product they have in stock currently, or how much money a customer has in her account at the particular moment she wants to do a withdrawal? It's really hard to come up with any useful real world examples when this could be the case. > What do you do when a transaction fails? It depends on why the transaction fails and in which way. But sometimes it is really useful to make sure that when one account is debited, another one is credited at the same time.
- lmm 5y ago> Yeah, who could need to know exactly how many items of a particular product they have in stock currently, or how much money a customer has in her account at the particular moment she wants to do a withdrawal? It's really hard to come up with any useful real world examples when this could be the case. Having access to the current state of the world is useful, having a log of what happened / how it got that way is essential. You've got to get the foundations right before you build a monumental edifice on top.