fredix 🐧Feb 1
#Litestream intéressant pour mettre en place une réplication en continue d'une base sqlite vers du S3, WebDav, etc
https://litestream.io
Litestream - Streaming SQLite Replication

Litestream is an open-source, real-time streaming replication tool that lets you safely run SQLite applications on a single node.

Reddit Tech VN BotJan 29

Fly.io giới thiệu tính năng Writable VFS mới trong Litestream, cải thiện quy trình sao lưu và phục hồi CSDL SQLite cho lập trình viên. #Litestream #SQLite #Flyio #Côngnghệ #Pháttriểnphầnmềm

https://www.reddit.com/r/programming/comments/1qqgjr9/litestream_writable_vfs/

Show threadTodd SundstedJan 19

Wrapping this thread up, v0.3.13 has been running without problem in production for the last ~3 days. Looks like I'm on the old version...

#litestream

Show threadTodd SundstedJan 17

Ok, v0.5.6 of litestream didn't work—exact same problem (but new issue). I've installed v0.3.13 as my hail mary. Feature-wise litestream is exactly what I want for SQLite backups, so I'm happy to expend a few cycles, but at this point I'm looking at 2+ year old software. 🤷...

#litestream

Runaway disk usage in 0.5.6 · Issue #994 · benbjohnson/litestream

Still getting runaway disk usage in 0.5.6. Steps Starting from working 0.5.2. docker compose down litestream sudo rm -fR /shares/Wx/.wx.db-litestream Edit docker compose image: litestream/litestrea...

GitHub
Todd SundstedJan 17

I just upgraded litestream on my epiktistes.com server from v0.5.3 to v0.5.6 and I am cautiously optimistic. v0.5.3 had a bug that filled up my storage, pegged the CPU, and generally broke my server by locking my ktistec database for 10-20 seconds at a time. I am posting this to deliberately test fate! C'mon... if you're gonna fail again, then fail and get it over with!

#litestream

Litestream - Streaming SQLite Replication

Litestream is an open-source, real-time streaming replication tool that lets you safely run SQLite applications on a single node.

poes 🇵🇸Dec 25

#litestream eating 95% of my CPU, I think this is time to search for replacement.

#FreeBSD

Show threadBryan Dec 13
The #litestream issue I made generated a number of responses, and there was an option that changed from not required to required. (I'll spare you the explanation here since it's all in the above issue.) 😵‍💫

Anyway, in this journey, I also out of desperation asked #ChatGPT, and of course, it gave me nonsense to try. It even had me change the syntax of YAML from a single replica statement to an array of replicas with one entry. I later read that this was old ways of doing things in the 0.3.x series. So now I'll need to go back and fix before the old way is completely deprecated. 😑

I was so irritated I told ChatGPT the actual solution and then it tried to pretend that it was giving me the solution? 😡

ChatGPT also for some reason decided to use an AWS region (us-east-1) instead of Digital Ocean Spaces region(sfo3).
Bryan Dec 13
Tried to get #Litestream working again with #gotosocial but I keep running into 403 errors using #DigitalOcean Spaces for S3. the error is "api error SignatureDoesNotMatch: The request signature we calculated does not match the signature you provided. Check your key and signing method".

This kept repeating until the .sqlite.db-litestream directory filled my disk (about 10x the size of actual DB). Still need to do sqlite backups the old fashioned way: make compressed copy and upload with s3cmd.
GripNewsDec 12
🌕 Litestream VFS：利用 SQLite 擴展功能直接從物件儲存讀取資料
➤ 跳過下載！Litestream VFS 讓 SQLite 直接查詢雲端備份資料
✤ https://fly.io/blog/litestream-vfs/
這篇文章介紹了 Litestream VFS（虛擬檔案系統），一項創新的功能，讓 SQLite 應用程式可以直接讀取儲存在物件儲存（如 S3）上的資料庫備份，無需下載完整檔案。作者 Ben Johnson 詳細解釋了 Litestream 如何透過 LTX（SQLite 資料傳輸檔案格式）的「壓縮」功能，只讀取必要資料頁的最新版本，大幅提升讀取效率。此外，文章還展示瞭如何利用 VFS 外掛程式，讓 SQLite 能夠進行即時的「點時間回復」（PITR），並直接查詢歷史備份資料，為資料庫管理和查詢帶來了前所未有的彈性和便利性。
+ 太棒了！這解決了我一直以來備份 SQLite 資料庫的痛點。再也不用擔心備份檔案越來越大，而且查詢歷史資料變得如此簡單。
+ Lites
#SQLite #Litestream #VFS #資料庫最佳化 #物件儲存
Litestream VFS

Query your SQLite database any time, anywhere

Fly
N-gated Hacker NewsDec 11
🚀 Behold, Fly Blog's dazzling revelation of a "performance optimization" feature that no one asked for, starring #Litestream VFS! 🤡 Wrapped in the usual smorgasbord of tech buzzwords, this post might just optimize your reading time by putting you to sleep faster than a sleeping pill. 🌙💤
https://fly.io/blog/litestream-vfs/ #FlyBlog #VFS #performanceoptimization #techbuzzwords #readingtime #HackerNews #ngated
Litestream VFS

Query your SQLite database any time, anywhere

Fly