Stanchion – Column-oriented tables in SQLite

In plain words

Stanchion adds column-oriented table storage to SQLite, enabling data warehouse capabilities on resource-constrained devices without requiring separate database infrastructure. Designed for applications already using SQLite on phones and Raspberry Pis, it allows efficient storage and querying of logs and metrics. The tool targets developers who need analytical capabilities but want to avoid the complexity of adding a new database system or server to their existing SQLite-based applications.

written from the facts on this page · September 2026

From the sources

A SQLite extension that brings column-oriented tables to SQLite - dgllghr/stanchion

In the maker’s words, at launch

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…

• 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

• 
  Mongita is to MongoDB as SQLite is to SQL2021 · github.com · ▲126

  "Mongita is to MongoDB as SQLite is to SQL". Contribute to scottrogowski/mongita development by creating an account on GitHub.

• 
  I wrote a RDBMS (SQLite clone) from scratch in pure Python2023 · github.com · ▲371

  I wrote a relational database management system (RDBMS) (sqlite clone) from scratch in pure Python.

• 
  Base, an SQLite database editor for macOS2025 · menial.co.uk · ▲693

  I recently released v3 of Base, my SQLite editor for macOS. The goal of this app is to provide a comfortable native GUI for SQLite, without it turning into a massive IDE-style app. The coolest features are - That it can handle full altering of tables, which is quite finicky to do manually with SQLite. - It has a more detailed display of column constraints than most editors. Each constraint is shown as an icon if active, with full details available on clicking the icon. This update also adds support for attaching databases, which is a bit fiddly with macOS sandboxing. I'd love to hear any…

• 
  Simple-graph – a graph database in SQLite2020 · github.com · ▲237

  This is a simple graph database in SQLite, inspired by "SQLite as a document database" - dpapathanasiou/simple-graph

• 
  Cozo – new Graph DB with Datalog, embedded like SQLite2022 · github.com · ▲425

  Hi HN, I have been making this Cozo database since half a year ago, and now it is ready for public release. My initial motivation is that I want a graph database. Lightweight and easy to use, like SQLite. Powerful and performant, like Postgres. I found none of the existing solutions good enough. Deciding to roll my own, I need to choose a query language. I am familiar with Cypher but consider it not much of an improvement over CTE in SQL (Cypher is sometimes notationally more convenient, but not more expressive). I like Gremlin but would prefer something more declarative. Experimentations…

• 
  /dev/null▲456

  a social network for devs

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

• 
  Whiteboard (YC W26) – an open-source IDE for thoughtful software design▲423

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

  Dev tools · 27d ago · github.com

• 
  Reladraw – A diagram language where you decide where to place things▲411

  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 · 22d ago · openbot.run

• 
  Talanoa▲338

  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 · 27d ago · corespeed.io

• 
  Amie▲1,334

  Turn meeting notes into automated workflows. Handle meetings, summaries, todos and emails (soon) with your AI personal assistant.

  Work · 2024 · amie.so

• 
  Findr▲1,296

  Search all your apps, at once

  AI · 2024 · usefindr.com

• 
  Notion Calendar▲1,199

  Beautifully designed for your work and life

  Work · 2024 · notion.so

• 
  Huudle AI Project Assistant▲1,070

  Connect meetings, track to-do, get aligned

  AI · 2024 · huudle.io

• IM
  I made a website to find best bus seat to avoid the sun while traveling▲963

  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

• 
  Letterly▲937

  Turn your speech into well-written text

  AI · 2024 · letterly.app