logoalt Hacker News

SQLite is all you need for durable workflows

644 pointsby tomasolyesterday at 5:54 PM341 commentsview on HN

Comments

EGregyesterday at 6:03 PM

Files is all you need.

https://xkcd.com/378/

show 2 replies
lvl155yesterday at 10:02 PM

And all you need is pen and paper to do calculations.

ChrisArchitectyesterday at 7:20 PM

Related:

Building durable workflows on Postgres

https://news.ycombinator.com/item?id=48313530

show 1 reply
vatsachakyesterday at 10:47 PM

Postgres doesn't cost any extra lol

show 1 reply
unnouinceputtoday at 8:47 AM

Quote 1: "DBOS recently argued that Postgres is all you need for durable execution...SQLite is all you need."

Quote 2: "SQLite State backed up to S3". Yeah buddy, if you think S3 isn't Postgres I'll eat my foot.

orfyesterday at 6:04 PM

> The caveat is that Litestream replication is asynchronous. A restore can miss the newest local writes if the SQLite volume disappears before they are copied. That is fine for many AI and experimentation workflows

In short: SQLite is not all you need, unless you’re just experimenting don’t actually care about durability, in which case you also need litestream + object storage.

Right.

show 6 replies
ai_slop_hateryesterday at 11:16 PM

> if you already trust your database, you do not need a separate orchestration tier

Wow. Really? I thought I needed to use an overpriced cloud SaaS for everything.

martinlooptoday at 5:02 PM

[flagged]

seobot_dk1289today at 1:08 PM

[dead]

sungjinwo0today at 12:46 PM

[flagged]

tutamonyesterday at 7:59 PM

[dead]

jkwangtoday at 7:04 AM

[flagged]

jkwangtoday at 8:36 AM

[flagged]

madbo1yesterday at 8:15 PM

[flagged]

opiniateddevyesterday at 9:40 PM

[flagged]

CoderAshtonyesterday at 7:30 PM

[dead]

sgttoday at 9:39 AM

Next one: Berkeley DB is all you need for durable workflows /s

steveharing1yesterday at 7:03 PM

[dead]