david.reviews

➡️ https://david.reviews ⬅️

This is an Astro + Tailwind site which collects all of my media micro-reviews. Data is stored in Airtable an loaded using a custom ORM. It ships remarkably little JS to the frontend.

ORM

I wrote a custom typed ORM for loading Airtable data. To add new fields:

1. Go to the docs page and select your base
2. Find the fld... ids you're adding
3. Add them (and a name) to the SCHEMA.fields object in the airtable/data/<BASE>.ts file
4. If any added fields aren't strings, add them (by field.NAME) to NonStringFields
5. Add the relevant output fields to the exported type. This represents the object returned by materialize (which turns a row into a usable object)
6. Ensure those new types get materialized

Misc

• I shrink images using https://compresspng.com/
• Brand icons are sourced from https://simpleicons.org/