Viewing profile — ers35

Use the trigram tokenizer: https://www.sqlite.org/fts5.html#the_trigram_tokenizer

See also: https://phoboslab.org/log/2023/02/qoa-time-domain-audio-comp...

Maybe Cosmopolitan could be used with luastatic[1] to compile a Lua program to an "Actually Portable Executable": CC="" luastatic main.lua # Compile main.luastatic.c with Cosmopoli…

Mirror: https://media.libreplanet.org/u/libreplanet/m/a-prerecorded-...

Mirror: http://archive.is/ewDJq

I've been focusing on reading, but it looks like there is interest in writing too. The HN API doesn't support writing, so the username and password has to be stored. It's important…

You can search previous comments: https://hn.algolia.com/?dateRange=all&page=0&prefix=true&que...

HN itself is fast, but the comparison I'm making is with readers that use the HN API. See how getting each comment requires an additional API request: https://hacker-news.firebasei…

There have been many HN related websites posted over the years, but a lot end up as dead links. A self-hosted version does not depend on a third party. Another reason is to minimiz…

That reminds me of how https://forum.dlang.org works: https://github.com/CyberShadow/DFeed It also uses SQLite.

You might find this interesting: https://github.com/donnemartin/haxor-news

Great idea. This could also be useful to post a mirror for other users if the site ends up going down.

I prototyped this in Qt 2 years ago: https://ers35.com/files/hackernews-qt.png 1) It is possible to keep the whole site offline. A database from 2017 is 9 GB: https://archive.org/d…

HN is a treasure trove of information. The primary way I read HN is to bookmark stories and read the comments when the discussion is complete. Others actively participate. Some get…

https://en.wikipedia.org/wiki/Little_Bunny_Foo_Foo

My DB covers from https://hacker-news.firebaseio.com/v0/item/1.json?print=pret... (10/09/2006 at 6:21pm UTC) to https://hacker-news.firebaseio.com/v0/item/14372035.json?pri... (05/…

7.27 GB.

You can see the size of the download by clicking show all: https://archive.org/download/14566367HackerNewsCommentsAndSt...

See also: A dump of the stories, comments, and users from the Firebase API as a SQLite database with a full text search index: https://archive.org/details/hackernews-2017-05-18.db

I'm working on a tool that maintains an up to date archive of Hacker News and a companion tool to browse and search it. I'm not ready to release yet, but here is a dump of the stor…

If you're a fan of demoscene music, see Nectarine Demoscene Radio at https://www.scenemusic.net/ .

Yes. One can identify the IP address of the origin server behind a reverse proxy if the server responds to direct requests in a way that identifies itself. See: https://cloudpierce…

I used Censys to search for the IPv4 addresses of servers serving matching TLS certificates: https://censys.io/ipv4?q=443.https.tls.certificate.parsed.na...