Data●●●Banger
SQLite-Columnar – Columnar Storage for SQLite
Columnar storage inside SQLite delivers 130,000x speedup on aggregation scans.
WizardryBig Brain
marcobambini
4022d ago
Back to browse
I aggregated 17 years of the Guardian's Blind Date column
by mrroryflint·May 5, 2026·2 points·1 comment
AI Analysis
●●SolidRabbit HoleNiche Gem
17 years of dating data reveals Brits are polite liars who rarely kiss on first dates.
Strengths
- •Scraped and structured 877 dates with consistent coding across 17 years of unstructured text.
- •Correlation analysis shows date scores barely predict partner satisfaction (r=0.31).
- •Clean visualization of awkwardness vs success rates without overclaiming insights.
Weaknesses
- •Limited to one newspaper's column format; can't generalize beyond Guardian readers.
- •No raw dataset download option for others to replicate or extend the analysis.
Category
Target Audience
Data journalists, social researchers, Guardian readers
Similar To
The Pudding · FiveThirtyEight data projects
Similar Projects
AI/ML●Mid
VNN – AI news aggregator that verifies every source live
Another AI news aggregator when Ground News and Google News already dominate.
Slick
WouterGlorieux
201d ago
Infrastructure●●Solid
Pg_column_Tetris – a pg extension for optimal column alignment
Blocks suboptimal CREATE TABLE inside Postgres when SQLFluff only lints.
Big BrainSolve My Problem
rogerw
201mo ago
Data●Mid
Built a news aggregator that collect AI news around the world
Vanilla news aggregator with risk filters; Feedly, Perplexity, and Bloomberg terminal already cover this.
raugen
103mo ago
Data●Mid
Aggregating Hacker News Stories by Topic
Handy, focused slice of HN history — the UI gives immediate controls for sorting by points, comments, backlinks and even snapshotting, so you can eyeball what topics dominated each year. The listing is readable and the filters in the header imply some non-trivial backlink/discussion aggregation behind the scenes. I want clearer methodology, export options and time-series views before this becomes a must-bookmark tool.
Niche GemRabbit Hole
keepamovin
203mo ago
Data●●●Banger
SQLite-columnar, a column-oriented analytics extension for SQLite
Brings DuckDB-style columnar speed to SQLite without replacing the engine.
Big BrainWizardry
marcobambini
2024d ago