June 2024 Summaries

Overture Maps Foundation is a joint development project between Amazon, Meta, Microsoft, and tomtom, aiming to create reliable, easy-to-use, and interoperable open map data. The foundation provides a python command-line tool to download places in various formats, including GeoJSON, and enables users to transform the downloaded data into SQL statements for import into Supabase Postgres databases using GDAL ogr2ogr. Once imported, users can utilize PostGIS to generate vector tiles from their location data, serving them to MapLibre GL clients via supabase-js for on-demand rendering of interactive geospatial applications with ease, while also fetching additional JSON metadata on demand to reduce data transfer over the web.

Protomaps is an open source map of the world, deployable as a single static file on Supabase Storage, allowing users to extract areas from the world map and compress them into a single static PMTiles file. Users can then upload these files to Supabase Storage, where they can be rendered using MapLibre GL or Leaflet, and accessed with restricted permissions through Supabase Edge Functions, which enable secure server-side access control.

The Cal.com and Supabase teams collaborated on a new platform starter kit, leveraging their shared mission to build open source software. The application was initially built on SQLite but switched to Postgres three days before launch, utilizing Prisma for efficient connection management and multischema support. Supabase Storage provides secure file storage with integrated authentication, while the Cal.com team uses Next.js' Auth.js for authentication. A custom Next.js Image loader is also created to facilitate Supabase Storage usage. Additionally, a Vercel Integration allows for one-click deploys and environment variable syncing across branches. The starter kit is open source, allowing users to spin up their own marketplace with convenient scheduling in minutes and contribute additional features.