Postgres 18 to Feature UUIDv7: No More ID Sorting Headaches in Tests

2025-01-02

PostgreSQL is set to include UUIDv7 support in version 18. This improved UUID generation method retains the randomness benefits of UUIDv4 while ensuring monotonically increasing IDs within a single Postgres backend. This is achieved by incorporating a timestamp and a 12-bit sub-millisecond counter. Testing is greatly simplified as test data is automatically ordered, eliminating the need for manual sorting and improving test efficiency and reliability. While monotonicity isn't guaranteed across backends, it's sufficient for most testing scenarios. This enhancement is slated for release in late 2025 with PostgreSQL 18.

Read more
Development

Stripe Quietly Launches V2 API: REST Improvements and DX Shift

2024-12-29

Stripe quietly released its V2 API in October, featuring a shift from form-encoded request bodies to JSON and the introduction of HATEOAS-style pagination. V2 aims for speed improvements and controlled sub-object loading via an `include` parameter. True idempotency is also attempted for better handling of failed requests. However, improvements are still needed in REST verb usage and resource modeling. The author argues that a great developer experience (DX) now hinges more on high-quality SDKs than a perfect REST API.

Read more
Development