Anyone using #litestream for an #sqlite DB

I have a 3GB database, and Litestream is replicating it to another server. However, it seems to be running out of control with disk space. On the original server (where the live DB is) is a generations folder under the hidden litestream folder. It is full of WAL files. Currently over 37,000 files consuming 118GB of disk space.

My config includes retention: 24h and retention-check-interval: 1h with a snapshot-interval: 4h. I understood it would delete anything older than 24 hours. Am I doing something wrong? These wal files go back to the day I started using litestream

#GoToSocial #gts @gotosocial@thefedi.forum

Anyone using #litestream for an #sqlite DB

I have a 3GB database, and Litestream is replicating it to another server. However, it seems to be running out of control with disk space. On the original server (where the live DB is) is a generations folder under the hidden litestream folder. It is full of WAL files. Currently over 37,000 files consuming 118GB of disk space.

My config includes retention: 24h and retention-check-interval: 1h with a snapshot-interval: 4h. I understood it would delete anything older than 24 hours. Am I doing something wrong? These wal files go back to the day I started using litestream

I am continuously amazed how far you can get with ancient tech stacks. :D My ARM-based VPS at Hetzner, with all my #GoLang web apps, using #SQLite with #Litestream for streaming replication, has had zero downtime for over a year now.

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

Kepikiran buat backup db #gotosocial pake #litestream, cuma dbnya udah hampir 2GB, itu di #backblaze nanti jadi brp GB?

I know sqlite3 has become popular again. Has anyone looked at litestream? It can apparently distribute/replicate sqlite3 databases.
https://litestream.io/
#sqlite #sqlite3 #litestream

Ruby on Rails 的 LiteStack 簡介 | AppSignal Blog
➤ Ruby on Rails 的 LiteStack 簡介
✤ https://blog.appsignal.com/2023/09/27/an-introduction-to-litestack-for-ruby-on-rails.html
本文介紹 LiteStack，一個一站式解決方案，可在單臺機器上託管和處理所有生產數據。LiteStack 使用 SQLite 提供數據庫、ActiveJob、ActionCable 和 ActiveSupport::Cache 存儲。此外，本文還介紹了 Litestream 和 StableDiffusion，並提供了一個示例 Rails 應用程序。
+ 這篇文章提供了很好的 LiteStack 簡介，並且還有一個有趣的示例應用程序。
+ 很棒的文章，對於 Ruby on Rails
#Ruby on Rails #LiteStack #SQLite #ActiveJob #ActionCable #LiteCache #Litestream

我全力支持服務器端SQLite · The Fly Blog
➤ SQLite數據庫的歷史和優點，Litestream的介紹和使用方法。
✤ https://fly.io/blog/all-in-on-sqlite-litestream/
本文介紹了SQLite數據庫的優點，並介紹了Litestream，一個開源項目，通過複製實現了SQLite在全棧應用程序中的可行性。Litestream使用SQLite的WAL模式日誌記錄，實現了數據庫的高可用性和並發性。
+ 這篇文章很好地介紹了SQLite數據庫和Litestream的優點，讓我對它們有了更深入的瞭解。
+ Litestream的使用方法很簡單，讓我對在全棧應用程序中使用SQLite數據庫有了更多信心。
#數據庫 #SQLite #Litestream

Trying out Backblaze B2 to store my #Litestream SQLite streaming backups rather than DigitalOcean Spaces. So far, so good, and probably going to be free for a loong time!

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

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

after wrapping some deployments of #sqlite apps with #litestream last weekend, it's a lot of fun to delete kubernetes pods and see that it resumes like nothing happened, despite the lack of external database or persistent volumes

i feel like #selfhosting problems would be much simpler if all apps just use #sqlite paired with #litestream, then consolidate management of storage with minio gonna try it out