#dbdevelopment — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #dbdevelopment, aggregated by home.social.
-
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