#api

• RFC: Restful Secondary Key API

  https://justatheory.com/2022/08/rfc-restful-secondary-key-api

  A RESTful API design conundrum and a proposed solution.

  Indexed 3/4/2026

• Patch: Postgres ABI and API Guidance

  https://justatheory.com/2024/06/abi-api-guidance

  Dear Postgres extension developers: Please review and give feedback on the proposed patch adding ABI and API guidance to the C language documentation.

  Indexed 4/13/2026

• Timehop notified me that Instagram (a.k.a. Meta) is... | Note | gerben.dev

  https://gerben.dev/notes/64f921f0aee35e86e2ae580119412d2a

  Timehop notified me that Instagram (a.k.a. Meta) is restricting their API and as such it won't show me my images. Impeccable timing, since I'm fully gearing up to use the #indieweb and was alr...

  Indexed 4/15/2026

• Custom SQLite Aggregates in Perl

  https://justatheory.com/2005/10/sqlite-perl-aggregates

  About a year ago, Josh Berkus was reviewing some Bricolage SQL code, looking to optimize it for PostgreSQL. One of the things he noticed was that we were fetching a lot more rows for an object than we needed to. The reason for this is that an object might be associated with one or more groups, and to get back a list of all of the group IDs, we were getting multiple rows. For example, if I wanted to fetch a single story with the ID 10, I might get back rows like this:

  Indexed 11/25/2025