this post was submitted on 11 Jul 2025
32 points (92.1% liked)

Programming

26421 readers
68 users here now

Welcome to the main community in programming.dev! Feel free to post anything relating to programming here!

Cross posting is strongly encouraged in the instance. If you feel your post or another person's post makes sense in another community cross post into it.

Hope you enjoy the instance!

Rules

Rules

  • Follow the programming.dev instance rules
  • Keep content related to programming in some way
  • If you're posting long videos try to add in some form of tldr for those who don't want to watch videos

Wormhole

Follow the wormhole through a path of communities !webdev@programming.dev

founded 2 years ago
MODERATORS
snowe@programming.dev
Ategon@programming.dev
UlrikHD@programming.dev
bugsmith@programming.dev
Spyro@programming.dev
32
SQLite alternative with encryption (lemmy.ml)
submitted 9 months ago by Zenlix@lemmy.ml to c/programming@programming.dev
15 comments fedilink hide all child comments
 

I am searching for an SQL lite alternative that implements encryption more or less or of the box and has rust bindings. Do you know of any database systems that fulfill that requirement?

all 17 comments
sorted by: hot top controversial new old
[–] capuccino@lemmy.world 19 points 9 months ago (1 children)

The application encrypts the data, you save in the database the data encrypted. When you retrieve the info, the app decrypt it.

[–] deegeese@sopuli.xyz 11 points 8 months ago (1 children)

This makes it impossible to support any analytical SQL queries against the DB. Look into how to enable encryption at rest on whichever DB you choose.

[–] TootSweet@lemmy.world 11 points 8 months ago

So put an SQLite database on a Luks-encrypted partition or a Luks-encrypted filesystem in a file.

[–] genau@europe.pub 7 points 9 months ago (1 children)

Well, sqlite

[–] yardy_sardley@lemmy.ca 2 points 9 months ago (1 children)

For the low low price of $2000

[–] iamtherealwalrus@lemmy.world 2 points 8 months ago* (last edited 8 months ago)

Which is a rounding error in any commercial business.

[–] fubarx@lemmy.world 6 points 8 months ago

Turso: https://docs.turso.tech/libsql#encryption-at-rest

Also, DuckDB devs said it was planned: https://github.com/duckdb/duckdb/discussions/4512

[–] undefined@lemmy.hogru.ch 6 points 9 months ago

Depending on the application could you just mount a filesystem that supports encryption? Even if it’s just mounting a .tar file.

[–] treadful@lemmy.zip 6 points 8 months ago* (last edited 8 months ago)

SQLCipher fits that bill. I had some issues with language integration but depending on what you're using it might work for you.

[–] WhatAmLemmy@lemmy.world 2 points 9 months ago (1 children)

Encryption is usually implemented in the server or client code. Why do you want the database to handle encryption?

[–] Zenlix@lemmy.ml 2 points 8 months ago (1 children)

It is for as desktop app that stores data on a user drive.

[–] WhatAmLemmy@lemmy.world 1 points 8 months ago (1 children)

Then the application should encrypt the data saved to the db.

I can't think of any scenario where it would make sense for the db to handle encryption.

[–] Zenlix@lemmy.ml 3 points 8 months ago

Encryping by the application would kill the use of a lot of sql features such as SUM.

[–] vane@lemmy.world 2 points 9 months ago

https://github.com/utelle/SQLite3MultipleCiphers/

[–] postall@lemmy.world 2 points 8 months ago

Firebird: 13.8. Database Encryption https://www.firebirdsql.org/file/documentation/chunk/en/refdocs/fblangref30/fblangref30-security-dbcrypt.html