On 11st of December 2024, Masahiko Sawada committed patch: Add UUID version 7 generation function. This commit introduces the uuidv7() SQL function, which generates UUID version 7 as specified in RFC 9652. UUIDv7 combines a Unix timestamp in milliseconds and random bits, offering both uniqueness and sortability. In our implementation, the 12-bit sub-millisecond … Continue reading "Waiting for PostgreSQL 18 – Add UUID version 7 generation function."| select * from depesz;
After adding a regexp for uuids (which are quite hard to regexp for), I discovered that Django offers path converters, making this a piece of cake. I was using old school re_path paths in my urls.py, but it's possible to replace them with path, like this: url_patterns=(path("datalayer …| (not) my ideas
When faced with the problem of identifying entities, most people reach for incremental IDs. Since this requires a central actor to avoid duplicates and can be easily guessed, many solutions depend on UUIDs or GUIDs (universally / globally unique identifiers). However, although being unique solves the first problem, it doesn’t necessarily cover the second. We’ll present our new solution for detecting such issues in web projects in the form of an extension for Burp Suite Pro below.| Silent Signal Techblog