Back to skills

PostgreSQL

Databases (DBMS & SQL) Since Jan 2019
L3
58/100

Other technologies

PostGIS PostgreSQL

Evidence

  • Why this level

    Summary

    PostgreSQL appears in concrete and varied contexts: PostGIS in a reservation app, the pg driver in Strapi, geodata and the GeoNature ecosystem.

  • Current ceiling

    Summary

    The main improvement axes to reach the next level are: document PostgreSQL administration more explicitly, show fine-grained tuning, replication, and more advanced maintenance operations.

  • PostGIS configuration

    Permalink Source

    The backend configuration in Parking App explicitly defines a PostgreSQL/PostGIS database in settings.

  • Geometries and spatial attachment

    Permalink Source

    The Parking App model uses PointField and spatial logic to attach a parking lot to a city, proving concrete use of the PostGIS stack.

  • PostgreSQL in the portfolio CMS

    Permalink Source

    The portfolio CMS depends on the pg driver and Strapi 5 for headless persistence.

  • Natural Solutions PostgreSQL/PostGIS footprint

    PR Source

    The GeoNature ecosystem uses PostgreSQL/PostGIS, SQL migrations and query optimization across several modules.

  • Docker services around the geo stack

    PR Source

    The one-shot services and raster imports added in GeoNature-Docker-services industrialize a geospatial stack built around GeoNature.