heise+ | Sprachmodelle aus SQL: pgai erweitert PostgreSQL um KI-Funktionen
Die PostgreSQL-Erweiterung pgai verknüpft ohne zusätzliche Middleware Daten und Sprachmodelle in einem System. LLMs lassen sich so aus SQL aufrufen.
Django: Deferred constrain enforcement
Another Friday, another Django related post. I guess this blog is becoming a bit monothematic. I promise the next ones will bring the much-needed diversity of contents, but today let’s explore a very useful feature of the Django’s ORM.
Ok… Ok… it’s more of a feature of PostgreSQL that Django supports, and it isn’t available on the other database backend. But let’s dive in any way. […]
POSETTE - An Event for Postgres
A virtual developer event
10-12 Jun, 2025
Also, important PSA if you're working with #Rails, (and this may actually be a #Ruby thing, or maybe a #PostgreSQL thing, or combination):
I was trying to run a seeds.rb file to load data into my test env db. That script references an external (local) file with a bunch of items, each line being correctly formed data for an ltree path.
I kept getting errors on line one. I tried a bunch of things, and none worked.
Turns out my text file had a UTF-8 BOM, and script no likey.
3+h of madness.
Any database wizards out there?
I have a table with an ID column. The ID column is unique together with a valid date, so the ID itself is not unique.
However, I also need a name column that is unique under the condition that any given name can only correspond to one specific ID (but not necessarily the other way around).
The database is PostgreSQL. Is it possible to formulate, for instance, a UNIQUE INDEX to achieve this?
Edit: Solved 
Summoning all #dataengineers, #AI enthusiasts, and #RAG masterminds - join us at #VSCON25 June 6th to expand your knowledge and network with global developers from #Google, #Oracle, and #Microsoft!
Sign up at: http://vsearchcon.com
@axboe I saw uring is getting used in #PostgreSQL , I wonder did you see any performance benchmarks or heard numbers maybe on with vs without uring ?
We are hiring a talented PostgreSQL expert in my team.
Large EU Fintech/banking organization. Thousands of datase servers with multi-TB databases with internally developed orchestrations and automations.
Full remote available.
Let me know if you are interested :)
#postgresql #hiring #fintech #job
New entry in #PostgreSQL Event Calendar:
PGDay Hyd 2025
Date: 2025-08-28 - 2025-08-29
Location: Hyderabad, India
ICS file: https://ics.postgresql.life/3dpn96764otk1ottqhghd4hm7p.ics
Linux Schulungen im Juni & Juli 2025: Das sind die Kurse vor der Sommerpause unserer Akademie 
– jetzt noch Schulungsplatz sichern!
Du möchtest kurzfristig ein Wissens-Update in Sachen #Ansible, #Checkmk, #PostgreSQL oder #systemd? Dann melde dich jetzt an und hol dir von unseren Experten das Know-how, das du brauchst! 
Unsere #Linux #Admin Grundlagen Schulung gibt dir den roten Faden für das Verständnis des gesamten Systems an die Hand – jetzt anmelden. 
https://www.heinlein-support.de/news/ansible-bis-systemd-linux-schulungen
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.
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.
There's a #Prague #PostgreSQL meetup today!
We have two talks on schedule:
* Do ORMs make you happy OR Mad? / Petr Smejkal
* Making the best use of modern SSL / Peter Eisentraut
The meetup starts at 17:30 in Outreach Prague (Plynární 1617/10 Praha 7). Interested? Let us know through https://www.meetup.com/prague-postgresql-meetup/
See you there!
PostgreSQL IDE in VS Code
Link: https://techcommunity.microsoft.com/blog/adforpostgresql/announcing-a-new-ide-for-postgresql-in-vs-code-from-microsoft/4414648
Discussion: https://news.ycombinator.com/item?id=44073588
OpenAI: Scaling PostgreSQL to the Next Level
Link: https://www.pixelstech.net/article/1747708863-openai%3a-scaling-postgresql-to-the-next-level
Discussion: https://news.ycombinator.com/item?id=44071418
@isotopp @masek Dealing with #Openstreetmap data I usually have a lot of utf-8 crap *inside* #postgresql string columns. LTR and RTL just came to my mind. #osm2pgsql will likely also support utf-8 in table names and indexes %-/
Seen at the podium at #PGConfdev last week in Montréal, this is #PostgreSQL committer Peter Geoghegan of AWS presenting on "Multidimensional search strategies for composite B-Tree indexes"
#PostgreSQL to #Matrix room state interface!
Where are you on your journey to learning about #data management? @posetteconf seeks to help you address questions you didn't even know you had about using #PostgreSQL across every industry and scenario you can imagine.
Learn more free during this #Microsoft event (or after, watching the recordings!).
Two of our team will be presenting; attend live to talk directly, ask questions, & learn. 
Speak My Language: Internationalization in Quarkus with Property Files, PostgreSQL, and Locale Switching
Learn how to build a modern, global-ready Java application using message bundles, dynamic translations from PostgreSQL, and Qute-power https://myfear.substack.com/p/java-quarkus-i18n-multilingual-app
#Java #Quarkus #i18n #Postgresql #Qute
