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).
#Litestream
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.
🌕 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 #資料庫最佳化 #物件儲存
🚀 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
Using pragmas to do sql queries on database state in the past is 🤯
https://fly.io/blog/litestream-vfs/
It is like sql suddenly got git’s -r parameter
padahal ane mau coba #litestream versi build terbaru, tapi jadi ga bisa coba gara - gara nyimpen ke S3 Neva yang pakai cloudflare.
buka situs nevacloud aja ga bisa, apalagi layanannya semua down.
seperti biasa hasil build untuk #FreeBSD amd64 bisa diunduh dari sini https://egois.org/files/freebsd/
PS: harus siap resiko gagal ya ha ha ha
ternyata #Litestream mulai jalan lagi developmentnya, tapi sayangnya masih belum support dengan #FreeBSD secara langsung. Alhamdulillah di repo ada tapi versi stabil 2 tahun yang lalu 03.13.
sedangkan di #Freshport ada versi terbaru 0.5.2, sayangnya ane males install dari src saat ini. Jadi build sendiri dapat versi development, namun masih belum yakin untuk pakai karena yang 03.13 baik - baik saja.
Just released v0.5.0 of my django-litestream package, now compatible with Litestream 0.5.2.
The main changes include updates to match the new Litestream CLI, and I’ve also removed the old `init` command — it turned out to be completely useless. I also removed dbs auto discovery, I don't remember why I did that initally, but it was clearly a stupid idea.
🔗 https://github.com/Tobi-De/django-litestream/releases/tag/v0.5.0
And in a twist of design, here's doing durable execution directly with #sqlite and an event bus framework in #golang called #watermill.
So just in case you all in go, this may be the way to go instead of #litestream. 😅
#Litestream 0.5 is even more reason just to pick #sqlite. You can get pretty far with litestream and have it fully manageable for duplication.
Lower the N tier of your app. 😉
🎉 Wow, a groundbreaking revelation: 🚨 Behold the miracle of software, where the only certainty is that something will break! 🙈 #Litestream is like that friend who disappears for two years, only to come back and ask for a loan. 💸😂
https://mtlynch.io/notes/hold-off-on-litestream-0.5.0/ #softwaredevelopment #technology #breakthroughs #humor #softwareengineering #HackerNews #ngated
Hold Off on Litestream 0.5.0
https://mtlynch.io/notes/hold-off-on-litestream-0.5.0/
#HackerNews #Hold #Off #on #Litestream #0.5.0 #Litestream #HackerNews #SoftwareUpdate #TechNews
Litestream v0.5.0 is Here - Litestream v0.5.0 is Here
I've been running Litestream to backup SQLite databases i... - https://simonwillison.net/2025/Oct/3/litestream/#atom-everything #ben-johnson #litestream #sqlite #fly
🎉 #Litestream #v0.5.0 has arrived to save the world from your file storage woes with all the fanfare of an #open-source project's desperate attempt to seem relevant. 🚀 Meanwhile, only 3 people care, and one of them is the author's mom. 😂
https://fly.io/blog/litestream-v050-is-here/ #file-storage #tech #news #humor #HackerNews #ngated
Litestream v0.5.0 is here
https://fly.io/blog/litestream-v050-is-here/
#HackerNews #Litestream #v0.5.0 #Release #NewFeatures #Database #Backups #FlyIO
If you’ve got a big (mine is 13G) HomeAssistant home-assistant_v2.db with litestream backups and you’re getting random database is locked errors, try updating to the latest litestream (b3f5b127 is the current commit but there’s a v0.5.0-test.2 tag which might be more “stable”) - all my database is locked errors have gone away.
#Litestream now does compaction. Using s3 condition writes. 😎
#consul is good, but complex when not in infra. Especially for #litefs. Too many moving parts. 😅
Very happy litestream is getting some love. Makes #sqlite even more of a no brainer choice. 😏
https://fly.io/blog/litestream-revamped/
Uuuh, news on the #litestream front for #SQLite! https://fly.io/blog/litestream-revamped/