benbjohnson/litestream on Hacker News

…on this project. There's a (probably also AI generated) list of a big portion of the issues here: https://github.com/benbjohnson/litestream/issues/1221 . That proposal has been open for a few months, and it seems (from my POV) unlikely to…

comment by Wilduck · 2026-05-30 · in SQLite is all you need for durable workflows

…share some Go+SQLite leanings as someone actually pulling this off? 1) How do you do backups? Do you use github.com/benbjohnson/litestream? CRON job backup with rsync? 2) Any issues with large databases and many clients? Is there a TPS or…

comment by Xeoncross · 2026-05-30 · in SQLite is all you need for durable workflows

Looks like https://github.com/benbjohnson/litestream/issues/1197 . Still open as of now, with a potential cause noted in the latest comment.

comment by irons · 2026-05-30 · in SQLite is all you need for durable workflows

…of pocketbase and litestream, but i can update it if would be helpful/interesting for anyone. [1] https://github.com/benbjohnson/litestream/ [2] https://notes.danielgk.com/Pocketbase/Pocketbase+on+Fly.io

comment by dtkav · 2026-01-24 · in Many Small Queries Are Efficient in SQLite

Author here. Yes, Litestream v0.5.3 has been released with a new read-only VFS option: https://github.com/benbjohnson/litestream/releases/tag/v0.5....

comment by benbjohnson · 2025-12-11 · in Litestream VFS

mtlynch, since you're a litestream+backblaze user, did you encounter this with 0.5.0? https://github.com/benbjohnson/litestream/issues/747

comment by acrispino · 2025-10-14 · in Hold Off on Litestream 0.5.0

…because I needed ARM, and then I just kept copy/pasting my workaround from project to project. [0] https://github.com/benbjohnson/litestream/commit/6acfbcbc64d...

comment by mtlynch · 2025-10-14 · in Hold Off on Litestream 0.5.0

…a few releases instead of this one big one? But there was a beta, and this is ripping the bandaid. https://github.com/benbjohnson/litestream/releases/tag/v0.5....

comment by jasonthorsness · 2025-10-14 · in Hold Off on Litestream 0.5.0

…/bin/litestream Ah, thanks! The litestream Docker image is new as of 0.5.0. [0] https://github.com/benbjohnson/litestream/releases

comment by mtlynch · 2025-10-06 · in Litestream v0.5.0

…object storage services that are hardcoded into the tool.[^2] Big thanks to the developers. [^1]: https://github.com/benbjohnson/litestream/pull/731 [^2]: https://litestream.io/guides/#replica-guides

comment by umajho · 2025-10-03 · in Litestream v0.5.0

…already ran into a bunch of issues. But it seems at least feasible to get it into a working shape. https://github.com/benbjohnson/litestream/issues/772 https://github.com/ncruces/go-sqlite3/compare/main...litestr...

comment by ncruces · 2025-10-03 · in Litestream v0.5.0

…itefs/how-it-works/#capturing-sqlite-tr... Litestream is working on that now - the code is already in https://github.com/benbjohnson/litestream/blob/v0.5.0/vfs.go but it's not yet a working, documented feature.

comment by simonw · 2025-10-03 · in Litestream v0.5.0

Looks like the code is here: https://github.com/benbjohnson/litestream/tree/v0.5 Really nice to see this, I wrote this comment almost 2 years ago when I was a little miffed about trying to use litestream and litefs:…

comment by maxmcd · 2025-05-20 · in Litestream: Revamped

seems like a new release is being worked on: https://github.com/benbjohnson/litestream/pull/636

comment by acrispino · 2025-05-01 · in A faster way to copy SQLite databases between computers

…to just about any UNIX endpoint over SSH. I have a favorite[2] but any SFTP server will do ... [1] https://github.com/benbjohnson/litestream/issues/140 [2] https://www.rsync.net/resources/notes/2021-q3-rsync.net_tech...

comment by rsync · 2025-05-01 · in A faster way to copy SQLite databases between computers

…updates, that can only result in corruption. For replicating sqlite databases safely there is https://github.com/benbjohnson/litestream

comment by bambax · 2025-05-01 · in A faster way to copy SQLite databases between computers

