4 ms·
You can use an append only text file as a database, but that doesn’t mean it’s a great idea.
by reidjs 5y ago
You can use an append only text file as a database, but that doesn’t mean it’s a great idea.
- snicker7 5y agoThat's kind-of what Kafka is. See also write-ahead-logs.
- xwdv 5y agoWhy not, it would be great for inventory tracking systems as you have an audit of all transactions.
- peytoncasper 5y agoThen you have the question of how to query it efficiently. You can’t scan 1 year of data every time, so now you need some type of external process that can either pre-compute those metrics (not flexible) or a compaction type process that makes it manageable to scan all that data. Which is basically the trade off between something like stream processing or compaction in a database.