Skip to content
Tagged articles

pgcrypto

2 articles · Page 1 of 1
java1234
java1234
Oct 9, 2026 · Databases

PostgreSQL 18.6 Deep Dive: Async I/O, Skip Scan, UUIDv7 & More

PostgreSQL 18.6 introduces async I/O with io_uring support, skip scan for composite indexes, time-ordered UUIDv7, virtual generated columns, OAuth authentication, RETURNING old/new values, and critical security fixes for logical decoding and pgcrypto.

GIN IndexGenerated ColumnsOAuth
0 likes · 15 min read
PostgreSQL 18.6 Deep Dive: Async I/O, Skip Scan, UUIDv7 & More
Qunar Tech Salon
Qunar Tech Salon
May 5, 2015 · Databases

Encrypting Sensitive Data with PostgreSQL pgcrypto

This article explains how to protect user privacy by using PostgreSQL's built-in pgcrypto extension to encrypt and decrypt sensitive fields such as phone numbers and ID numbers, showing practical SQL examples for creating tables, altering columns, storing ciphertext, and querying encrypted data.

Database SecurityPostgreSQLSQL
0 likes · 5 min read
Encrypting Sensitive Data with PostgreSQL pgcrypto