"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/

Valkey - A new hash table https://lobste.rs/s/lvofny #databases #performance
https://valkey.io/blog/new-hash-table/

How to Sync Anything

#databases, #programming

Fast Compilation or Fast Execution: Just Have Both https://lobste.rs/s/kvganp #compilers #databases
https://cedardb.com/blog/compilation/

A LIVE recording of Ep26 of the #TalkingPostgres #podcast will happen on Wed Apr 2 @ 10am PDT

If open source—or Postgres—is your jam , come join the parallel live text chat (& listen to the LIVE recording) on the Microsoft Open Source Discord

Guest: Bruce Momjian of EDB, member of #PostgreSQL core team & co-founder of the PostgreSQL Global Development Group
Topic: Open Source Leadership
Cal invite for parallel live text chat https://aka.ms/TalkingPostgres-Ep26-cal

#Postgres #databases #OpenSource #community #leadership #Microsoft

p.s. Boost to your friends please! And yes, you can also wait til the episode is published & download wherever you get your podcasts, to listen at your convenience!

Today, 5:00 - 7:00 PM CEST! Join the only free #EclipseStore Advanced 2 course with C. Kuemmel in 2025. We`re already working with the new version 2.1.2!
Get your free #JAVAPRO ticket now: https://bit.ly/3DuMsta

Today, 5:00 - 7:00 PM CEST! Join the only free #EclipseStore Advanced 2 course with C. Kuemmel in 2025. We`re already working with the new version 2.1.2!
Get your free #JAVAPRO ticket now: https://bit.ly/3DuMsta

Hands down the best April Fool's day prank

New statement to end transaction in MariaDB - amen

Beautifully crafted by @sigmasternchen

Streaming changes from Postgres: the architecture behind Sequin https://lobste.rs/s/qrb3ve #databases #distributed
https://blog.sequinstream.com/streaming-changes-from-postgres-the-architecture-behind-sequin/

Stop syncing everything https://lobste.rs/s/tjh0qt #databases #distributed
https://sqlsync.dev/posts/stop-syncing-everything/

A polish friend just told me about freeshell.de. I think I should have known about it sooner so I'm slow to this party but it feels very interesting.

#hosting #email #owncloud #databases #linux #anonymity #europeanalternatives #germany #freeshell

About freeshell.de
https://freeshell.de/about/

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).

- https://awstip.com/mastering-django-orm-from-models-to-advanced-queries-be22ec26e8bb

-----------------------
Django ORM turns complex database queries into simple Python code. Instead of writing long SQL statements, you can use:

- Basic filters (filter(), exclude(), get()) to find exactly what you need.
- Smart optimisations (select_related(), prefetch_related()) to speed up your app.
- Handy tricks (annotate(), aggregate()) for calculations without extra code.
-------------------------------------

Fjall 2.8 via @kero https://lobste.rs/s/ssubpj #databases #rust
https://fjall-rs.github.io/post/fjall-2-8/

Updates on QueryC++ has been thin (none existing) we apologise for this.

However! We a preparing release 4.1.0 and we expect it to be out by the end of April.

"Exploring .NET and #PostgreSQL on Linux as your OSS app dev stack" will be presented by Silvano Coriani from Microsoft at #PosetteConf 2025 (Livestream 2 on Wed Jun 11th @ 12:30pm CEST (UTC+2))

Learn more: https://posetteconf.com/speakers/silvano-coriani/

CTEs are back, baby!

We’ve reintroduced Common Table Expressions (CTEs) to Opteryx—bringing back clarity, structure, and that sweet, sweet query composability.

Write cleaner SQL, break down complex logic, and nest away to your heart’s content.

Check it out and drop us a !
https://github.com/mabel-dev/opteryx

2024's hottest topics in databases (a bibliometric approach) https://lobste.rs/s/tgbfli #databases
https://rmarcus.info/blog/2025/03/28/hottest-db-topics.html

A Language Server for Postgres via @fanf https://lobste.rs/s/fstz1l #databases #editors
https://github.com/supabase-community/postgres-language-server