#postgres

Unexpected usecases for #postgres #postgresql #postgis https://dev.to/shayy/postgres-is-all-you-need-3pgb

New short blog post powered by wine and a desire to check off a to-do item:

https://kdwarn.net/blog/installing-postgres-version-not-in-distro-packages

#debian #Postgres

Hacking the Postgres Wire Protocol

Link: https://pgdog.dev/blog/hacking-postgres-wire-protocol
Discussion: https://news.ycombinator.com/item?id=43693326

#postgres

@tchorix & I are presenting on data modeling within #PostgreSQL in a storytelling fashion at @posetteconf, a free virtual event hosted by #Microsoft that's all about #Postgres this June 10-12!

Want to tune in? Add the livestream to your calendar, or register (optionally) here: https://posetteconf.com/2025/talks/postgres-storytelling-cunning-schema-design-with-creative-data-modeling/ (or, wait until the recording is out after the event!)

Illustrations will be completed by Scarlett Riggs, who we are very excited to be working with.

This talk should be great for anyone that's looking to understand things from the perspectives of an application developer, and a seasoned database administrator; here, you'll be able to learn when it is best to handle logic within the database vs. the application!

Looking forward to seeing you there

#techevent #tech #opensource #foss #oss #data #database #dba #applicationdeveloper #dev #technology #freesoftware

On June 12, join our CEO @c2main at 11:30 AM CEST for a FREE livestream @ @posetteconf regarding Pressure Stall Information within the world of #PostgreSQL.

Use this link to add the livestream to your calendar & optionally register, or follow us to get the recording after the conference when it becomes available!

posetteconf.com/2025/talks/resource-control-admission-i-have-a-date-with-my-psi/

#POSETTEConf #Postgres #SQL #Linux #opensource #FOSS #OSS #developer #tech #techevent #DevOps

Postgres is actually all you need. No need to build a complex setup of different databases.

I use postgres for all data storage requirements. I've been using it as a vector store too. It's been holding up very nicely.

#database #postgres #vectors #vector_database #ai #machinelearning #vectordatabase #postgresql

I recently leaned on an #LLM to help me get data out of a legacy database. The key was a multi-step prompt that took an existing schema and compressed it. That allowed me to build a chat bot that understood and could generate SQL for the answers I was seeking.

https://www.joecotellese.com/posts/2025-04-10-accelerate-database-understanding-with-llms/

#AI #chatgpt #postgres

#osm2pgsql v2.1.0 released #osm #openstreetmap #postgres #postgis

https://github.com/osm2pgsql-dev/osm2pgsql/releases/tag/2.1.0

Good one.

#postgresql #postgres #immutable #constraints #hallucination #hallucinations #claudeai #sonnet37

Welcome Nexteam as a Benefactor sponsor of PGDay UK 2025 in London!

https://2025.pgday.uk/sponsors/

#postgres #pgdayuk #london #opensource #database

Welcome pgMustard as a Supporter sponsor of PGDay UK 2025 in London!

https://2025.pgday.uk/sponsors/

#postgres #pgdayuk #london #opensource #database

New episode of #TalkingPostgres #podcast

Bruce Momjian, #PostgreSQL core team member, joined me on Ep26 to talk about open source leadership—with rabbitholes on servant leadership, the art of public speaking, the power of gratitude, & bow ties

Boosts appreciated to help more people discover the podcast

https://talkingpostgres.com/episodes/open-source-leadership-with-bruce-momjian

https://youtu.be/gYG3FP-Csho?feature=shared

#OpenSource #leadership #community #Postgres #databases #FOSDEM

Show HN: Hatchet v1 – a task orchestration platform built on Postgres

Link: https://github.com/hatchet-dev/hatchet
Discussion: https://news.ycombinator.com/item?id=43572733

#postgres

"Managing #PostgreSQL at scale: Challenges, Tools, & Techniques" will be presented by @karenhjex (Karen Jex) at #PosetteConf 2025 (Livestream 3 on Wed Jun 11th @ 9:00am PDT (UTC-7))

Learn more: https://posetteconf.com/2025/talks/managing-postgres-at-scale-challenges-tools-techniques/

#postgres #databases #OpenSource #community

I been using #sqlfluff as my #LSP for #postgres.
It's safe to say, I should probably try this new one from Supabase.

Although, sqlfluff can run without a connection. And has sqlite as a dialect.

https://supabase.com/blog/postgres-language-server

Пишем свой pastebin, используя только userver

Всем привет! Меня зовут Василий Куликов, я работаю ведущим разработчиком в Техплатформе Екома и Райдтеха Яндекса и последние пять лет разрабатываю фреймворк userver . Это веб‑фреймворк, который позволяет создавать высоконагруженные отказоустойчивые сервисы на С++. Сегодня я расскажу, как написать на нём игрушечный, но рабочий сервис, который реализует функциональность pastebin.

https://habr.com/ru/companies/yandex/articles/894294/

#c++ #userver #postgres #pastebin

An interesting PostgreSQL Claude Sonnet 3.7 hallucination

#claudeai #sonnet #sonnet37 #hallucination #postgres #postgresql

Is it a code smell for a table in Postgres to have mutually exclusive foreign keys?

For example, table A has foreign keys to table B and C, but there's a constraint in place where only one of those foreign keys can be populated.

My gut says I should be creating separate tables for these, as I'm effectively trying to tie a single table to multiple domain models (that happen to share the same fields).

#postgres #database #databases

Would you like to see a more inclusive and diverse PostgreSQL community? We would too! Consider joining the PgUS Diversity Committee to help make that a reality!

https://postgresql.us/diversity/

#PostgreSQL #postgres #diversity #inclusion