Re:SQLite is all you need for durable workflows
by nemothekid on Friday May 29, 2026 @05:24PM
(#48329496)
There are so many unfortunate footguns with unlogged tables, that I'd argue that the goroutine route is preferable.
[ Parent
| on HN ]
Re:SQLite is all you need for durable workflows
by petcat on Friday May 29, 2026 @07:27PM
(#48330705)
What are the "footguns" with unlogged tables in Postgres?
Re:SQLite is all you need for durable workflows
by nemothekid on Saturday May 30, 2026 @12:36PM
(#48338087)
1. If postgres shutsdowns uncleanly, your entire table is truncated; you lose everything.
2. You should check if your backup method backs up unlogged tables. For example, RDS Snapshots on AWS do not backup unlogged tables.
These 2 are a double whammy where if you aren't aware of these tradeoffs you can find that a bad restart has deleted all your data, plus your unlogged tables were never backed up.