Can I use this with non-AWS storage providers?

Absolutely. The skill includes specific configurations for S3-compatible providers like Hetzner Object Storage, Backblaze B2, and DigitalOcean Spaces, including the critical force-path-style setting.

How does Litestream affect application performance?

Litestream runs as a separate process and reads from SQLite's Write-Ahead Log (WAL) files. By using a read-only mount in production, it provides backups with negligible impact on your application's primary database performance.

Is point-in-time recovery supported?

Yes, the skill provides specific disaster recovery commands that allow you to restore your database to a specific timestamp, which is essential for recovering from accidental data deletion.

Does this work with Rails versions older than 8?

Yes, while it is optimized for Rails 8 defaults like Solid Queue and Solid Cache, the Litestream configuration patterns work for any Rails application using SQLite as its database.

Litestream for Rails

Name: Litestream for Rails
Author: majesticlabs-dev

bymajesticlabs-dev

•

Database Management

Configures continuous SQLite backups for Rails 8+ applications using Litestream and S3-compatible storage.

About

This skill streamlines the setup of Litestream to provide real-time, streaming backups for SQLite databases in modern Rails environments. It specifically addresses the needs of Rails 8 applications utilizing Solid Queue, Solid Cache, and Solid Cable by providing optimized retention strategies for different database types, seamless Kamal 2 deployment configurations, and clear disaster recovery procedures. By automating the configuration of WAL-based replication to S3, it ensures data durability and high availability for SQLite-backed applications without the operational overhead of traditional database servers.

Key Features

Compatibility support for major S3 providers including Hetzner, Backblaze, and DigitalOcean
Optimized retention and sync intervals tailored by database usage patterns
Automated configuration for multi-database Rails 8 setups (Queue, Cache, Cable)
Pre-defined disaster recovery and point-in-time recovery command templates
Seamless Kamal 2 accessory integration for containerized deployments
18 GitHub stars

Use Cases

Deploying SQLite-backed apps to VPS environments using Kamal 2
Implementing point-in-time recovery for critical application data
Setting up production-grade backups for a Rails 8 SQLite-only stack

About

Key Features

Compatibility support for major S3 providers including Hetzner, Backblaze, and DigitalOcean
Optimized retention and sync intervals tailored by database usage patterns
Automated configuration for multi-database Rails 8 setups (Queue, Cache, Cable)
Pre-defined disaster recovery and point-in-time recovery command templates
Seamless Kamal 2 accessory integration for containerized deployments
18 GitHub stars

Use Cases

Deploying SQLite-backed apps to VPS environments using Kamal 2
Implementing point-in-time recovery for critical application data
Setting up production-grade backups for a Rails 8 SQLite-only stack