logoalt Hacker News

gchamonliveyesterday at 7:49 PM4 repliesview on HN

Are logs all you need for durable workflows? I'm confused here. How'd persist and query nested or related data over logs? By logs I assume you mean something like elasticsearch or meilisearch?


Replies

wolttamyesterday at 8:03 PM

Pretty much every durable system has an intent log of some sort. The log provides durability, the database system just integrates that log into a more queryable format.

show 2 replies
deathanatosyesterday at 8:48 PM

I assume they meant a log like a WAL. A WAL should be (quite literally?) all you need for durable workflows.

A distributed WAL (to survive a machine death) would also probably be something I'd want, and … something I'm not sure you're getting directly from SQLite.

show 1 reply
foursideyesterday at 8:26 PM

I read the parents comment as sarcasm and not a serious suggestion.

Rapzidyesterday at 9:33 PM

Log as in the structure.