DEA passenger searches halted after watchdog finds signs of rights violations (Score: 150+ in 5 hours)
Link: https://readhacker.news/s/6izNW
Comments: https://readhacker.news/c/6izNW
Show HN: SQLite Plugin for Jekyll (Score: 150+ in 9 hours)
Link: https://readhacker.news/s/6iyYM
Comments: https://readhacker.news/c/6iyYM
I love Jekyll, especially the Datafiles[0] feature, which lets you use CSV/JSON/YAML files and iterate through them. Mixed with the Jekyll Data Pages generator[1], which lets you create a page for every row in your dataset, it is a very powerful combination.
However, Liquid is a terrible language for data-mangling, and simple filtering/sorting/merging can become very annoying. So I wrote a Jekyll SQLite plugin that lets you use the same data interface in Jekyll/Liquid, but backed by a SQLite file(s).
It gives you the simplicity of the Baked Data pattern[2], and the flexibility of using SQL for data-wrangling, within a static site generator.
As a demo, I took the northwind dataset, and generated a site[3] with a few sample queries[4]. It demos both site-level, and page-level queries alongside data-pages generator to generate a page for every product/category/customer.
I've been using this across a few sites in production for almost a year, looking for feedback on usage semantics and feature suggestions.
[0]: https://jekyllrb.com/docs/datafiles/
[1]: https://github.com/avillafiorita/jekyll-datapage_gen
[2]: https://simonwillison.net/2021/Jul/28/baked-data/
[3]: https://northwind.captnemo.in/
[4]: https://github.com/captn3m0/northwind
The AI reporter that took my old job just got fired (❄️ Score: 157+ in 4 days)
Link: https://readhacker.news/s/6inFk
Comments: https://readhacker.news/c/6inFk
Setelinleikkaus: When Finns snipped their cash in half to curb inflation (Score: 151+ in 10 hours)
Link: https://readhacker.news/s/6iyAM
Comments: https://readhacker.news/c/6iyAM
Show HN: I am Building a Producthunt alternative (Score: 150+ in 1 day)
Link: https://readhacker.news/s/6iwT6
Comments: https://readhacker.news/c/6iwT6
Revisiting the DOS Memory Models (❄️ Score: 150+ in 2 days)
Link: https://readhacker.news/s/6irSg
Comments: https://readhacker.news/c/6irSg
Y Combinator often backs startups that duplicate other YC companies, data shows (Score: 152+ in 6 hours)
Link: https://readhacker.news/s/6iyAC
Comments: https://readhacker.news/c/6iyAC
A Short Introduction to Automotive Lidar Technology (Score: 150+ in 14 hours)
Link: https://readhacker.news/s/6ixiK
Comments: https://readhacker.news/c/6ixiK
Cybertruck's Many Recalls Make It Worse Than 91 Percent of All 2024 Vehicles (🔥 Score: 159+ in 2 hours)
Link: https://readhacker.news/s/6iykM
Comments: https://readhacker.news/c/6iykM
Fly.io outage (restoration in progress) (🔥 Score: 152+ in 3 hours)
Link: https://readhacker.news/s/6ixYM
Comments: https://readhacker.news/c/6ixYM
Amazon S3 Adds Put-If-Match (Compare-and-Swap) (🔥 Score: 152+ in 2 hours)
Link: https://readhacker.news/s/6ixBQ
Comments: https://readhacker.news/c/6ixBQ
Do you need ID to read the REAL-ID rules? (🔥 Score: 152+ in 3 hours)
Link: https://readhacker.news/s/6ixnS
Comments: https://readhacker.news/c/6ixnS
The Nearest Neighbor Attack (❄️ Score: 150+ in 3 days)
Link: https://readhacker.news/s/6ipEx
Comments: https://readhacker.news/c/6ipEx
Introducing The Model Context Protocol (🔥 Score: 158+ in 3 hours)
Link: https://readhacker.news/s/6iwzJ
Comments: https://readhacker.news/c/6iwzJ
A Day in the Life: The Global BGP Table (Score: 150+ in 11 hours)
Link: https://readhacker.news/s/6ivkP
Comments: https://readhacker.news/c/6ivkP
LLVM-powered devirtualization (Score: 150+ in 9 hours)
Link: https://readhacker.news/s/6iz44
Comments: https://readhacker.news/c/6iz44
Poisoning the Day (❄️ Score: 150+ in 4 days)
Link: https://readhacker.news/s/6inKX
Comments: https://readhacker.news/c/6inKX
California's most neglected group of students: the gifted ones (🔥 Score: 164+ in 3 hours)
Link: https://readhacker.news/s/6izJG
Comments: https://readhacker.news/c/6izJG
Redis is trying to take over the all of the OSS Redis libraries (Score: 150+ in 23 hours)
Link: https://readhacker.news/s/6ixgH
Comments: https://readhacker.news/c/6ixgH
A solution to The Onion problem of J. Kenji Lopez-Alt (2021) (Score: 154+ in 6 hours)
Link: https://readhacker.news/s/6iyVG
Comments: https://readhacker.news/c/6iyVG
Show HN: Gemini LLM corrects ASR YouTube transcripts (Score: 150+ in 22 hours)
Link: https://readhacker.news/s/6ix3U
Comments: https://readhacker.news/c/6ix3U
Flipping FLIP ship saved from scrapyard at last minute (❄️ Score: 150+ in 6 days)
Link: https://readhacker.news/s/6igju
Comments: https://readhacker.news/c/6igju
Lies we tell ourselves to keep using Golang (🔥 Score: 158+ in 1 hour)
Link: https://readhacker.news/s/6iywe
Comments: https://readhacker.news/c/6iywe
Noise-canceling single-layer woven silk and cotton fabric (Score: 150+ in 17 hours)
Link: https://readhacker.news/s/6iw6F
Comments: https://readhacker.news/c/6iw6F
Baby’s Second Garbage Collector (❄️ Score: 150+ in 2 days)
Link: https://readhacker.news/s/6iqFD
Comments: https://readhacker.news/c/6iqFD
Show HN: I made an ls alternative for my personal use (Score: 151+ in 1 day)
Link: https://readhacker.news/s/6itTm
Comments: https://readhacker.news/c/6itTm
Show HN: Rill – Composable concurrency toolkit for Go (Score: 150+ in 6 hours)
Link: https://readhacker.news/s/6iwv8
Comments: https://readhacker.news/c/6iwv8
Mark–Scavenge: Waiting for Trash to Take Itself Out (Score: 150+ in 1 day)
Link: https://readhacker.news/s/6itVd
Comments: https://readhacker.news/c/6itVd
Hey, wait – is employee performance Gaussian distributed? (🔥 Score: 152+ in 3 hours)
Link: https://readhacker.news/s/6iwpj
Comments: https://readhacker.news/c/6iwpj
Lush: My favorite small programming language (❄️ Score: 150+ in 5 days)
Link: https://readhacker.news/s/6ifT4
Comments: https://readhacker.news/c/6ifT4