| ▲ | Small Kafka: Tansu and SQLite on a free t3.micro(blog.tansu.io) | |
| 54 points by rmoff 5 days ago | 4 comments | ||
| ▲ | randito 5 hours ago | parent | next [-] | |
Great link. I've always been drawn to sqlite3 just from a simplicity and operational point of view. And with tools like "make it easy to replcate" Litestream and "make it easy to use" sqlite-utils, it just becomes easier. And one of the first patterns I wanted to use was this. Just a read-only event log that's replicated, that is very easy to understand and operate. Kafka is a beast to manage and run. We picked it at my last company -- and it was a mistake, when a simple DB would have sufficed. https://github.com/simonw/sqlite-utils https://litestream.io/ | ||
| ▲ | ktzar 4 hours ago | parent | prev | next [-] | |
I didn't know about Tansu and probably would not use it for anything too serious (yet!). Bus as a firm believer of event sourcing and change of paradigm that Kafka brings this is certainly interesting for small projects. | ||
| ▲ | 8organicbits 3 hours ago | parent | prev | next [-] | |
Quite cool. 7000 records per second is usable for a lot of projects. One note on the backup/migrate, I think you need a shared lock on the database before you copy the database. If you dont, the database can corrupt. SQLite docs have other recommendations too: | ||
| ▲ | brikym an hour ago | parent | prev [-] | |
How does it compare to Redis streams with persistent storage? | ||