…which Litestream provides all the replication of SQLite databases you need. https://litestream.io https://github.com/benbjohnson/litestream

comment by JSR_FDED · 2025-04-12 · in You might not need WebSockets

You might like https://github.com/superfly/litefs or https://github.com/benbjohnson/litestream

comment by yencabulator · 2025-02-14 · in Show HN: SQLite disk page explorer

…contribution” to Ben's projects. https://github.com/superfly/litefs?tab=readme-ov-file#contri... https://github.com/benbjohnson/litestream?tab=readme-ov-file...

comment by ncruces · 2024-12-10 · in Limbo: A complete rewrite of SQLite in Rust

Litestream is open source. https://github.com/benbjohnson/litestream

comment by frankjr · 2024-05-20 · in Migrating Uber's ledger data from DynamoDB to LedgerStore

…also very much a cool hack in the way it works. The scariness I ran into was related to this issue https://github.com/benbjohnson/litestream/issues/510 And after a bit more fiddling I came away nervous about the possibility of corruption,…

comment by jakebsky · 2024-01-20 · in Ask HN: Are you using SQLite and Litestream in production?

…- https://fly.io/blog/introducing-litefs/ - https://github.com/superfly/litefs - https://github.com/benbjohnson/litestream - https://fly.io/blog/sqlite-internals-wal/ - https://fly.io/blog/wal-mode-in-litefs/ Who really considered sqlite a

comment by ryanrussell · 2023-07-21 · in Fly.io Postgres cluster down for 3 days, no word from them about it

…but apparently it's a parallel project by the same author who Fly hired. https://litestream.io/ https://github.com/benbjohnson/litestream/pull/411

comment by pier25 · 2023-05-19 · in D1: Improvements to performance and scalability

…, so now your SQLite is backed by FoundationDB!? -- - Meanwhile Litestream exists https://github.com/benbjohnson/litestream/ - Ben is developing https://github.com/superfly/litefs at Fly so that you can talk to your SQLite through a FUSE fi

comment by maxmcd · 2023-01-25 · in SQLite-based databases on the Postgres protocol

then there is https://github.com/benbjohnson/litestream

comment by somedude82 · 2023-01-05 · in LiteSync – Easy synchronization of SQLite databases

…actually doesn't do replication that way any more -- I stumbled upon this commit like 2 days ago: https://github.com/benbjohnson/litestream/pull/411 [EDIT] - I indulged myself: https://news.ycombinator.com/item?id=33204347

comment by hardwaresofton · 2022-10-14 · in Postgres Full Text Search vs. the Rest

…with rsync.net[1][2] ? How does that compare/contrast with what my grandparent is alluding to ? [1] https://github.com/benbjohnson/litestream/issues/140 [2] https://www.rsync.net/resources/notes/2021-q3-rsync.net_tech...

comment by rsync · 2022-09-21 · in LiteFS

…post, the next steps are to add read replicas. Regarding backups, that's possible with Litestream: https://github.com/benbjohnson/litestream

comment by jensneuse · 2022-09-15 · in Show HN: WunderBase – Serverless OSS database on top of SQLite, Firecracker

…dropped. Author did mention a separate tool they're working on which will include live replication. https://github.com/benbjohnson/litestream/issues/8#issuecomm...

comment by oefrha · 2022-09-10 · in Transcending Posix: The End of an Era?

Checkout quite interesting replication projects https://github.com/superfly/litefs and https://github.com/benbjohnson/litestream

comment by bobek · 2022-08-16 · in SQLite is not a toy database (2021)

Are you saying litestream is deprecated or some specific feature? I see its very active https://github.com/benbjohnson/litestream

comment by davydog187 · 2022-08-12 · in Ask HN: Who is using C++ as the main language for new project?

…for only the comparatively easy ranged data exploration. [1] https://github.com/rqlite/rqlite [2] https://github.com/benbjohnson/litestream

comment by metadat · 2022-05-23 · in SQLite may become foundational for digital progress

In which scenario would you use litestream[1] vs rqlite[2]? 1 - https://github.com/benbjohnson/litestream 2 - https://github.com/rqlite/rqlite

