libsql icon indicating copy to clipboard operation
libsql copied to clipboard

The story around backups to S3 is unclear

Open jazoom opened this issue 3 months ago • 3 comments

The libsql SDK docs don't mention backups to S3, but it is mentioned in this blog post:

https://turso.tech/blog/fully-open-source-encryption-for-sqlite-b3858225

So after features like native replication, automatic backups to S3 and a serverless mode, we are adding to libSQL yet another feature that is critical to production workloads: encryption at rest.

The article goes on talking about the libsql client.

const db = createClient({
  url: 'file:sqlite-enc.db',
  encryptionKey: process.env.ENCRYPTION_KEY,
});

As far as I can tell, sending encrypted backups to S3 like this is not supported.

I can see there is something called "bottomless" for libsql-server.

https://github.com/tursodatabase/libsql/tree/main/libsql-server

But that doesn't apply if one is using a local file, such as in the blog post, correct?

I'd like something like Litestream, for an encrypted local file libsql database.

jazoom avatar Apr 01 '24 12:04 jazoom