Data Projects

Data tools and analytics from Show HN — visualization, ETL pipelines, databases, and data science utilities.

GitHub

An experiment to query Xarray datasets with SQL

126Python
●●●●Gem

I implemented a neural network in SQL

Running neural networks in SQL on climate data proves the relational array model works.

WizardryZero to One
alxmrs
1212016d ago
GitHub

Autonomous discovery of dynamic laws and world structure in Elementary Cellular Automata. Atlas of 20 worlds, 7 cycle laws, fragility spectrum. Preprint: https://doi.org/10.5281/zenodo.20516375

0Python
●●●●Gem

ZUSE – 69x causal compression of a period-15 CA oscillator

69x causal compression on period-15 CA oscillators with deterministic law discovery.

WizardryBig BrainNiche Gem
conchaestrada
201mo ago
Text Post

Reading a paper means opening a PDF, then hunting separately for the code, the citations, whether it replicated, and what genes/drugs it touches. I spent a few months trying to fix that. Two parts: 1.

●●●Banger

I mapped 8.5M research papers into an interactive atlas

8.5M papers in a WebGL map with MCP server access for AI agents.

Rabbit HoleWizardryBig Brain
leonickson
852820d ago
GitHub

SirixDB is an an embeddable, bitemporal, append-only database system and event store, storing immutable lightweight snapshots. It keeps the full history of each resource. Every commit stores a space-efficient snapshot through structural sharing. It is log-structured and never overwrites data. SirixDB uses a novel page-level versioning approach.

1,210Java
●●●Banger

SirixDB 1.0 Beta – Git-Like Versioning, Diffs, Time-Travel Queries

Structural sharing below page level beats ZFS block copying and event replay.

Big BrainWizardry
lichtenberger
13614d ago
GitHub

Distributed DataFrames for Elixir powered by DuckDB

94Elixir
●●●Banger

Distributed DuckDB on the Beam

Distributes DuckDB queries across BEAM nodes when Polars maintenance became unsustainable.

Big BrainNiche Gem
cigrainger
703mo ago
GitHub

Open-source streaming SQL engine written in Rust using Apache Arrow and DataFusion. Supports continuous queries, temporal stream joins, tumbling/session windows, and CDC/Kafka connectors. Lightweight, embeddable, and sub-microsecond latency

42Rust
●●●Banger

LaminarDB – Streaming SQL database in Rust, zero-alloc hot path

Sub-microsecond streaming SQL via zero-alloc hot path; genuine advancement over SQLite+DataFusion.

WizardryNiche GemSolve My Problem
sujitn
615mo ago
GitHub

Column-oriented analytics for SQLite, designed for fast local analytical queries with benchmarked speedups of up to 130,000x over standard SQLite scans on selected workloads.

7C
●●●Banger

SQLite-Columnar – Columnar Storage for SQLite

Columnar storage inside SQLite delivers 130,000x speedup on aggregation scans.

WizardryBig Brain
marcobambini
402mo ago