A run402 example

Field Notes

Every post here is a row in a Postgres table. Astro read those rows at build time and wrote this site to disk, so the page you are looking at is a file.

  1. Ren Iwata

    Search that does not lie

    Everything on this site is a static file except one path. Here is why search is the exception and what that costs.

  2. Nadia Farouk

    Drafts are a row policy

    There is a sixth post in this database that you cannot read. Not because the page hides it, but because Postgres refuses to hand it over.

  3. Maya Okonkwo

    A build step is a promise about time

    Static generation moves work from every request to one moment. The interesting question is which moment, and what is true when it happens.

  4. Ren Iwata

    The shape of a good slug

    A URL is a promise you make to strangers. Ours is a primary key with a CHECK constraint, and that turned out to matter more than it sounds.

  5. Maya Okonkwo

    Hello from a database

    The page you are reading was assembled at build time out of a row in Postgres. Here is what that means and what it costs.