Welcome

Hello! I'm Heiko, and here I collect various notes.

Querying PostGIS columns with Supabase and TypeScript

Supabase's type generator is very helpful when using supabase-js with TypeScript. But when your query selects a PostGIS geometry type column, its generated type will be unknown. We have a few options: supabase-js queries Supabase's PostgREST API, which actually returns geometry columns in a usable…

Continue reading...

Hosting static OSM vector tiles on object storage

Need a map for your project? You could just use Google Maps, but their styling options are limited and it's expensive at scale. Various providers offer raster tiles in more interesting styles based on OpenStreetMap, but you're still limited to their designs. Vector tiles based…

Continue reading...