postgresql.md

PostgreSQL

• Postgres for Everything (e/postgres)

  • Redis, MQTT, Graph, Document. Do them all in postgres

• PostgreSQL beginner guide - connecting, remote access, psql CLI and troubleshooting connection

• The Internals of PostgreSQL - for database administrators and system developers

• Understanding database Indexes in PostgreSQL - A deep dive into indexes

• Why you (probably) don't need PostGIS

• psql command line tutorial and cheat sheet

• PostgREST [server-side] [microservice] [rest]

  • postgREST
  • PostgREST is a standalone web server that turns your PostgreSQL database directly into a RESTful API. The structural constraints and permissions in the database determine the API endpoints and operations.
  • A poor man's API - no need for a [frameworks]

• Fuzzy Name Matching in Postgres [fuzzy]

  • Levenshtein Matching - fuzzy string match

• 10 Things I Hate About PostgreSQL

  • Experienced data engineer talks about experiences with Postgres in production

• pgvector - Open-source vector similarity search for Postgres

• PostGIS - is a spatial database extender for PostgreSQL object-relational database. It adds support for geographic objects allowing location queries to be run in SQL.

• Postgres Full-Text Search: A Search Engine in a Database

• Zero-downtime schema migrations in Postgres using Reshape #migrations

• Postgres Tips & Tricks

  • Just a few helpful tips how to use Postgres to it's fullest.

• Things I Wished More Developers Knew About Databases

• We Can Do Better Than SQL - sql is not brilliant - here is why

• Postgres: The Graph Database You Didn't Know You Had

  • Recursive queries!
    • WITH RECURSIVE friend_of_friend AS (

• Representing graphs in Postgresql

• PostgreSQL and SQL:2023