Mastodawn

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.

https://github.com/ramsey/uuid/issues/536

#PHP #UUID

Uuid v7 generated in wrong order · Issue #536 · ramsey/uuid

Hello, I came across a strange case where the library generated uuid v7 incorrectly in time. Here example of table id = Uuid::uuid7()->toString() and created_at (server datetime), sorted by id (asc...

GitHub

Ben Ramsey Jun 1

I just released ramsey/uuid 4.8.0 with some notable deprecations, especially for those who use the “ordered UUID” functionality in Laravel.

https://github.com/ramsey/uuid/releases/tag/4.8.0

#PHP #Laravel #UUID

Release 4.8.0 · ramsey/uuid

Deprecated The following will be removed in ramsey/uuid 5.0.0: Ramsey\Uuid\Codec\OrderedTimeCodec is deprecated; please migrate to version 6 UUIDs. Ramsey\Uuid\Codec\TimestampFirstCombCodec is dep...

GitHub

Show thread

BluPup DeerPup May 30

@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

#fedora42 #fedora #systemd

.:\dGh/:.May 27

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

PostgreSQL: Using MIN/MAX on UUID columns - Italo Baeza Cabrera - Medium

I had a little beef with PostgreSQL recently. I love the database engine, but I came to understand no every database is perfect, like in this case. Due to some client’s circumstances, they’re tightly…

Medium

.:\dGh/:.May 27

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

.:\dGh/:.May 27

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

Douglas J Hunley May 9

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/

Waiting for PostgreSQL 18 – Add UUID version 7 generation function. – select * from depesz;

Show thread

Karl Voit

Apr 20

@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 😉

#PIM

dot-emacs/config.org at master · novoid/dot-emacs

My GNU/Emacs configuration. Contribute to novoid/dot-emacs development by creating an account on GitHub.

GitHub

Simon Dassow Apr 14

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:

https://github.com/sdassow/go-sort64id

#OpenSource #GoLang #Sort64Id #UUID #Encoding