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

• TL
  The load-bearing vocabulary of Claude▲703

  Life & fun · 10d ago · louisabraham.github.io

• 
  iPhone app takes simultaneous images from 2 lenses, fuses into 1 photo▲329

  Photosynthesis fires two of your iPhone

  Life & fun · 28d ago · photosynthesis.camera

• 
  SoloUno▲310

  Take control of hair pulling, nail biting & skin picking

  Life & fun · 28d ago · solouno.io

• 
  Scroll through all 43252003274489856000 Rubik's Cube states▲295

  Scroll through all 43,252,003,274,489,856,000 reachable Rubik's Cube permutations.

  Life & fun · 26d ago · everycube.alen.is

• 
  Expeditione▲265

  The Interactive 3D Encyclopedia

  Life & fun · 21d ago · expeditione.fun

• 
  Eigendrum - Draw any shape and hear what it sounds like as a drum▲243

  Hi HN, I built Eigendrum, a web tool that solves the 2D wave equation for arbitrary shapes so you can hear what they sound like as drums. How it works: * Solves -∇²u = λu using finite element analysis (Kφ = λMφ) on a triangle mesh. * Validated to <0.1% error against closed-form solutions for circles (Bessel zeros) and rectangles. * Sound model factors in strike location, Rayleigh damping, and mallet width. * Includes Kac drums I & II to demonstrate identical sound spectra from different geometries. * No frameworks, build steps, or dependencies. Repo and tests:…

  Life & fun · 26d ago · baselashraf81.github.io

• 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&#x2F;3+Y&#x2F;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

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

  Life & fun · 2022 · backofyourhand.com