pglite, that's Postgres running in browser, just got PostGIS extension support, so you can probably do weird things like, bah, I don't know.

https://github.com/electric-sql/pglite
https://www.npmjs.com/package/@electric-sql/pglite-postgis

#postgres #postgis cc. @abel

GitHub - electric-sql/pglite: Embeddable Postgres with real-time, reactive bindings.

Embeddable Postgres with real-time, reactive bindings. - electric-sql/pglite

GitHub

I've had a grand day out in beautiful South Wales doing PostGIS and tech lead bits.

Spent most of the day inside (naturally) but some cracking views from the train 🚄

#postgis #geo #osgeo @astuntechnology

Postgres FM | PostGIS

Nik and Michael are joined by Regina Obe and Paul Ramsey to discuss PostGIS. Here are some links to things they mentioned:Regina Obe https://postgres.fm/people/regina-obePaul Ramsey https://postgres.fm/people/paul-ramseyPostGIS https://postgis.netMobilityDB...

H3/PostGIS: Hands-on example: Darafei Praliaskouski, member of the #PostGIS PSC, walks through an interesting hands-on case study of modelling #LoRa radio tower range in the mountains of Georgia using #H3 and PostGIS. The example covers data preparation, #DGGS indexing, and...
https://spatialists.ch/posts/2026/02/27-h3-postgis-hands-on-example/ #GIS #GISchat #geospatial #SwissGIS
H3/PostGIS: Hands-on example – Spatialists – geospatial news

Darafei Praliaskouski, member of the #PostGIS PSC, walks through an interesting hands-on case study of modelling #LoRa radio tower range in the mountains of Georgia using #H3 and PostGIS. The example covers data preparation, #DGGS indexing, and spatial analysis, and offers some food for thought.

Spatialists – geospatial news

Morgen: Kostenloses #PostGIS Web-Seminar! ⏳️

📑 Trigger, automatisierte Verarbeitung & zeitgesteuerte Aktionen

🖥️ Online
📆 5. März 2025, 10:00–11:00 Uhr

👇
https://us06web.zoom.us/webinar/register/WN_LdMyRiMUSoOjGqPhZSJdUA

#PostgreSQL #GDI #OpenSource @wheregroup

Переезд с MySQL на PostgreSQL в Laravel: как мы перенесли гео сервис и не сошли с ума

Привет! Недавно мы с проектом (а по факту я в гордом одиночестве) переезжали с MySQL на PostgreSQL. Зачем? Проект — гео‑сервис для рыбаков: карта с точками, поиск рядом, фильтры по регионам, водоёмам и рыбам. MySQL стал тормозить на гео‑запросах, а PostGIS обещал скорость и порядок. Плюс мы всё равно переезжали на новый VDS – решили заодно сменить СУБД, пока данных не стало неприлично много.

https://habr.com/ru/articles/1004826/

#mysql #postgresql #миграция #перенос_данных #pgloader #postgis #laravel #геоданные #filament

Переезд с MySQL на PostgreSQL в Laravel: как мы перенесли гео сервис и не сошли с ума

Привет! Недавно мы с проектом (а по факту я в гордом одиночестве) переезжали с MySQL на PostgreSQL. Зачем? Проект — гео‑сервис для рыбаков: карта с точками, поиск рядом, фильтры по регионам, водоёмам...

Хабр
H3/PostGIS: Hands-on example: @komzpa, member of the #PostGIS PSC, walks through an interesting hands-on case study of modelling #LoRa radio tower range in the mountains of Georgia using #H3 and PostGIS. The example covers data preparation, #DGGS indexing, and...
https://spatialists.ch/posts/2026/02/27-h3-postgis-hands-on-example/ #GIS #GISchat #geospatial #SwissGIS
H3/PostGIS: Hands-on example – Spatialists – geospatial news

Darafei Praliaskouski, member of the #PostGIS PSC, walks through an interesting hands-on case study of modelling #LoRa radio tower range in the mountains of Georgia using #H3 and PostGIS. The example covers data preparation, #DGGS indexing, and spatial analysis, and offers some food for thought.

Spatialists – geospatial news
PostGIS Spatial Tricks with Regina Obe is a brilliant deep dive into PostGIS 2.2 and upcoming 2.3—KNN, proximity, geometry ops and more. Ideal for GIS devs, DBAs and map nerds who want to level up spatial queries. Energetic, practical talk! #PostGIS #GIS #Geospatial #PostgreSQL #SpatialSQL #OpenSource #Mapping #English
https://videos.pcorp.us/videos/watch/9079f057-342b-4363-ab60-320b73d7a225
PostGIS Spatial Tricks

PeerTube

#PostGIS ST_Letters – Worte sagen manchmal mehr 👀

🤔 Warum nach Geodaten suchen, wenn ST_Letters im Nu Geometrien aus Text erzeugt?

💪 Diese oft übersehene Funktion nimmt einen Text und gibt ihn als Multipolygon-Geometrie aus – spielerisch & nützlich!

👤 Astrid Emde stellt die Funktion auf der #FOSSGIS2026 vor 💡

📅 Do, 26. März | 15:25 Uhr
📍 Raum HS3 (ZHG 009)

👉 https://pretalx.com/fossgis2026/talk/AXWCQT/

#SQL #SpatialSQL #PostgreSQL #OpenSource #GIS #DevTalk #OSGeo

PostGIS ST_Letters - Worte sagen manchmal mehr FOSSGIS-Konferenz 2026

Warum nach Geodaten suchen, wo es doch die PostGIS-Funktion ST_Letters gibt, die im Nu Geometrien erzeugt? ST_Letters ist eine recht unbekannte Funktion, die einen Text übergeben bekommt und diesen als Geometrie ausgibt. Genauer wird die Zeichenfolge von ST_Letters als Multipolygon ausgegeben. https://postgis.net/docs/ST_Letters.html

Nice To Be 'Back In The Data Trenches' Directly
--
https://www.usgs.gov/3d-hydrography-program <-- shared U.S. Geological Survey (USGS) #3DHP home page
--
I don't get to be here that often (and that is OK, #ILikeMyJob) - but it is nice to be back working directly with some individual spatial datasets - be it in #QGIS, #ArcGISPro, #PostgreSQL / #PostGIS or wherever...
#GIS #spatial #mapping #water #dataquality #water #hydrography #3DHP #NHD #opendata #USA #MI #reservoirs #dams #pluvial #fluvial #usecase #SQL