pgsodium is an encryption library extension for PostgreSQL using the libsodium library for high-level cryptographic algorithms. pgsodium can be used a straight interface to libsodium, but it can also use a powerful feature called Server Key Management where pgsodium loads an external secret key into memory that is never accessible to SQL. This inaccessible root key can then be used to derive sub-keys and keypairs by key id. This id (type bigint) can then be stored instead of the derived key.
Features
- Documentation available
- Examples available
- Transparent Column Encryption
- Automatically encrypt and decrypt one or more columns of data in a table
- pgsodium requires libsodium >= 1.0.18
- pgsodium is careful to use memory cleanup callbacks to zero out all allocated memory used when freed
- New keys are derived from the primary server secret key by id and an optional context using the libsodium Key Derivation Functions
Categories
LibrariesLicense
MIT LicenseFollow pgsodium
Other Useful Business Software
PRTG Catches Network Issues Before They Cause Downtime
Reactive troubleshooting usually means hearing about a problem from frustrated users, not your monitoring tool. PRTG sets threshold-based alerts across devices, servers and applications, notifying your team by email, SMS or push the moment a metric crosses a set limit. That means catching a failing disk or overloaded server before it becomes an outage and getting time back from firefighting. Start a free trial and set your first alerts today.
Rate This Project
Login To Rate This Project
User Reviews
Be the first to post a review of pgsodium!