HackerReposA FIELD GUIDE TO OPEN SOURCE
ProSponsor the shelf♧ 0
← Back to top all-time
dgllghr
stanchion
C2024–2024
dgllghr / stanchion · Archived

stanchion

A SQLite extension that brings column-oriented tables to SQLite

Data & DatabasesHardware & Embedded
Explore on GitHubRead Hacker News discussions
3Distinct people
3Mentions
0Explicit recommenders
682GitHub stars
REPOSITORY AT A GLANCE

What to know before exploring

What it is

A SQLite extension that brings column-oriented tables to SQLite

GitHub

Where it is used

No documented product use has been verified yet.

What people are saying

No recommendation phrase was found in the indexed comments.

No classified warning is attached to this page. Read the discussions before treating silence as approval.

Also in these discussions

No other repository is repeatedly linked in the same discussions.

This week on Hacker News

Nov 7–Nov 14 UTC · Direct repository links and separately labeled related project stories. Indexed through 11/14/2026, 5:04:57 PM UTC.

No direct repository links were found in the indexed HN discussions over the past seven days. Older discussions are available below.

Mentions over time

HN mentions by hour3 dated mentions

Observed mentions: 2024-01-31 18:38:53 UTC to 2024-02-01 20:35:55 UTC.

012024-01-31 18:00:00 UTC to 2024-01-31 19:00:00 UTC (exclusive): 1 mentions; 1 submissions, 0 commentsJan 31, 18:002024-01-31 19:00:00 UTC to 2024-01-31 20:00:00 UTC (exclusive): 0 mentions; 0 submissions, 0 comments2024-01-31 20:00:00 UTC to 2024-01-31 21:00:00 UTC (exclusive): 0 mentions; 0 submissions, 0 comments2024-01-31 21:00:00 UTC to 2024-01-31 22:00:00 UTC (exclusive): 0 mentions; 0 submissions, 0 comments2024-01-31 22:00:00 UTC to 2024-01-31 23:00:00 UTC (exclusive): 0 mentions; 0 submissions, 0 comments2024-01-31 23:00:00 UTC to 2024-02-01 00:00:00 UTC (exclusive): 0 mentions; 0 submissions, 0 comments2024-02-01 00:00:00 UTC to 2024-02-01 01:00:00 UTC (exclusive): 0 mentions; 0 submissions, 0 comments2024-02-01 01:00:00 UTC to 2024-02-01 02:00:00 UTC (exclusive): 0 mentions; 0 submissions, 0 comments2024-02-01 02:00:00 UTC to 2024-02-01 03:00:00 UTC (exclusive): 0 mentions; 0 submissions, 0 comments2024-02-01 03:00:00 UTC to 2024-02-01 04:00:00 UTC (exclusive): 0 mentions; 0 submissions, 0 comments2024-02-01 04:00:00 UTC to 2024-02-01 05:00:00 UTC (exclusive): 0 mentions; 0 submissions, 0 comments2024-02-01 05:00:00 UTC to 2024-02-01 06:00:00 UTC (exclusive): 0 mentions; 0 submissions, 0 comments2024-02-01 06:00:00 UTC to 2024-02-01 07:00:00 UTC (exclusive): 0 mentions; 0 submissions, 0 comments2024-02-01 07:00:00 UTC to 2024-02-01 08:00:00 UTC (exclusive): 0 mentions; 0 submissions, 0 commentsFeb 1, 07:002024-02-01 08:00:00 UTC to 2024-02-01 09:00:00 UTC (exclusive): 0 mentions; 0 submissions, 0 comments2024-02-01 09:00:00 UTC to 2024-02-01 10:00:00 UTC (exclusive): 0 mentions; 0 submissions, 0 comments2024-02-01 10:00:00 UTC to 2024-02-01 11:00:00 UTC (exclusive): 0 mentions; 0 submissions, 0 comments2024-02-01 11:00:00 UTC to 2024-02-01 12:00:00 UTC (exclusive): 0 mentions; 0 submissions, 0 comments2024-02-01 12:00:00 UTC to 2024-02-01 13:00:00 UTC (exclusive): 0 mentions; 0 submissions, 0 comments2024-02-01 13:00:00 UTC to 2024-02-01 14:00:00 UTC (exclusive): 0 mentions; 0 submissions, 0 comments2024-02-01 14:00:00 UTC to 2024-02-01 15:00:00 UTC (exclusive): 0 mentions; 0 submissions, 0 comments2024-02-01 15:00:00 UTC to 2024-02-01 16:00:00 UTC (exclusive): 0 mentions; 0 submissions, 0 comments2024-02-01 16:00:00 UTC to 2024-02-01 17:00:00 UTC (exclusive): 0 mentions; 0 submissions, 0 comments2024-02-01 17:00:00 UTC to 2024-02-01 18:00:00 UTC (exclusive): 0 mentions; 0 submissions, 0 comments2024-02-01 18:00:00 UTC to 2024-02-01 19:00:00 UTC (exclusive): 1 mentions; 1 submissions, 0 comments2024-02-01 19:00:00 UTC to 2024-02-01 20:00:00 UTC (exclusive): 0 mentions; 0 submissions, 0 comments2024-02-01 20:00:00 UTC to 2024-02-01 21:00:00 UTC (exclusive): 1 mentions; 0 submissions, 1 commentsFeb 1, 20:00

