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

After #TaylorOtwell suggested it, I'm releasing my super-charged #Laravel Seeder.

✅ Seed steps wrapped into transactions
✅ Continue incomplete seeding
✅ Push arguments to each seed step
✅ Retrocompatible with the old `run()`
... and a lot of more features.

https://github.com/Laragear/Populate

#PHP #Database #DB #Seeding #Programming #Composer #Coding #Code #GitHub #Git #Packagist #Software #SoftwareDevelopment #WebDevelopment #WebDev #DatabaseDevelopment #DBDevelopment #Development