14849
Top stories from https://news.ycombinator.com (with 100+ score) Contribute to the development here: https://github.com/phil-r/hackernewsbot Also check https://t.me/designer_news Contacts: @philr
The capacitor that Apple soldered incorrectly at the factory (Score: 155+ in 4 hours)
Link: https://readhacker.news/s/6iBzZ
Comments: https://readhacker.news/c/6iBzZ
ISPs say their "excellent customer service" is why users don't switch providers (Score: 150+ in 7 hours)
Link: https://readhacker.news/s/6iB6e
Comments: https://readhacker.news/c/6iB6e
D-Link says it won't patch 60k older modems (Score: 153+ in 10 hours)
Link: https://readhacker.news/s/6iAwy
Comments: https://readhacker.news/c/6iAwy
Marshall Brain died hours after alleging retaliation at NC State (🔥 Score: 153+ in 3 hours)
Link: https://readhacker.news/s/6iB7S
Comments: https://readhacker.news/c/6iB7S
Teen mathematicians tie knots through a mind-blowing fractal (Score: 150+ in 6 hours)
Link: https://readhacker.news/s/6iA92
Comments: https://readhacker.news/c/6iA92
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
ZetaOffice: LibreOffice in the Browser (Score: 151+ in 12 hours)
Link: https://readhacker.news/s/6iAvL
Comments: https://readhacker.news/c/6iAvL
I Didn't Need Kubernetes, and You Probably Don't Either (Score: 150+ in 4 hours)
Link: https://readhacker.news/s/6iBk2
Comments: https://readhacker.news/c/6iBk2
Hacker in Snowflake extortions may be a U.S. soldier (Score: 153+ in 4 hours)
Link: https://readhacker.news/s/6iBar
Comments: https://readhacker.news/c/6iBar
GenChess (Score: 150+ in 8 hours)
Link: https://readhacker.news/s/6iA9Q
Comments: https://readhacker.news/c/6iA9Q
Scientists are learning why ultra-processed foods are bad (Score: 150+ in 8 hours)
Link: https://readhacker.news/s/6izy5
Comments: https://readhacker.news/c/6izy5
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