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?

  • oni ᓚᘏᗢ@lemmy.world
    link
    fedilink
    arrow-up
    22
    arrow-down
    4
    ·
    1 day ago

    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
      link
      fedilink
      arrow-up
      9
      ·
      1 day ago

      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
        link
        fedilink
        English
        arrow-up
        9
        ·
        1 day ago

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