nowfound

Dev tools · February 3, 2024

BSON Extension for SQLite

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

BSON Extension for SQLite launched on February 3, 2024 with 8 votes, #1,589 of 3,962 launches that month and more than 75% of that year's launches. The site was still online in September 2026, 2 years on.

What it does

BSON extension for sqlite. Contribute to buzzm/sqlitebson development by creating an account on GitHub.

Does a similar job

all alternatives →
  • BSON Extension for Postgres2024 · github.com · ▲115

    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.

  • SQLite JavaScript - extend your database with JavaScript2025 · github.com · ▲199

    Create custom SQLite functions in JavaScript. Extend your database with scalars, aggregates, window functions, and collations directly in JavaScript. - sqliteai/sqlite-js

  • Datasette – Create and publish an API for SQLite databases2017 · simonwillison.net · ▲269

    I just shipped the first public version of datasette, a new tool for creating and publishing JSON APIs for SQLite databases. You can try out out right now at fivethirtyeight.datasettes.com, …

  • A SQL database implemented purely in TypeScript type annotations2020 · github.com · ▲426

    A SQL database implemented purely in TypeScript type annotations. - codemix/ts-sql

  • SO
    SQLite Online – 11 years of solo development, 11K daily users2025 · sqliteonline.com · ▲465

    SQL OnLine - SQLite, DuckDB, PGLite, MariaDB / MySQL, PostgreSQL, MS SQL Server. AI error analysis, User-friendly interface for Data Science. No registration for start, No DownLoad, No Install. | sql compiler, federated queries, temporal query federation, BI Analytics

  • Stanchion – Column-oriented tables in SQLite2024 · github.com · ▲273

    Hello HN! I built stanchion to scratch my own itch. I have personal applications running on SQLite where I want to store log and metric data (basically forever) but don't want to add complexity by bringing in a new database or whole separate server. Some of these applications are running on a Raspberry Pi, where storage and compute are limited, but I still want data warehouse like capabilities. I envision stanchion being used in similar scenarios: on phones and resource-limited devices in applications that are already using SQLite. I know that there are alternatives like DuckDB (which is…

More dev tools this month

the category →
  • /dev/null▲482

    a social network for devs

    Dev tools · 3d ago · dev-null.sh

  • open-source IDE for thoughtful software design. Contribute to devdotfast/whiteboard development by creating an account on GitHub.

    Dev tools · 27d ago · github.com

  • Contribute to reladraw/reladraw development by creating an account on GitHub.

    Dev tools · 25d ago · github.com

  • OpenBot▲362

    Grok Bot alternative: free, local, open-source, multiplayer

    Dev tools · 23d ago · openbot.run

  • Talanoa▲346

    Hi HN, I’m a fullstack developer, and honestly, I’ve lost count of how many side projects I’ve worked on over the years. But one idea kept coming back to me: a different kind of email client. It first came to me in 2014: “What if we could handle emails more like conversations?” Every year, I’d revisit this concept in my “Build Notes.” Ten years later, no one had built exactly what I had in mind — so I finally decided to do it myself. That’s how Talanoa was born. I wanted something focused on people, not timelines. I was tired of marking messages as unread just to remember to reply later, or…

    Dev tools · 20d ago · talanoa.email

  • CoreSpeed▲332

    One MCP for everything your agents need: apps, memory, tools

    Dev tools · 28d ago · corespeed.io

Source: Show HN post ↗

Launched alongside, February 2024

the whole month →
  • Flipner AI▲1,623

    Capture your ideas & craft texts with AI's touch

    AI · 2024 · flipner.webflow.io

  • Typeframes▲1,315

    Video creation for makers

    Work · 2024 · revid.ai

  • Superlist▲1,252

    The task layer for your AI agents

    Work · 2024 · superlist.com

  • Never run out of marketing ideas ever again

    Growth · 2024 · marketingideas.com

  • Layers▲1,198

    A home for designers

    Work · 2024 · layers.to

  • Heyday▲1,178

    AI copilot for your own research, notes & conversations

    AI · 2024 · heyday.xyz