PostgreSQL 18 introduces significant enhancements for developers, including native UUID v7 support, virtual generated columns, and improved RETURNING clause functionality. These features aim to streamline development processes and improve database performance. Additionally, the EXPLAIN command now provides default buffer usage information, enhancing query analysis.

uuidv47 enables the storage of sortable UUIDv7 in databases while presenting a UUIDv4-like facade at the API level. It employs a deterministic and invertible mapping through a keyed SipHash-2-4 stream, ensuring security and compatibility with RFC standards. The library includes a PostgreSQL extension and offers full testing and performance benchmarks.