Replacing Kafka with SQLite?(turso.tech)

7 pointsby mjirv11 เดือนที่ผ่านมา2 comments

https://turso.tech/blog/replacing-kafka-with-sqlite?trk=feed_main-feed-card_feed-article-content

2 comments

8organicbits11 เดือนที่ผ่านมา

> each Kafka partition was represented by a separate SQLite database

What does the programming interface look like for this? I believe you'd only be able to use SQL to query each partition (database) individually, unless there's another layer orchestrating SQL over the partitions. I wonder if you just end up with connectors again.

compressedgas11 เดือนที่ผ่านมา

Additional databases can be added to a SQLite connection using:

  ATTACH 'pathname.db' AS prefix

https://www.sqlite.org/lang_attach.html