Is it possible to use replica as read-only database?

benbjohnson / litestream

Streaming replication for SQLite.

https://litestream.io

Apache License 2.0

10.79k stars 246 forks source link

Is it possible to use replica as read-only database? #426

Closed diskman closed 2 years ago

diskman commented 2 years ago

Sorry, it might be stupid question but I would really like somehow use replica as read only data source (without need of additional restore). Is it somehow possible to connect using sql lite drivers to replica and use it as read only sql lite db? Currently I have set up which use the replication to s3 bucket and I was thinking to set up SFTP replication to another host where the data could be consumed by some application.

benbjohnson commented 2 years ago

Hi @diskman, sorry, that's not currently possible with Litestream. The closest thing would be something like LiteFS which does live replication and it will have S3 streaming backup support coming soon.