🔥The 9th Round of Easy Loan, Earn $40 Reward is in progress❗️ ⏰ Promotion Period: January 15th - Feburary 15th, 2025 👉 Register now and check more details at gate.io/campaigns/358

You think 'SELECT 1;' is simple? Let’s walk through everything that happens just to return the number 1 from an existing connection to Postgres. 1. Client sends the query. Whether you're using psql, JDBC, or a web app — it’s a client over TCP. Likely TLS. Postgres has

I started the day paying estimated taxes. And it all went downhill from there.

We used to joke about engineers who had 10 minute task, so they'd spend 10 hours writing scripts to automate it. The best thing about LLMs, for me, is that they make automation actually save time. I have 10 minute task and I spend 10 seconds asking an LLM to automate it.

Great talk that summarizes the challenges in building “deep” extensions (ones that modify parts of Postgres. Not just add a function). This is why having an amazing team with experienced Postgres developers (like Nile team) makes all the difference.

I'm excited to announce this free 5-part mini-series on evaluating & optimizing RAG organized by Ben Clavié, w/ some of the 🐐 's of RAG Part 1 is with Ben Clavié himself who is going to fight everyone who claims that "RAG is dead" maven.com/p/569540/i-don…

Learning Postgres: from “SELECT ” to "reading the source code for fun". Here’s my favorite list of resources to level up your PostgreSQL skills. No matter if you are a total beginner or quite experienced - there is always more to discover. 🔹 Beginner: - The official

AWS: Default NLB timeout is 350s Also AWS: Default tcp.keep_alive is 7200s 🤔

I have 40 minutes while a benchmark is running, so let me tell you a benchmark story. The lessons are probably no longer relevant, but I like telling this story anyway. Year is 2010, give or take a few. I was working as a database consultant. Most of my gigs were of the "make

There are all kinds of myths out there about Postgres shared buffers. Curious to learn how common they are. On a 256G RAM machine, the maximum effective shared_buffers size will be:

It's funny how thinking about building for LLMs to understand your abstractions better makes you do what you should have been doing for people the whole time My theory is that we don't judge an LLM like we do people, no "skill issue", we simply do the things that help them

Built an AI travel buddy on my day off! 🤖 Told it: “Plan a fun day in California wine country.” Got an epic itinerary! What’s your ideal day? 👇 My project can help you plan it (or at least help you learn how to do Graph RAG w/ Postgres) tinyurl.com/nhb5fjz2

New episode: "Multi-tenant options" Nikolay and Michael are joined by Gwen (Chen) Shapira to discuss multi-tenant architectures — the high level options, the pros and cons of each, and how they're trying to help with Nile. 🎧 postgres.fm/episodes/multi… 📺 youtu.be/1pb3qZyyR58

As Nile's chief kolboynik, I often switch between 2-3 languages and 5-6 ORMs in a week. If something seems off, I want to check the queries they generated. But I can't remember how to turn on debug logging in each one. 🦈Wireshark is my lifesaver.

Alembic, the Python migration tool, is a bit scary. It has a "generate" mode where it takes a SQLAlchemy model and a database, and generates a migration. If the DB contains tables that are not in the model it... drops them. By default. Data and all. Not ignore them. Not

Babe. Wake up. A cool new Postgres feature is dropping in version 18.

DNS is the granddaddy of distributed systems 🧓 I thought I knew how it works, but digging in for a talk revealed some new surprises: 🔐Chrome and Firefox ditched the old standard and use DNS over HTTPS (or TLS) since 2020. 💻 They handle their own lookups and caching, bypassing