BSON Extension for Postgres
JSON support in postgres is superb but sometimes you really want decimal, date, and binary types, "carefree" UTF8 string handling (i.e. no escaping), and robust roundtrippability. So I made an extension for BSON.
BSON Extension for Postgres launched on January 15, 2024 with 115 votes, #484 of 4,438 launches that month and more than 95% of that year's launches. The site was still online in September 2026, 2 years on.
In plain words
The BSON Extension for Postgres adds BSON data type support to PostgreSQL, complementing the existing JSON functionality. It enables storage and handling of decimal, date, and binary types alongside UTF-8 strings without requiring escape sequences, while maintaining robust data roundtrippability. The extension is designed for developers who need BSON's richer type system within their Postgres databases.
written from the facts on this page · September 2026
From the sources
postgres support for BSON. Contribute to buzzm/postgresbson development by creating an account on GitHub.
Does a similar job
all alternatives →
BSON Extension for SQLite2024 · github.com · ▲8sqlite is, well, everywhere. It's a little shy on high-fidelity types, though, esp no dates and penny-precise numbers. And carrying rich shapes in JSON doesn't really help because JSON lacks those too. BSON supports these types but more importantly is a data carrier external to the database; you can fluidly move BSON in and out of sqlite without creating your own binary representations; just use the BSON SDK for your environment. Upwards of 20 languages are supported. The BSON extension is designed to exploit sqlite built-in JSON functions as desired.
Pg_jsonschema – A Postgres extension for JSON validation2022 · github.com · ▲203pg_jsonschema is a solution we're exploring to allow enforcing more structure on json and jsonb typed postgres columns. We initially wrote the extension as an excuse to play with pgx, the rust framework for writing postgres extensions. That let us lean on existing rust libs for validation (jsonschema), so the extension's implementation is only 10 lines of code :) https://github.com/supabase/pg_jsonschema/blob/fb7ab09bf6050... happy to answer any questions!
- PEPg-extend-rs – Easy Postgres extensions in Rust2018 · bluejekyll.github.io · ▲244
- BABedquiltDB – A Mongo-like JSON doc store built on Postgres2016 · bedquiltdb.github.io · ▲145
PRQL in PostgreSQL2024 · github.com · ▲267This 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.
Pg-typesafe – Strongly typed queries for PostgreSQL and TypeScriptFeb 2026 · github.com · ▲69Throughout my career, I tried many tools to query PostgreSQL, and in the end, concluded that for what I do, the simplest is almost always the best: raw SQL queries. Until now, I typed the results manually and relied on tests to catch problems. While this is OK in e.g., GoLang, it is quite annoying in TypeScript. First, because of the more powerful type system (it's easier to guess that updated_at is a date than it is to guess whether it's nullable or not), second, because of idiosyncrasies (INT4s are deserialised as JS numbers, but INT8s are deserialised as strings). So I wrote pg-typesafe,…
More life & fun this month
the category →
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
Life & fun · 13d ago · tanzaniaeducationproject.org
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
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
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
Life & fun · 22d ago · space.bl2.net
Source: Show HN post ↗
Launched alongside, January 2024
the whole month →
Amie▲1,334Turn meeting notes into automated workflows. Handle meetings, summaries, todos and emails (soon) with your AI personal assistant.
Work · 2024 · amie.so
- IM
Sit in Shade - Discover the optimal seat to stay in the shade during your journey. Sit In Shade provides real-time sun exposure data and route visualization.
Life & fun · 2024 · sitinshade.com
