pg_plan_guarantee – Postgres Query Optimizer Hints, on Steroids.

In plain words

pg_plan_guarantee is a PostgreSQL extension that provides query optimizer hints to control how the database executes SQL queries. It allows developers and database administrators to override the query planner's decisions when needed, giving them more direct control over query execution paths. The tool is designed for teams managing PostgreSQL databases who need fine-grained optimization capabilities beyond standard query tuning methods.

written from the facts on this page · September 2026

• 
  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.

• 
  PostgreSQL index advisor2024 · github.com · ▲417

  This is a Postgres extension that can determine if a query should have an index. For example, for this table: create table book( id int primary key, title text not null ); You can run `index_advisor()` to see if there should be an index on a select statement: select * from index_advisor('select book.id from book where title = $1'); And it will return (summarized): {"CREATE INDEX ON public.book USING btree (title)"} It works particularly well with pg_stat_statements[0] which tracks execution statistics of all SQL statements executed on your Postgres database. It leans heavily on HypoPG[1], an…

• 
  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!

• 
  Pg_yregress, Structured Testing for Postgres2023 · github.com · ▲56

  Originally inspired by pg_regress, pg_yregress provides a TAP-compatible test executor that allows for better test organization, easier instance management, native JSON handling and so on.

• 
  PRQL 0.2 – a better SQL2022 · github.com · ▲378

  Hi everyone — thanks for your interest in PRQL — let us know any questions or feedback! We're excited to be releasing 0.2[1], the first version of PRQL you can use in your own projects. It wouldn't exist without the feedback we got from HackerNews when we originally posted the proposal. [1]: https://github.com/prql/prql/releases/tag/0.2.0

• 
  SimCity, but with Permits▲902

  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 · 1d ago · permit.petercai.com

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

  Life & fun · 13d 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 · 14d 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 · 8d 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 · 12d ago · carrierexplode.com

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

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

• IM
  I made a web game called Almost Pong▲1,135

  Hi HN! I made many small web games in the past with Unity or Phaser. But this time I wanted to make something completely on my own. So I coded a basic game framework in plain JavaScript, and used it to make Almost Pong. This was a really fun project that taught me a lot about JavaScript, and I plan to make more minimalist games with this framework. Interesting fact: Almost Pong doesn't load any assets, all sprites and sounds are generated with code. Happy to answer questions, and please let me know if you have any feedback on the game. Thanks!

  Dev tools · 2022 · lessmilk.com

• IM
  I'm writing a free book called Computer Networks from Scratch▲792

  Life & fun · 2022 · networksfromscratch.com

• HA
  HN Avatars in 357 bytes▲701

  Paste the following into the console of any HN page - for annotated avatars on all HN comments. (self contained code) for(u of document.querySelectorAll('.hnuser'))for(u.prepend(c=document.createElement('canvas')),x=c.getContext('2d'),c.width=18,c.height=14,s=u.innerText,r=1,i=28+s.length;i--;i>>29>X*X/3+Y/2&&x.fillRect(6+2*X,2*Y,2,2)&x.fillRect(6-2*X,2*Y,2,2):r+=s.charCodeAt(i-28,x.fillStyle='#'+(r>>8&0xFFFFFF).toString(16)))r^=r>>17,r^=r>2

  Dev tools · 2022

• 
  Tome Beta▲697

  The storytelling tool for work

  Work · 2022 · tome.app

• 
  Kairn▲694

  Regain control over your days

  Dev tools · 2022

• 
  A game that tests how well you know your local area▲654

  How well do you know your area? Test your knowledge by locating streets on a map.

  Work · 2022 · backofyourhand.com