Mastodawn

🚀 Oh joy, yet another "revolutionary" GitHub wrapper that promises to make #Postgres as light as a feather, just like #SQLite. 🙄 Because, obviously, all your database woes can be solved with a few lines of Python magic.✨ Spoiler alert: it's as useful as a parachute in a submarine. 🐢
https://github.com/wey-gu/py-pglite #GitHubWrapper #DatabaseDevelopment #SoftwareHumor #HackerNews #ngated

GitHub - wey-gu/py-pglite: PGlite wrapper in Python for testing. Test your app with Postgres just as lite as SQLite.

PGlite wrapper in Python for testing. Test your app with Postgres just as lite as SQLite. - wey-gu/py-pglite

GitHub

.:\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 22

How difficult can be creating an hypertable in TimescaleDB?

It seems that pretty much of a fucking lot.

#PostgreSQL #TimescaleDB #Hypertable #Hypertables #SQL #RDBMS #RelationalDatabase #Database #Databases #Programming #SoftwareDevelopment #DatabaseDevelopment

.:\dGh/:.May 9

Totally forgot that Laravel News published my new package for modernising the old Laravel Seeder:

https://laravel-news.com/populate

#Laravel #PHP #Programming #Coding #Code #SoftwareDevelopment #WebDevelopment #WebDev #Seeding #Database #SQL #DatabaseDevelopment #RDBMS #Github #Git #SourceCode #Packagist #Composer

Nebraska.Code Apr 30

Jerry Nixon gives 'A Developer's Guide to Database Patterns' July 24th at Nebraska.Code().

https://nebraskacode.amegala.com/

#sourcecontrol #unittesting #cicdautomation #linting #SQL #qualitymeasurements #TechnologyConference #Nebraska #databasepatterns #softwaredeveloper #programminglife #databases #DeveloperGuide #databasedevelopment #tech

Nebraska.Code 2025 hosted on Whova

July 23 – 25, 2025, Lincoln, NE

Upscene Productions Apr 28

ANN: Database Workbench 6.7.0 released

- ability to view vector embeddings in PostgreSQL
- quick CSV import/export
- faster foreign key creation
- bugfixes in PostgreSQL, Firebird, InterBase and SQLite modules

https://www.upscene.com/news/item/20250425

#MySQL
#MariaDB
#SQLServer
#Oracle
#Firebird
#InterBase
#PostgreSQL
#NexusDB
#databasetools #databasedevelopment #DatabaseWorkbench

News @ Upscene Productions

Upscene: Database tools for developers. Database tools for Oracle, PostgreSQL, InterBase, Firebird, SQL Server, MySQL, NexusDB, SQL Anywhere and Advantage Database. Auditing tools for databases. Test Data Generator tools for databases.

.:\dGh/:.Apr 25

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