Top all-time · #11305
Schinckel.net
Personal blog · schinckel.netprogrammingdata
Schinckel.net is a personal blog at schinckel.net about programming and data. Since 2008, 7 different Hacker News readers have linked it 8 times, most often “Querying JSON in Postgres”. It is still writing: the last post was on 2026-10-20, and you can follow it by feed.
Too few sampled comments (3) to say how often HN recommends it.?
Why HN links it
HN commenters link this blog for posts on querying JSON in PostgreSQL, self-hosting a private PyPI package repository, and Django multitenancy. The comments cite these posts as sources rather than judging them.
Summarised by Claude from a sample of 3 HN comments that link here. Each comment is marked recommending, critical or neutral (citing without judging); how this works.
Most-linked posts?
- Querying JSON in Postgres2 people · 2 mentions · first linked 2014-11-21
What Hacker News says?
If it's a small tree, you could encode it as a single JSON object and query on it using PostgreSQL's JSON support. http://schinckel.net/2014/05/25/querying-json-in-postgres/
Comment linking /2014/05/25/querying-json-in-postgres/
on “Representing Trees in PostgreSQL”Submitted Aggregating Ranges in Postgres as a story · 5 points
HN discussionIn the Python world, you can self-host a copy of PyPI [1] (our package repo). Though you might do it for a faster build process, this can also prevent the "disappearing public repo" problem [2]. Is there something analogous for npm? 1: https://pypi.python.org/pypi/pypiserver 2: http://schinckel.net/2013/04/15/my-own-private-pypi/
Comment linking /2013/04/15/my-own-private-pypi/
on “NPM Package Hijacking From the Hijacker's Perspective”Submitted Postgres Tree Shootout Part 2: Adjacency List Using CTEs as a story · 4 points
HN discussionMaybe something like https://schinckel.net/2017/12/20/django-multitenancy-using-p...
Comment linking /2017/12/20/django-multitenancy-using-postgres-row-level-security/
on “How to Build a SaaS Application Block by Block”Submitted Querying JSON in Postgres as a story · 3 points
HN discussionSubmitted Using Postgres Composite Types in Django as a story · 1 points
HN discussionSubmitted Personal Password Management as a story · 1 points
HN discussion