PostgreSQL 18, set for release in September, introduces features aimed at enhancing analytics capabilities and distributed architectures, including a new asynchronous I/O subsystem that significantly boosts performance for analytical workloads. The update also upgrades UUIDs to version 7 to improve database index performance in distributed systems, although some anticipated SQL features will be delayed. Despite its growing popularity among developers, PostgreSQL has traditionally been more associated with online transaction processing rather than analytics.
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.