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
Show HN: TeaTime – distributed book library powered by SQLite, IPFS and GitHub (Score: 151+ in 18 hours)
Link: https://readhacker.news/s/6iCxi
Comments: https://readhacker.news/c/6iCxi
Recently there seem to be a surge in SQLite related projects. TeaTime is riding that wave...
A couple of years ago I was intrigued by phiresky's post[0] about querying SQLite over HTTP. It made me think that if anyone can publish a database using GitHub Pages, I could probably build a frontend in which users can decide which database to query. TeaTime is like that - when you first visit it, you'll need to choose your database. Everyone can create additional databases[1]. TeaTime then queries it, and fetches files using an IPFS gateway (I'm looking into using Helia so that users are also contributing nodes in the network). Files are then rendered in the website itself. Everything is done in the browser - no users, no cookies, no tracking. LocalStorage and IndexedDB are used for saving your last readings, and your position in each file.
Since TeaTime is a static site, it's super easy (and free) to deploy. GitHub repo tags are used for maintaining a list of public instances[2].
Note that a GitHub repository isn't mandatory for storing the SQLite files or the front end - it's only for the configuration file (config.json) of each database, and for listing instances. Both the instances themselves and the database files can be hosted on Netlify, Cloudflare Pages, your Raspberry Pi, or any other server that can host static files.
I'm curious to see what other kinds of databases people can create, and what other types of files TeaTime could be used for.
[0] https://news.ycombinator.com/item?id=27016630
[1] https://github.com/bjesus/teatime-json-database/
[2] https://github.com/bjesus/teatime/wiki/Creating-a-TeaTime-in...
QwQ: Alibaba's O1 Like Reasoning LLM (Score: 151+ in 7 hours)
Link: https://readhacker.news/s/6iDwi
Comments: https://readhacker.news/c/6iDwi
Malware can turn off webcam LED and record video, demonstrated on ThinkPad X230 (🔥 Score: 163+ in 1 hour)
Link: https://readhacker.news/s/6iDxY
Comments: https://readhacker.news/c/6iDxY
Ask HN: Recommendation for a SWE looking to get up to speed with latest on AI (Score: 155+ in 5 hours)
Link: https://readhacker.news/c/6iCx7
I am looking to get up to speed with the latest things happening in AI, I use ChatGPT almost everyday and i last used the open AI api for 3.5 last year. I am looking for a tech blogs like HN to keep updated on things AI, I came across https://simonwillison.net/ but it appears fragmented
I Stopped Using Kubernetes. Our DevOps Team Is Happier Than Ever (Score: 150+ in 22 hours)
Link: https://readhacker.news/s/6izAD
Comments: https://readhacker.news/c/6izAD
Raspberry Pi CM5 is a faster, drop-in upgrade (Score: 151+ in 4 hours)
Link: https://readhacker.news/s/6iBYv
Comments: https://readhacker.news/c/6iBYv
Lonely individuals tend to think and talk in an unusual way, study finds (❄️ Score: 150+ in 2 days)
Link: https://readhacker.news/s/6ivGZ
Comments: https://readhacker.news/c/6ivGZ
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
Show HN: Feels Like Paper (Score: 150+ in 10 hours)
Link: https://readhacker.news/s/6iDiN
Comments: https://readhacker.news/c/6iDiN
"Feels Like Paper!" is a series of prototypes about augmenting physical paper through AI. Various ML models, LLMs and a mixed reality headset are used to infuse physical paper and ink with properties of the digital world without compromising on their physical traits.
Comparing AWS S3 with Cloudflare R2: Price, Performance and User Experience (Score: 150+ in 6 hours)
Link: https://readhacker.news/s/6iCKd
Comments: https://readhacker.news/c/6iCKd
You can use C-Reduce for any language (🔥 Score: 150+ in 2 hours)
Link: https://readhacker.news/s/6iDaZ
Comments: https://readhacker.news/c/6iDaZ
I Wrote "Janet for Mortals" (Score: 150+ in 8 hours)
Link: https://readhacker.news/s/6iBCb
Comments: https://readhacker.news/c/6iBCb
We can mine asteroids for space food (Score: 150+ in 1 day)
Link: https://readhacker.news/s/6iyFd
Comments: https://readhacker.news/c/6iyFd
Show HN: App that asks 'why?' every time you unlock your phone (🔥 Score: 155+ in 2 hours)
Link: https://readhacker.news/s/6iBUw
Comments: https://readhacker.news/c/6iBUw
NASA: Mystery of Life's Handedness Deepens (❄️ Score: 150+ in 4 days)
Link: https://readhacker.news/s/6ip9Z
Comments: https://readhacker.news/c/6ip9Z
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