#litestream — Public Fediverse posts

Entah kenapa kok #litestream komplain katanya data di replikasi lebih terbaru dibanding di db asli. Apa #gotosocial ada aktivitas nge-rebuild db kah? Jadi txid nya ke-reset dari awal?

Entah kenapa kok #litestream komplain katanya data di replikasi lebih terbaru dibanding di db asli. Apa #gotosocial ada aktivitas nge-rebuild db kah? Jadi txid nya ke-reset dari awal?

Entah kenapa kok #litestream komplain katanya data di replikasi lebih terbaru dibanding di db asli. Apa #gotosocial ada aktivitas nge-rebuild db kah? Jadi txid nya ke-reset dari awal?

Entah kenapa kok #litestream komplain katanya data di replikasi lebih terbaru dibanding di db asli. Apa #gotosocial ada aktivitas nge-rebuild db kah? Jadi txid nya ke-reset dari awal?

Setelah kenalan sama litestream buat replikasi sqlite ke s3, sekarang giliran penjajakan sama "wal-g" buat nge-archive file wal database termasuk postgres.

wal-g/wal-g: Archival and Restoration for databases in the Cloud

https://github.com/wal-g/wal-g

#walg #postgres #postgresql #replication #s3 #litestream #sqlite #walfile

Setelah kenalan sama litestream buat replikasi sqlite ke s3, sekarang giliran penjajakan sama "wal-g" buat nge-archive file wal database termasuk postgres.

wal-g/wal-g: Archival and Restoration for databases in the Cloud

https://github.com/wal-g/wal-g

#walg #postgres #postgresql #replication #s3 #litestream #sqlite #walfile

Setelah kenalan sama litestream buat replikasi sqlite ke s3, sekarang giliran penjajakan sama "wal-g" buat nge-archive file wal database termasuk postgres.

wal-g/wal-g: Archival and Restoration for databases in the Cloud

https://github.com/wal-g/wal-g

#walg #postgres #postgresql #replication #s3 #litestream #sqlite #walfile

Setelah kenalan sama litestream buat replikasi sqlite ke s3, sekarang giliran penjajakan sama "wal-g" buat nge-archive file wal database termasuk postgres.

wal-g/wal-g: Archival and Restoration for databases in the Cloud

https://github.com/wal-g/wal-g

#walg #postgres #postgresql #replication #s3 #litestream #sqlite #walfile

GitHub - Tobi-De/django-litestream: Django integration with litestream, a standalone streaming replication tool for SQLite.

"Django integration with litestream, a standalone streaming replication tool for SQLite. - Tobi-De/django-litestream"

Link: https://github.com/Tobi-De/django-litestream

#linkdump #backup #django #litestream #sqlite

GitHub - Tobi-De/django-litestream: Django integration with litestream, a standalone streaming replication tool for SQLite.

"Django integration with litestream, a standalone streaming replication tool for SQLite. - Tobi-De/django-litestream"

Link: https://github.com/Tobi-De/django-litestream

#linkdump #backup #django #litestream #sqlite

Dapat manfaat dari deploy dan maintain gotosocial. Berkat doc nya, jadi tau sqlite bisa replikasi pakai litestream.

Ada beberapa project yang pakai sqlite. Jadi PR sekarang adalah pasang litestream buat yang perlu diamankan datanya.

Jadi makin pede juga kalo develop yang db-nya gak butuh DBMS serius dan menghindari dependency infra yang gimana, pakai aja sqlite.

https://litestream.io/

#gotosocial #sqlite #litestream

#Litestream intéressant pour mettre en place une réplication en continue d'une base sqlite vers du S3, WebDav, etc
https://litestream.io

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/

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

#FreeBSD

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).

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.

🚀 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

🚀 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

🚀 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

https://fly.io/blog/litestream-vfs/

#HackerNews #Litestream #VFS #Litestream #VFS #Blog #Flyio #Tech #Innovation

Litestream VFS

https://fly.io/blog/litestream-vfs/

#HackerNews #Litestream #VFS #Litestream #VFS #Blog #Flyio #Tech #Innovation

Litestream VFS

https://fly.io/blog/litestream-vfs/

#HackerNews #Litestream #VFS #Litestream #VFS #Blog #Flyio #Tech #Innovation

Litestream VFS

https://fly.io/blog/litestream-vfs/

#HackerNews #Litestream #VFS #Litestream #VFS #Blog #Flyio #Tech #Innovation

Litestream VFS

https://fly.io/blog/litestream-vfs/

#HackerNews #Litestream #VFS #Litestream #VFS #Blog #Flyio #Tech #Innovation

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

#sqlite #litestream

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

#django #sqlite #litestream

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. 😅

https://threedots.tech/post/sqlite-durable-execution/

#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. 😉

https://fly.io/blog/litestream-v050-is-here/

🎉 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 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

Litestream v0.5.0 is here

https://fly.io/blog/litestream-v050-is-here/

#HackerNews #Litestream #v0.5.0 #Release #NewFeatures #Database #Backups #FlyIO

Litestream v0.5.0 is here

https://fly.io/blog/litestream-v050-is-here/

#HackerNews #Litestream #v0.5.0 #Release #NewFeatures #Database #Backups #FlyIO

Litestream v0.5.0 is here

https://fly.io/blog/litestream-v050-is-here/

#HackerNews #Litestream #v0.5.0 #Release #NewFeatures #Database #Backups #FlyIO

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.

#HomeAssistant #Litestream #SQLite

#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/

#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/

#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/

#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/

#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/

Ah, the modern world of tech blogs where every developer's fever dream is a reality 🌈🔧. "Litestream: Revamped" promises #optimization but comes with a side dish of more logos and #branding assets than you can stomach. Because who doesn't love a good ol' RSS feed? 😴📉
https://fly.io/blog/litestream-revamped/ #techblogs #Litestream #RSSfeed #developerlife #HackerNews #ngated

Litestream: Revamped

https://fly.io/blog/litestream-revamped/

#HackerNews #Litestream #Revamped #Litestream #Database #Updates #Tech #Innovation #FlyIO

Jarang pake instance #memos yang update, soalnya masih make yang versi 0.22 karena settingan #s3 nya masih masuk akal. Kalau pake R2 sih ga masalah, tapi kalo S3nya pake #minio, itu yang bikin repot.

Tapi ada instance yang satu lagi yang sengaja saya bikin update karena ga pake settingan #S3 tapi #local storage.

Kalau update harus update Dockerfile dulu dan di push ke docker hub. Karena server untuk build sama server untuk host memos beda.

Bagi yang mau make memos yang udah otomatis terinstall #litestream bisa gunakan image ini : https://hub.docker.com/r/putraeka/memos-litestream

soooo close to getting my evil #datomic on #sqlite+#litestream idea running and I’m now running into an undebuggable fly.io error 😵‍💫😭

Well, this sure is neat. https://fly.io/blog/litefs-cloud/

I’ll be very curious to see how much it ends up costing.

#SQLite #Litestream #LiteFS