Remember that the official Postgres distributions come with a powerful command-line client called psql. It lets us start a fresh instance of Postgres and connect to it in under a minute. How? Simply start a Postgres container and open a psql connection 👇 docker exec -it

FInally! No more need to writt stuff like this floor(1 + random() * 10) just do random (1, 10) in Postgres 17

Today, I’m saying goodbye to my fellow Yugabeings. Keep building that unstoppable, distributed Postgres that scales and never fails. Remember, this is THE database that not only withstood the massive Super Bowl traffic but kept performing flawlessly as 200 million people watched

📢Reminder📢 #Java developers, the #Java23 launch stream is fast approaching on 17-Sept. Please watch from the official @Java YouTube channel: youtube.com/live/QG9xKpgwO…

Common table expressions (CTEs) are usually used with SELECT statements. This is a typical example 👇 WITH total_sales AS ( SELECT region, SUM(total) AS total FROM sales GROUP BY region) SELECT region, total FROM total_sales WHERE total > 1000000; But, PostgreSQL also

One thing I keep reminding others about is that secondary indexes can help boost not only selects/searches but also updates/deletes. This usually applies to any major database that supports secondary indexes. In one AWS DocumentDB case I was involved in, performance was boosted

If a developer is knowledgeable enough about databases and their team doesn’t have a dedicated DBA, then the developer is destined to fit that role. Experiencing this firsthand right now…

Just Use Postgres I’ve always thought this would make an excellent title and topic for a book. And now, it’s happening! We’ve partnered with Manning Publications to bring it to life. This is the book I wish I had 15 years ago when I, a fresh graduate app developer, was introduced to

Postgres is not much different from programming languages when it comes to this 👇🏻

It's great that Manning Publications has an early access program that lets authors hear the voice of the reader before the first copy of a book is printed. Without it, it's highly unlikely that we would have "Postgres as message queue" and "When NOT to use Postgres" sections in the

Postgres remains popular with the tech community regardless of the rise of AI. It’s truly inspiring to see that the early version of the Just Use Postgres book has been in the top 5 bestselling books for the last two months. Thanks to all of you for your support and feedback!

As of today, the chapter about indexes is available in the early access version of the book. This chapter primarily shows how to use indexes backed by B-trees. The following chapters will explain how to leverage GIN, GiST, HNSW, BRIN and other index data types.

Working the Postgres booth with Dave Cramer 🇨🇦 and pgtreats at Devnexus. Postgres definitely needs no introduction within the Java community. Many just stop by to say "Thank you!"

This is the next tech book on my must-read list 👇 We tend to learn from our own mistakes and often realize that failure is the best teacher. I embrace this mindset when the challenge—and potential failure—affects only me or a small group of people who are willing to take the

Every developer should absolutely do one thing… attend a live coding tech talk by Josh Long It's like watching a maestro perform on stage. This time Josh shared the stage with Dr. Mark Pollack at Devnexus to show Spring AI in action.

youtu.be/HR-vUI8mTVI?si… Here is the recording of my recent talk, ‘Sharded and Distributed Are Not the Same: What You Must Know When PostgreSQL Is Not Enough.’ The talk is deeply inspired by Franck Pachot and Denis Magda, but I’ve tried to approach it from a different angle.

The Manning Publications team has just released two more chapters of our Just Use Postgres book. It’s time to learn how Postgres deals with JSON data and handles full-text search. A funny fact is that I decided to write this book after having a conversation with a friend of mine about

Spoiler Alert. In just a few hours, Manning Publications kicks off the Deal of the Day for books on best-in-class databases — Postgres and Mongo. Seize the deal. It’s never too late to master databases. The books will appear on this page at midnight on April 19th (Eastern Time):