Stanchion
Data
embedded columnar storage
SHOW HN2024
How HN took it
7 positive, 9 neutral or asking, 1 mixed, 4 critical, out of 21 comments about the project. Thread score +0.14.
Idea: 2 for, 2 againstPerformance: 3 for, 1 againstDesign: 1 for, 1 againstExecution: 1 for, 0 against
The thread, comment by comment
Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.
positive neutral or mixed critical about another commenter or something else the maker
What HN said
What people liked
Good Zig and C interop example; useful SQLite extension work
From 2 comments
Great example of Zig code, and of seamless interaction with C!
ngrilly on HNThis is an awesome project, I love SQLite extensions and I think they have a ton of use. Giants props to Dan here, I haven't seen many SQLite extensions written in Zig, and I'm…
alexgarcia-xyz on HN
Embedded columnar analytics is a welcome trend
From 2 comments
I'm excited to see how this compares to DuckDB. More local/embedded analytics databases will be good for the industry.
datadrivenangel on HNInteresting project! Thank you for open sourcing and sharing. Agree that local and embedded analytics are an increasing trend, I see it too. A couple of questions: * I’m curious…
tbragin on HN
Objections
SQLite virtual table API limits analytical query speed, e.g. COUNT(*) full scans
From 2 comments
This is an awesome project, I love SQLite extensions and I think they have a ton of use. Giants props to Dan here, I haven't seen many SQLite extensions written in Zig, and I'm…
alexgarcia-xyz on HNI may be missing something, but I'm not sure you need to detect COUNT(*) specifically. For a query that's just SELECT COUNT(*) FROM… SQLite will just iteratively call xNext/xEof…
ncruces on HN
Plugin toolchain fragmentation when mixing languages with SQLite
From 1 comment
This sounds like an excellent project, and I hope it continues to a production release. I do have one qualm, though. SQLite is written in C, and if I were writing plugins for it,…
vincent-manis on HN
LGPL license may deter users compared with SQLite's public domain
From 1 comment
Question: Why do you choose LGPL-3.0? For many, one of the most attractive features of SQLite is its license (or should I say lack thereof). I realise some people view public…
skissane on HN
Requests
Benchmarks against DuckDB or chDB and ClickBench results
From 2 comments
Interesting project! Thank you for open sourcing and sharing. Agree that local and embedded analytics are an increasing trend, I see it too. A couple of questions: * I’m curious…
tbragin on HNDuckDB is great! But row-oriented storage is also great for many use cases. My goal is to provide a way for people to have access to the benefits of column-oriented storage…
dgllghr on HN
Compression support such as RLE and zstd
From 1 comment
Can't wait to see compression! Any timeline for that?
thecowgoes on HN
Questions
How the extension works under the hood
From 1 comment
Can you ELI5, how did you make this possible? I see the readme asking to download a binary and then also mentioning sqlite extension. I have never had exp with sqlite ext, so not…
devdiary on HN
Whether row and column roles could be swapped
From 1 comment
Is there any value in just treating rows as columns and vice versa?
m1sta_ on HN
Alternatives named
DuckDB
From 2 comments
Note that DuckDB can ingest SQLite tables. If you need OLAP on your SQLite system today instead of whenever this is stable, consider pairing up DuckDB. In the simplest case if…
jitl on HNThis is an awesome project, I love SQLite extensions and I think they have a ton of use. Giants props to Dan here, I haven't seen many SQLite extensions written in Zig, and I'm…
alexgarcia-xyz on HN
chDB / clickhouse-local
From 1 comment
Interesting project! Thank you for open sourcing and sharing. Agree that local and embedded analytics are an increasing trend, I see it too. A couple of questions: * I’m curious…
tbragin on HN
Parquet and Apache Arrow
From 1 comment
The "Data Storage Internals" section[1] of the README sounds to me like it has its own column-oriented format for these tables, at least that's how I'm reading the part about…
thamer on HN