How to encrypt the data at rest with datalevin. Is it supported?
Would it be possible to implement encryption on the client side? Could you point me in the right direction, or does encryption need to be implemented inside the database?
Of course, encryption at rest can be achieved at multiple layers. From bottom to top: hardware, e.g HSM, -> Disk, e.g LUKS, FileVault, EBS encryption -> Filesystem, e.g fscrypt -> Database, what I assume you are asking, Datalevin doesn't support it now -> Application, many libraries can do that.
Many SaaS use envelop encryption provided by cloud platform, e.g. AWS KMS, GCP KMS, Azure Key Value, etc. for mult-tenant, i.e. per tenant key management.
If you use a cloud provider, start with cloud disk encryption, add envelop encryption when you have customers, then add application level encryption for sensitive fields. That's it. You normally don't need DB level encryption unless you host your own.
In any case, adding encryption in Datalevin is not a high priority, because there are too many other options.
It's not supported at the moment. Maybe in the future.