Working with JSON and PostgreSQL - Geotribu in English

[giscus[bot]]

Working with JSON and PostgreSQL - Geotribu in English

Store data in JSON format in PostgreSQL, consult it... and all this using INSEE french census data as an example.

https://blog.geotribu.net/2025/03/04/working-with-json-and-postgresql/

[4estone]

Realy interesting!
Question: which tool did you use for creating the model?

[Guts]

ping @thomas-szczurek

[thomas-szczurek]

Hello @4estone , I used pgmodeler. This tool is dedicated to postgresql and I really like it ! There are pre-compiled packages for Linux (both apt or dnf for red hat distributions) . On Windows you'll have to build it from sources it you don't want / can't pay it.