This is a particularly concerning issue in ramsey/uuid, though the severity is low, since the worst case scenario is that some UUIDs are out of sort order, but I’d still like to get to the bottom of it.
If you’re able to help debug the issue, please feel free to take a look.
The reports all say the symfony/uid library doesn’t have this problem, which is even more confusing, since I borrowed the monotonicity algorithm from it.
I just released ramsey/uuid 4.8.0 with some notable deprecations, especially for those who use the “ordered UUID” functionality in Laravel.
@Rusty oh I stay away from disk encryption unless a client wants it. Asking for trouble imo.
I mean I'm fairly certain:
❯ cat /etc/fstab
#
# /etc/fstab
# Created by anaconda on Wed Nov 30 09:52:38 2022
#
# Accessible filesystems, by reference, are maintained under '/dev/disk/'.
# See man pages fstab(5), findfs(8), mount(8) and/or blkid(8) for more info.
#
# After editing this file, run 'systemctl daemon-reload' to update systemd
# units generated from this file.
#
# Loading NTFS drives on boot this way crashes things!
#UUID=EA7ABE37-CA60-4C08-B246-A8C85BA19F42 /run/media/Kion/Archives ntfs defaults 0 2
UUID=5cc84ef9-a89c-4e3e-abc2-85786d7efa41 /run/media/Kion/Games\040Linux ext4 defaults 0 2
UUID=619c27e8-9454-437b-8cea-8739b2acc718 / btrfs subvol=root00,compress=zstd:1 0 0
UUID=531cf70d-977e-4e77-a7b7-5661d95de35d /boot ext4 defaults 1 2
UUID=FA93-7CEB /boot/efi vfat umask=0077,shortname=winnt 0 2
UUID=619c27e8-9454-437b-8cea-8739b2acc718 /home btrfs subvol=home00,compress=zstd:1 0 0
Eventually, I came with my own solution to handle `MIN` and `MAX` in #PostgreSQL with UUID columns (with UUID v7).
https://darkghosthunter.medium.com/postgresql-using-min-max-on-uuid-columns-51e52927e6a0
#Programming #Coding #Code #SQL #UUID #Postgres #Database #DB #Databases #RDBMS #SoftwareDevelopment #WebDevelopment #WebDev #DatabaseDevelopment #DBDevelopment #Tutorial #Blog
It's with my utter dissatisfaction to confirm y'all that PostgreSQL 18 doesn't support `MAX|MIN` aggregates over a UUID column.
😥
This means, you will need to creates the functions I already described... or just plug in Microsoft SQL Server, MySQL or MariaDB as alternatives.
#Programming #Database #Databases #SQL #DB #PostgreSQL #Postgres #SoftwareDevelopment #DatabaseDevelopment #DBDevelopment #WebDevelopment #WebDev #UUID #Technology
Guess you *can* hack your way up in PostgreSQL for using `MIN(uuid)` and `MAX(uuid)`.
This involves:
1. Creating a function to compare UUID as binary.
2. Create MIN and MAX aggregates uses the function.
3. Create a function to transform UUID into binary.
4. Create additional indexes that use the UUID as binary.
Or you can just install Microsoft SQL Server and invoke the antichrist.
#Programming #SQL #Database #DB #Databases #UUID #PostgreSQL #Postgres #Coding #Code #SQLServer
Waiting for #PostgreSQL 18 – Add #UUID version 7 generation function. – select * from depesz; https://www.depesz.com/2024/12/31/waiting-for-postgresql-18-add-uuid-version-7-generation-function/
@confusedalex Pro mode: label each physical device with the #UUID of your #Orgmode heading for it.
Honestly: don't use #UUIDs for that. Please do use something human-readable like slugs: https://github.com/novoid/dot-emacs/blob/master/config.org#my-id-get-or-generate 😉
I've made a thing! A new version of an UUID encoding I came up with 12+ years ago. There might even be one or two people here who remember me giving my first Tech Talk at work about this back then.
Next to the PostgreSQL version that I shared, I always had implementations in the languages I worked with, and I improved the encoding a bit further in the last years, and just published an implementation in Go:
Needed a UUID generator. Now I got one:
https://eklem.github.io/uuid/
Based on: crypto.randomUUID()
I just released the first major update for the ULID unique ID generation library in over 8 years! I’ve been following it as a user for years, having even forked it for ulidx when it wasn’t being maintained. It’s fulfilling to not only see it updated (as I use it a lot), but having done so myself.
If you’re building a new feature and are about to reach for an ID generator (like UUID), you might consider trying ULIDs instead: https://github.com/ulid/javascript
Here's a throwback! Learn all about UUIDs in this classic article by Starr Horne.
https://www.honeybadger.io/blog/uuids-and-ulids/?utm_source=mastodon&utm_medium=social
Every UUID — https://everyuuid.com #UUID4 #UUID #ID
#Pipelight typescript issue fixed.
It was a nasty bug that slide in with #deno 2.2.
Fixed by replacing external #UUID library with bultins uuid library.
This type of heartful message is what keeps me sharing my best code with you. ☺
Show HN: Generate Version 7 UUID's for a Timestamp
https://uuidv7.org/
#ycombinator #uuidv7 #uuid #generator #date_based_uuid #time_based_uuid #version7 #online_tools
Generating Unique Identifiers for IBM i Databases: A Comprehensive Guide
Learn how to generate unique identifiers in IBM i databases using various methods, including IBM i Unique ID, UUIDs, and sequences. Ensure data integrity and efficient DB2 LUW management. #IBMi #UniqueID #DB2LUW #UUID #Sequence #DataIntegrity
https://tech-champion.com/database/db2luw/generating-unique-identifiers-for-ibm-i-databases-a-comprehensive-guide/
В PostgreSQL необходим официальный бенчмарк для функции uuidv7()
В 18 версии PostgreSQL появится функция uuidv7() . Она разработана для замены последовательных автоинкрементных идентификаторов SERIAL, BIGSERIAL и IDENTITY, которые могут привести к катастрофическому дублированию ключей при слиянии данных, и для замены более медленных UUIDv4. Использование функции uuidv7() позволит упростить архитектуру информационных систем, упростить SQL-запросы, избежать некоторых ошибок, облегчить внесение изменений и благодаря этому повысить надежность и снизить стоимость разработки и сопровождения информационных систем. Однако для объективной и корректной оценки использования функции uuidv7() необходим официальный бенчмарк в PostgreSQL. Без такого бенчмарка может быть сделан необоснованный выбор в пользу автоинкремента.
#UUIDv7 introduces an entirely new time-based #UUID bit layout utilizing a variable length timestamp sourced from the widely implemented and well known Unix #Epoch timestamp source https://www.ietf.org/archive/id/draft-peabody-dispatch-new-uuid-format-01.html
Calling uuid-ossp fails because there's nothing of value in uuid-ossp.control
Calling uuid and uuid_generate_v4() both work and v4 gives me a prompt to do something.
What is uuid-ossp.control actually looking for?
If I knew what was supposed to be in that file I could figure out how to fix the Akkoma compile crash..
I'm gonna poke around in that directory and try to see what the actual format of a .control file is.
Creating Deterministic UUIDs with UUIDv5 and X.500. #UUID #PHP #symfony
https://zavyn.blogspot.com/2024/12/creating-deterministic-uuids.html
