30 years of @java has shaped our interaction with databases: from stored procedures and SQL pre-compilers, to #JDBC @Hibernate #JPA #NoSQL @SpringData.I survived through all of that on #Db2 @Oracle @PostgreSQL @Yugabyte @MongoDB !.What is your experience with these transitions?.

How is AI transforming processes in the industry?.

Embedding a One-to-Many relationship into JSONB to avoid joins, if over 2KB, hides the join, but does not prevent it. Here's how PostgreSQL TOAST works:.

The CfP for @pg_ibz is open! I like this conference, which is Not Only PostgreSQL but also gathers experts from the ecosystem: automation, extensions, forks, managed services, and other databases that can inspire innovation.

RT @catalinmpit: Finally some sense being spoken. “AWS CEO Matt Garman dismissed the idea of replacing junior staff with AI as the dumbest….

RT @AmicoderDev: What actually happens when you run "SELECT * FROM users" in your database?. Your simple query goes through a multi-step jo….

RT @FranckPachot: @realnikhilv The model doesn't depends on data or use cases. It's about how you use the database:.- a monolithic central….

RT @intellijidea: SQL or NoSQL?.@FranckPachot explains how to pick the right model for your app in this #IntelliJIDEAConf session 👉 https:/….

MongoDB Champion Markus Wildgruber shares a smart way to pre-compute statistics for a specific time frame using @MongoDB and C#. If you’re working with time-based data, this one’s worth a read. 👇.

New blog post about comparing and sorting arrays in @MongoDB 👇🏼. It's a long story with a short conclusion to help remind it.

RT @eivanov89: Dear friends, I know there are many PostgreSQL experts here, and I could really use your help 🙏️️. I'm evaluating pgvector u….

🤓 Some geekery (for my #POUG2025 talk) on index dumps and internals to understand how Oracle Database emulates MongoDB multi-key indexes, and where the limitations come from.

RT @_avichawla: To recap, instead of producing independent chunk embeddings, contextualized chunk embedding models like voyage-context-3 pr….

RT @intellijidea: “The Modern Database Debate” by @FranckPachot, is now live!.Should you use documents, tables, or both? Learn how to choos….

PostgreSQL makes it easy to fact-check internet myths: read documentation + test with explain analyze 👉🏻 an example: 🤔.

Is @MongoDB storing documents like heap tables or index-organized tables?. 👉🏻 kind of both, a B+Tree optimized for flexible size documents.

Benchmarks from DbX's vendor showing it's faster than DbY are mainly marketing and serve little purpose in promoting DbX. However, they can help DbY's users spot poor design choices and anti-patterns that made DbY slower than carefully-tuned DbX.

Query planner transformations on MongoDB documents with flexible schemas can surprise users familiar with SQL databases, which typically have fixed tabular schemas. An example of these subtle differences is explained in a new blog post.

Easy to check @MongoDB durability (WAL fsync to disk + sync replication to a quorum).

🥶 (but don't panic, it's just a garbage-in garbage-out ranking)