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

Project Samples

Project Activity

See All Activity >

Categories

Libraries

License

MIT License

Follow pgsodium

pgsodium Web Site

Other Useful Business Software
$300 Free Credits to Build on Google Cloud Icon
$300 Free Credits to Build on Google Cloud

New customers can spin up VMs, build with AI, and query data at no cost.

Put your $300 in credit toward real workloads, then keep building with free monthly usage for 20+ products. No commitment and no charge until you upgrade.
Start Free
Rate This Project
Login To Rate This Project

User Reviews

Be the first to post a review of pgsodium!

Additional Project Details

Programming Language

C

Related Categories

C Libraries

Registered

2024-06-05