Database generated columns⁽³⁾: GeoDjango & PostGIS

An introduction to database generated columns, using PostgGIS, GeoDjango and the new GeneratedField added in Django 5.0.

© 2023 Paolo Melchiorre “Historical globe inside the Miramare Castle in Trieste (Italy)”
© 2023 Paolo Melchiorre “Historical globe inside the Miramare Castle in Trieste (Italy)”
Read more …

Database generated columns⁽²⁾: Django & PostgreSQL

An introduction to database generated columns, using PostgreSQL and the new GeneratedField added in Django 5.0.

© 2023 Paolo Melchiorre “Port Authority building (Port House) in the Port of Antwerp in Belgium.”
© 2023 Paolo Melchiorre “Port Authority building (Port House) in the Port of Antwerp in Belgium.”
Read more …

Upgrade PostgreSQL from 14 to 15 on Ubuntu 23.04

Howto guide for upgrading PostgreSQL from version 14 to 15 on Ubuntu, after its upgrade from version 22.10 to 23.04 (Lunar Lobster).

© 2023 Paolo Melchiorre “View of the Great Salt Lake and the Wasatch Mountains in the background, Utah (USA)”
© 2023 Paolo Melchiorre “View of the Great Salt Lake and the Wasatch Mountains in the background, Utah (USA)”
Read more …

Citus Con 2023

An Event for Postgres is a free and virtual developer event organized by the Postgres team at Microsoft Azure.

© 2023 Paolo Melchiorre CC BY-SA “Paolo Melchiorre with Claire Giordano at CitusCon 2023”
© 2023 Paolo Melchiorre CC BY-SA “Paolo Melchiorre with Claire Giordano at CitusCon 2023”
Read more …

Upgrade PostgreSQL from 13 to 14 on Ubuntu 22.04

Howto guide for upgrading PostgreSQL from version 13 to 14 on Ubuntu, after its upgrade from version 21.10 to 22.04 (Jammy Jellyfish).

© 2022 Paolo Melchiorre “Photo of Pineto beach in Abruzzo, Italy”
© 2022 Paolo Melchiorre “Photo of Pineto beach in Abruzzo, Italy”
Read more …

Citus Con 2022

An Event for Postgres is a free and virtual developer event organized by the Postgres team at Microsoft Azure.

© 2022 Citus Data “Paolo Melchiorre at Citus Con 2022”
© 2022 Citus Data “Paolo Melchiorre at Citus Con 2022”
Read more …

Maps with Django⁽²⁾: GeoDjango, PostGIS & Leaflet

A quickstart guide to create a web map with the Python-based web framework Django using its module GeoDjango, the PostgreSQL database with its spatial extension PostGIS and Leaflet, a JavaScript library for interactive maps.

© 2020 Paolo Melchiorre “Photo at the sunrise of Bivacco Fusco trail sign in Abruzzo, Italy”
© 2020 Paolo Melchiorre “Photo at the sunrise of Bivacco Fusco trail sign in Abruzzo, Italy”
Read more …

Upgrade PostgreSQL from 12 to 13 on Ubuntu 21.04

Howto guide for upgrading PostgreSQL from version 12 to 13 on Ubuntu, after its upgrade from version 20.10 to 21.04 (Hirsute Hippo).

© 2021 Paolo Melchiorre (CC BY-SA) “View of the beach seen from Palazzo D'Avalos in Vasto (Italy)”
© 2021 Paolo Melchiorre (CC BY-SA) “View of the beach seen from Palazzo D'Avalos in Vasto (Italy)”
Read more …

Speaking online at EuroPython 2020

An article about my first participation as a speaker at an online conference: EuroPython 2020.

© 2020 Paolo Melchiorre “Photo of Paolo Melchiorre speaking at EuroPython 2020 Online Edition”
© 2020 Paolo Melchiorre “Photo of Paolo Melchiorre speaking at EuroPython 2020 Online Edition”
Read more …

EuroPython 2020

EuroPython is the official European conference for the Python programming language.

Paolo Melchiorre - A pythonic full-text search - EuroPython 2020
Paolo Melchiorre - A pythonic full-text search - EuroPython 2020
Read more …