comment by obiwanpallav1 · 2022-05-10 · in I'm all-in on server-side SQLite

…same container and call it "Backed in a Box" :) [1] https://github.com/subzerocloud/blue-steel [2] https://github.com/benbjohnson/litestream edit: typo

comment by ruslan_talpa · 2022-04-03 · in SQLite B-Tree Module

…s3 is used for a cold backup that can be quickly restored to a fresh node as far as i know. https://github.com/benbjohnson/litestream/issues/8

comment by billywhizz · 2022-04-02 · in A database for 2022

…I'm curious how these tools will mature, it seems like a good match for microservices. [1]: https://github.com/benbjohnson/litestream [2]: https://www.sqlite.org/sessionintro.html

comment by infogulch · 2022-04-01 · in A database for 2022

…Litestream loosened their contribution policy, and they now accept bugfixes but not new features: https://github.com/benbjohnson/litestream#contribution-polic...

comment by mtlynch · 2022-03-16 · in My boundaries as an open source developer

…an issue/PR on Huey suggesting adding a similar disclaimer, but it’d probably be closed, ha. [0] https://github.com/benbjohnson/litestream#contribution-polic...

comment by elderlydoofus · 2022-02-28 · in How to take credit for someone else's work on GitHub

Shout out to litestream[0] for backups [0] https://github.com/benbjohnson/litestream

comment by matdehaast · 2021-12-29 · in Consider SQLite

…it can by replicating the db to a file. Another option is to back it up over the network, e.g., https://github.com/benbjohnson/litestream

comment by pstuart · 2021-11-23 · in Back to basics: Writing an application using Go and PostgreSQL

…similarly you can have open source without built in community/discord/project-management/etc. [0]: https://github.com/benbjohnson/litestream#open-source-not-op...

comment by hardwaresofton · 2021-09-14 · in RIP Jekyll (The Genesis of the Jamstack)

…Now that I know two folks do it, I'll have to give it serious thought. Thanks for the blog post ref https://github.com/benbjohnson/litestream

comment by otoolep · 2021-06-10 · in Rqlite 6.0: the evolution of a distributed database design

…those WAL pages and determine the changed data. That is something that's on the roadmap though: https://github.com/benbjohnson/litestream/issues/129

comment by benbjohnson · 2021-04-30 · in Listen to your to PostgreSQL database in realtime via WebSockets

…- https://www.sqlite.org/rtree.html - https://github.com/sqlcipher/sqlcipher - https://github.com/benbjohnson/litestream - https://github.com/aergoio/aergolite - https://sqlite.org/lang_with.html#rcex3 - https://github.com/sql-js/sql.js

comment by hardwaresofton · 2021-04-15 · in SQLite the only database you will ever need in most cases

I feel like more and more developers are opting for the second form. I'm reminded of litestream ( https://github.com/benbjohnson/litestream ) for example that is closed to contribution

comment by rakoo · 2021-03-29 · in It Doesn't Work

You could probably use something like https://github.com/benbjohnson/litestream to backup your signal db.

comment by cfstras · 2021-02-28 · in Signal Desktop is corrupting its database

On the GitHub repo ( https://github.com/benbjohnson/litestream ), it saids: "Litestream only communicates with SQLite through the SQLite API so it will not corrupt your database." Does that mean I can use an in memory SQLite DB and have it…

comment by hangonhn · 2021-02-11 · in Why I Built Litestream

…moot. That being said, there is a JSON extension for SQLite[2] although I haven't tried it. [1] https://github.com/benbjohnson/litestream/issues/41 [2] https://www.sqlite.org/json1.html

comment by benbjohnson · 2021-02-11 · in Why I Built Litestream

…level: https://github.com/rqlite/rqlite VFS Level: https://github.com/canonical/dqlite Block Level: https://github.com/benbjohnson/litestream Really cool enhancements to an awesome project!

comment by mech422 · 2021-01-22 · in Rqlite: The lightweight, distributed relational database built on SQLite

…of replication has scared me away. Streaming backup for now. And live replication in the issues. https://github.com/benbjohnson/litestream/issues/8

comment by feep · 2021-01-22 · in Litestream – Streaming S3 Replication for SQLite