pg-primer - Beginner's guide to administering/managing PostgreSQL

In plain words

pg-primer is a beginner's guide to administering and managing PostgreSQL. It targets people new to PostgreSQL and includes commonly used queries alongside introductory documentation. The guide is hosted on GitHub and covers foundational concepts for those starting their PostgreSQL journey.

written from the facts on this page · September 2026

From the sources

Beginner's guide to administering/managing postgresql - vishesh92/pg-primer

• 
  Postgres Playground2022 · crunchydata.com · ▲161

  Hands-on tutorials to learn Postgres

• 
  pg_flame – flamegraph visualizations of PostgreSQL query plans2019 · github.com · ▲321

  A flamegraph generator for Postgres EXPLAIN ANALYZE output. - mgartner/pg_flame

• 
  PgQueuer – Transform PostgreSQL into a Job Queue2024 · github.com · ▲376

  PgQueuer is a Python job queue that uses PostgreSQL for everything — queue storage, locking, notifications. No Redis, no RabbitMQ, no separate broker to operate. If your app already has Postgres, you already have the broker. After ~2 years and 26 minor releases, 1.0 ships today as the first stable release. Strict semver from here on. Thanks to everyone who contributed and left feedback!

• 
  PRQL in PostgreSQL2024 · github.com · ▲267

  This extension let's you write PRQL functions in PostgreSQL. When I first saw PRQL on Hacker News a few months ago, I was immediately captivated by the idea, yet equally disappointed that there was no integration for PostgreSQL. Having previous experience with writing PostgreSQL extensions in C, I thought this was a great opportunity to try out the pgrx framework and decided to integrate PRQL with PostgreSQL myself. The maintainers of both PRQL and pgrx were very nice to work with. Thanks guys.

• 
  PgCat, Postgres pooler with sharding, load balancing and failover2022 · github.com · ▲233

  PostgreSQL pooler with sharding, load balancing and failover support. - postgresml/pgcat

• 
  PgDog – Scale Postgres without changing the appFeb 2026 · github.com · ▲326

  Hey HN! Lev and Justin here, authors of PgDog (https://pgdog.dev/), a connection pooler, load balancer and database sharder for PostgreSQL. If you build apps with a lot of traffic, you know the first thing to break is the database. We are solving this with a network proxy that works without requiring application code changes or database migrations. Our post from last year: https://news.ycombinator.com/item?id=44099187 The most important update: we are in production. Sharding is used a lot, with direct-to-shard queries (one shard per query) working pretty much…

• 
  SimCity, but with Permits▲920

  A free city-building game in your browser. You are the mayor. You know what the city needs. Now get it past the zoning board, the neighbors, the appeals court and the next election.

  Life & fun · 2d ago · permit.petercai.com

• IV
  I've been paying for a rural Tanzanian's education for 10 years▲778

  Life & fun · 14d ago · tanzaniaeducationproject.org

• 
  Bigwords.page – Turn any screen into a sign. The URL is the app▲728

  Turn a phone, tablet or TV into a sign. Type a message and it fills the screen: welcome signs, timers, Wi-Fi passwords and more. No app, no account, free.

  Life & fun · 15d ago · bigwords.page

• 
  Guitoro, a virtual guitar you strum with your keyboard▲573

  Play a free virtual guitar online with your keyboard or by touch. Slow songs down and see every chord, string and strum. Acoustic, classic, electric and bass.

  Life & fun · 9d ago · guitoro.com

• 
  See *almost* any carriers phone settings▲432

  Carrier settings from iPhone, Pixel and Galaxy firmware, decoded and compared: APNs, VoLTE, 5G and Wi-Fi Calling per carrier, and what each build changed.

  Life & fun · 13d ago · carrierexplode.com

• 
  The whole Solar System and every tracked satellite, live in the browser▲407

  Life & fun · 23d ago · space.bl2.net

• 
  Non.io, a Reddit-like platform Ive been working on for the last 4 years▲1,943

  Heya HN, I've been working on a reddit-like platform as my primary side project for the last few years. Doing a (very) soft launch today, mainly because I want to use it to encourage discussion of alternatives. How non.io works: 1. Free to browse, paid to interact. 2. Minimum subscription is $2 (though you can choose more). I take $1 to run the servers, everything left gets split evenly between everything you upvote that month. It's a simple model, but I hope it's a better one than the freemium model we've been relying on for the last few years. Fundamentally I feel like any ad-supported…

  Commerce · 2023 · non.io

• 
  Sivi AI▲938

  Generative AI to magically turn text to visual designs

  AI · 2023 · sivi.ai

• 
  Typefully 2.0▲931

  Effortlessly publish on Twitter and LinkedIn, now with AI

  Growth · 2023 · typefully.com

• 
  Olvy 2.0▲826

  Analyze user feedback 10x faster with AI

  AI · 2023 · olvy.co

• 
  SlashPage▲755

  Create websites in seconds to build your first 1K community

  Growth · 2023 · slashpage.com

• 
  Unicorn Platform AI▲751

  Easy to use AI-powered, drag-and-drop website, SAAS landing, directory, and blog builder for startups, mobile apps, and SaaS. 100% no code, no design skills needed.

  AI · 2023 · unicornplatform.com