{"repo":"michelp/pgsodium","free":true,"listed":false,"github":"https://github.com/michelp/pgsodium","clone":"git clone https://github.com/michelp/pgsodium.git","description":"Modern cryptography for PostgreSQL using libsodium.","language":"C","stars":609,"topics":["postgresql","cryptography","library","encryption","decryption","libsodium","sql"],"license":null,"category":"databases-storage","readme_excerpt":"pgsodium 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 . Another advanced feature of pgsodium is Transparent Column Encryption which can automatically encrypt and decrypt one or more columns of data in a table. Table of Contents pgsodium Installation Usage Server Key Management Server Key Derivation Key Management API Security Roles Transparent Column Encryption Simple public key encryption with crypto box() Avoid secret logging API Reference Generating Random Data Secret key cryptography Authenticated encryption Authentication Public key cryptography Authenticated encryption Public key signatures Sealed boxes Hashing Password hashing Key Derivation Key Exchange HMAC512 Advanced Stream API XChaCha20-SIV Signcryption Installation pgsodium requires libsodium = 1.0.18. In addition to the libsodium library and it's development headers, you may also need the PostgreSQL header files typically in the '-dev' packages to build the extension. After installing the dependencies, clone the repo and run sudo make install . You can also install pg","default_branch":null,"files":null,"tree":[],"storefront":"/r/michelp","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/michelp/pgsodium/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}