PostGIS
Nik and Michael are joined by Regina Obe and Paul Ramsey to discuss PostGIS.
Here are some links to things they mentioned:
Here are some links to things they mentioned:
- Regina Obe https://postgres.fm/people/regina-obe
- Paul Ramsey https://postgres.fm/people/paul-ramsey
- PostGIS https://postgis.net
- MobilityDB https://github.com/MobilityDB/MobilityDB
- pgRouting https://github.com/pgRouting/pgrouting
- Google BigQuery GIS public alpha blog post https://cloud.google.com/blog/products/data-analytics/whats-happening-bigquery-integrated-machine-learning-maps-and-more
- PostGIS Day 2025 talk recordings https://www.youtube.com/watch?v=wuNO_cW2g-0&list=PLavJpcg8cl1EkQWoCbczsOjFTe-SHg_8m
- pg_lake https://github.com/Snowflake-Labs/pg_lake
- GeoParquet https://geoparquet.org
- ST_DWithin https://postgis.net/docs/ST_DWithin.html
- Postgres JSONB Columns and TOAST: A Performance Guide https://www.snowflake.com/en/engineering-blog/postgres-jsonb-columns-and-toast
- FOSS4G https://foss4g.org
- OpenStreetMap https://www.openstreetmap.org
- PgDay Boston https://2026.pgdayboston.org
- SKILL.md file https://github.com/postgis/postgis/blob/68dde711039986b47eb62feda45bb24b13b0ea37/doc/SKILL.md
- Production query plans without production data (blog post by Radim Marek) https://boringsql.com/posts/portable-stats
- PostgreSQL: Up and Running, 4th Edition (by Regina Obe, Leo Hsu) https://www.oreilly.com/library/view/postgresql-up-and/9798341660885
~~~
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!
~~~
Postgres FM is produced by:
- Michael Christofides, founder of pgMustard
- Nikolay Samokhvalov, founder of Postgres.ai
With credit to:
- Jessie Draws for the elephant artwork
Creators and Guests
Guest
Paul Ramsey
Loving open source software, practicing the piano, moving things around, working @crunchydata