---
title: "#postgresql articles | Hashnode"
description: "PostgreSQL, often simply Postgres, is an object-relational database management system with an emphasis on extensibility and standards compliance."
url: "https://hashnode.com/tag/postgresql"
---

Tag

# #postgresql

3,953 posts · 8,225 followers

[Redlio Labs](https://hashnode.com/@redliolabs) · [10m ago](https://hashnode.com/posts/your-ai-agent-can-read-the-whole-database-give-it-a-postgres-role-that-can-t/6afab4bc542de7f7094a293d)

### [Your AI agent can read the whole database. Give it a Postgres role that can't](https://redliolabs.hashnode.dev/your-ai-agent-can-read-the-whole-database-give-it-a-postgres-role-that-can-t?utm_source=hashnode&utm_medium=feed)

Most "chat with your data" features start the same way. Someone wires an agent (or an MCP server) to the app's existing database connection, adds a tool that runs a query, and the demo works on the fi

6 min read · [redliolabs.hashnode.dev](https://redliolabs.hashnode.dev/your-ai-agent-can-read-the-whole-database-give-it-a-postgres-role-that-can-t?utm_source=hashnode&utm_medium=feed)

[Sachin Shah](https://hashnode.com/@imsachinshah) · [3h ago](https://hashnode.com/posts/two-buyers-one-seat-shipping-a-reliable-python-ticketing-backend-with-fastapi-postgresql-and-celery/6afa8c333959a689ff0b2aba)

### [Two Buyers, One Seat: Shipping a Reliable Python Ticketing Backend with FastAPI, PostgreSQL and Celery](https://imsachinshah.hashnode.dev/two-buyers-one-seat-shipping-a-reliable-python-ticketing-backend-with-fastapi-postgresql-and-celery?utm_source=hashnode&utm_medium=feed)

The problem: everyone clicks at the same moment Selling tickets looks like basic CRUD. A user picks seats, pays, gets a ticket. Insert a row, send an email, done. Then a popular event goes on sale. Hu

12 min read · [imsachinshah.hashnode.dev](https://imsachinshah.hashnode.dev/two-buyers-one-seat-shipping-a-reliable-python-ticketing-backend-with-fastapi-postgresql-and-celery?utm_source=hashnode&utm_medium=feed)

[Asfaq Leeon](https://hashnode.com/@leeonscoding) · [6h ago](https://hashnode.com/posts/postgresql-transactions-concurrency-a-practitioner-s-cheat-sheet/6afa5a050830de9cd6a6a27b)

### [PostgreSQL Transactions & Concurrency: A Practitioner's Cheat Sheet](https://leeonscoding.hashnode.dev/postgresql-transactions-concurrency-a-practitioner-s-cheat-sheet?utm_source=hashnode&utm_medium=feed)

For people who already write SQL daily. No hand-holding, just the mechanics, the traps, and the queries I actually use. One tiny schema throughout: customers own accounts, accounts move money via tran

12 min read · [leeonscoding.hashnode.dev](https://leeonscoding.hashnode.dev/postgresql-transactions-concurrency-a-practitioner-s-cheat-sheet?utm_source=hashnode&utm_medium=feed)

[Shubham Baldava](https://hashnode.com/@shubham-olake) · [13h ago](https://hashnode.com/posts/postgres-to-clickhouse-cdc-via-polaris-the-doubled-object-key-and-four-other-errors/6af9ff48523ed8d3af3bfda5)

### [Postgres to ClickHouse CDC via Polaris: The Doubled Object Key and Four Other Errors](https://olake-blog.hashnode.dev/postgres-to-clickhouse-cdc-via-polaris-the-doubled-object-key-and-four-other-errors?utm_source=hashnode&utm_medium=feed)

Slot, catalog, token, first query and second reader in setup order, with the exact error text at each step and the fix.

11 min read · [olake-blog.hashnode.dev](https://olake-blog.hashnode.dev/postgres-to-clickhouse-cdc-via-polaris-the-doubled-object-key-and-four-other-errors?utm_source=hashnode&utm_medium=feed)

[Aleks](https://hashnode.com/@aleks-sqlbrief) · [17h ago](https://hashnode.com/posts/test-your-sql-date-filter-with-four-boundary-rows/6af9c21a46bf3e8f65435e9a)

### [Test your SQL date filter with four boundary rows](https://sqlbrief.hashnode.dev/test-your-sql-date-filter-with-four-boundary-rows?utm_source=hashnode&utm_medium=feed)

Catch missing last-day rows with a four-row PostgreSQL check. Compare BETWEEN, 23:59:59 and an exclusive next-month boundary.

3 min read · [sqlbrief.hashnode.dev](https://sqlbrief.hashnode.dev/test-your-sql-date-filter-with-four-boundary-rows?utm_source=hashnode&utm_medium=feed)

[Sunnatulla E.](https://hashnode.com/@sunnatulla) · [14h ago](https://hashnode.com/posts/supabase-42501-hint-grant-to-anon/6af9e9a3deafcb57402d8e1b)

### [Supabase's 42501 hint says GRANT ... TO anon. I replayed what happens when you run it](https://sunnatulla.hashnode.dev/supabase-42501-hint-grant-to-anon?utm_source=hashnode&utm_medium=feed)

Supabase stopped auto-granting new tables on Oct 30. I replayed the usual 42501 fixes in Postgres: the TO anon hint, grant all, drop and db pull.

10 min read · [sunnatulla.hashnode.dev](https://sunnatulla.hashnode.dev/supabase-42501-hint-grant-to-anon?utm_source=hashnode&utm_medium=feed)

[Prasad Kukkala](https://hashnode.com/@techiesjournal) · [1d ago](https://hashnode.com/posts/postgresql-and-pgvector-when-should-ai-applications-use-a-separate-vector-database/6af95083ea9a9f6cccea0e80)

### [PostgreSQL and pgvector: When Should AI Applications Use a Separate Vector Database?](https://techies-journal.hashnode.dev/postgresql-and-pgvector-when-should-ai-applications-use-a-separate-vector-database?utm_source=hashnode&utm_medium=feed)

An AI application can keep business records, embeddings and searchable documents in PostgreSQL, or introduce a dedicated vector system. The right decision depends on retrieval quality, access controls

11 min read · [techies-journal.hashnode.dev](https://techies-journal.hashnode.dev/postgresql-and-pgvector-when-should-ai-applications-use-a-separate-vector-database?utm_source=hashnode&utm_medium=feed)

[Abdus Salam](https://hashnode.com/@aheadkit) · [1d ago](https://hashnode.com/posts/how-a-22-year-old-postgresql-type-confusion-became-remote-code-execution/6af8fcd39b55502027185ac7)

### [How a 22-Year-Old PostgreSQL Type Confusion Became Remote Code Execution](https://aheadkit.hashnode.dev/how-a-22-year-old-postgresql-type-confusion-became-remote-code-execution?utm_source=hashnode&utm_medium=feed)

Four SQL statements, a login with no special privileges, and a server process that dies with signal 11. That is the entry point to CVE-2026-6460, the PostgreSQL flaw security researcher Mehmet Ince wr

10 min read · [aheadkit.hashnode.dev](https://aheadkit.hashnode.dev/how-a-22-year-old-postgresql-type-confusion-became-remote-code-execution?utm_source=hashnode&utm_medium=feed)

[Munish Kumar Sharma](https://hashnode.com/@CodeWithMishu) · [18h ago](https://hashnode.com/posts/stop-defaulting-to-mongodb-a-practical-database-decision-framework-for-full-stack-builders/6af9b19d79631e0fbab14da2)

### [Stop Defaulting to MongoDB: A Practical Database Decision Framework for Full-Stack Builders](https://blogs.codewithmishu.in/stop-defaulting-to-mongodb-a-practical-database-decision-framework-for-full-stack-builders?utm_source=hashnode&utm_medium=feed)

Why the one-size-fits-all database mindset causes latency bottlenecks and ballooning cloud bills—plus the exact 4-quadrant decision matrix and ORM benchmarks for modern full-stack architectures.

10 min read · [blogs.codewithmishu.in](https://blogs.codewithmishu.in/stop-defaulting-to-mongodb-a-practical-database-decision-framework-for-full-stack-builders?utm_source=hashnode&utm_medium=feed)

[Sunnatulla E.](https://hashnode.com/@sunnatulla) · [21h ago](https://hashnode.com/posts/your-rag-app-forgets-small-customers-i-measured-filtered-pgvector-search-in-12-framework-stores/6af987dbe603fc0efa646a19)

### [Your RAG app forgets small customers: I measured filtered pgvector search in 12 framework stores](https://sunnatulla.hashnode.dev/your-rag-app-forgets-small-customers-i-measured-filtered-pgvector-search-in-12-framework-stores?utm_source=hashnode&utm_medium=feed)

Filtered HNSW search on Postgres 17 + pgvector 0.8 returned nothing for 1-row tenants 90% of the time. What 12 RAG stores send, and what fixes it.

9 min read · [sunnatulla.hashnode.dev](https://sunnatulla.hashnode.dev/your-rag-app-forgets-small-customers-i-measured-filtered-pgvector-search-in-12-framework-stores?utm_source=hashnode&utm_medium=feed)