Counts come from the repository’s dated source evidence. Index cutoff: 2026-11-02 08:16:59 UTC.

View mention counts and date ranges
UTC ranges include their start and exclude their end. Select a period to filter the source evidence.
PeriodStart (UTC)End (exclusive, UTC)MentionsSubmissionsComments
Jan 31, 18:002024-01-31 18:00:00 UTC2024-01-31 19:00:00 UTC110
Jan 31, 19:002024-01-31 19:00:00 UTC2024-01-31 20:00:00 UTC000
Jan 31, 20:002024-01-31 20:00:00 UTC2024-01-31 21:00:00 UTC000
Jan 31, 21:002024-01-31 21:00:00 UTC2024-01-31 22:00:00 UTC000
Jan 31, 22:002024-01-31 22:00:00 UTC2024-01-31 23:00:00 UTC000
Jan 31, 23:002024-01-31 23:00:00 UTC2024-02-01 00:00:00 UTC000
Feb 1, 00:002024-02-01 00:00:00 UTC2024-02-01 01:00:00 UTC000
Feb 1, 01:002024-02-01 01:00:00 UTC2024-02-01 02:00:00 UTC000
Feb 1, 02:002024-02-01 02:00:00 UTC2024-02-01 03:00:00 UTC000
Feb 1, 03:002024-02-01 03:00:00 UTC2024-02-01 04:00:00 UTC000
Feb 1, 04:002024-02-01 04:00:00 UTC2024-02-01 05:00:00 UTC000
Feb 1, 05:002024-02-01 05:00:00 UTC2024-02-01 06:00:00 UTC000
Feb 1, 06:002024-02-01 06:00:00 UTC2024-02-01 07:00:00 UTC000
Feb 1, 07:002024-02-01 07:00:00 UTC2024-02-01 08:00:00 UTC000
Feb 1, 08:002024-02-01 08:00:00 UTC2024-02-01 09:00:00 UTC000
Feb 1, 09:002024-02-01 09:00:00 UTC2024-02-01 10:00:00 UTC000
Feb 1, 10:002024-02-01 10:00:00 UTC2024-02-01 11:00:00 UTC000
Feb 1, 11:002024-02-01 11:00:00 UTC2024-02-01 12:00:00 UTC000
Feb 1, 12:002024-02-01 12:00:00 UTC2024-02-01 13:00:00 UTC000
Feb 1, 13:002024-02-01 13:00:00 UTC2024-02-01 14:00:00 UTC000
Feb 1, 14:002024-02-01 14:00:00 UTC2024-02-01 15:00:00 UTC000
Feb 1, 15:002024-02-01 15:00:00 UTC2024-02-01 16:00:00 UTC000
Feb 1, 16:002024-02-01 16:00:00 UTC2024-02-01 17:00:00 UTC000
Feb 1, 17:002024-02-01 17:00:00 UTC2024-02-01 18:00:00 UTC000
Feb 1, 18:002024-02-01 18:00:00 UTC2024-02-01 19:00:00 UTC110
Feb 1, 19:002024-02-01 19:00:00 UTC2024-02-01 20:00:00 UTC000
Feb 1, 20:002024-02-01 20:00:00 UTC2024-02-01 21:00:00 UTC101

What Hacker News says

3 sources
dgllghr·Jan 31, 2024Submission

Show HN: Stanchion – Column-oriented tables in SQLite

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 very cool), but I want stanchion to be "good enough" that it is useful without having to add whole new database technology. If you think stanchion may be a good fit for your use case and you are interested in contributing, please test it and provide feedb
Read the rest
ack by opening issues for any bugs, difficulties, or missing features you would need! Ideas are also welcome in this thread or as a github issue. Of course stars are always appreciated as well. The CONTRIBUTING doc in the repository has more details. - Dan
273 points · Open discussion

MAKE YOURSELF AT HOME

A few shortcuts

/
Search the collection
?
Open this guide
Esc
Close dialogs and navigation

Your saved repositories and interests stay in this browser.