News for hackers. Stuff that matters.

A comment on A faster way to copy SQLite databases between computers. Parent comment

Re:A faster way to copy SQLite databases between computers by rsync on Thursday May 01, 2025 @04:11PM (#43862801)
"For replicating sqlite databases safely there is (litestream) ..."

A reminder that litestream can run over plain old SFTP[1] which means you can stream database replication 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...

[ Parent | on HN ]
Re:A faster way to copy SQLite databases between computers by aitchnyu on Friday May 02, 2025 @02:52AM (#43866911)
Whats the closest counterpart in Postgres ecosystem?
[ Parent | on HN ]
Re:A faster way to copy SQLite databases between computers by j16sdiz on Friday May 02, 2025 @06:43AM (#43868120)
log shipping[1] or logical replication[2]

[1] https://www.postgresql.org/docs/current/warm-standby.html [2] https://www.postgresql.org/docs/current/logical-replication....

[ Parent | on HN ]
Re:A faster way to copy SQLite databases between computers by rsync on Friday May 02, 2025 @03:06PM (#43873574)
This isn't what you mean but I can't resist:

  pg_dump -U postgres db | ssh [email protected] "dd of=db_dump"
[ Parent | on HN ]