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 …

Database generated columns⁽¹⁾: Django & SQLite

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

© 2023 Paolo Melchiorre “View of clouds over the Labrador Peninsula (Canada) taken from a commercial flight.”
© 2023 Paolo Melchiorre “View of clouds over the Labrador Peninsula (Canada) taken from a commercial flight.”
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 …

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 …

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 …

Upgrade PostgreSQL from 11 to 12 on Ubuntu 20.04

Howto guide for upgrading PostgreSQL from version 11 to 12 on Ubuntu, after its upgrade from version 19.10 to 20.04 (Focal Fossa).

© 2020 Paolo Melchiorre (CC BY-SA) “Sunset behind the Gran Sasso massif seen from my house in Pescara (Italy)”
© 2020 Paolo Melchiorre (CC BY-SA) “Sunset behind the Gran Sasso massif seen from my house in Pescara (Italy)”
Read more …

Upgrade PostgreSQL from 10 to 11 on Ubuntu 19.04

Howto guide for upgrading PostgreSQL from version 10 to 11 on Ubuntu, after its upgrade from version 18.10 to 19.04 (Disco Dingo).

© 2019 Paolo Melchiorre CC BY-SA “Photo of Central Train Station of Bologna (Italy) taken on the way back from PGDay.IT 2019”
© 2019 Paolo Melchiorre CC BY-SA “Photo of Central Train Station of Bologna (Italy) taken on the way back from PGDay.IT 2019”
Read more …

Update annotated Django querysets using subqueries

How-To guide to update a Django queryset with annotation and subquery.

© 2018 Paolo Melchiorre “Photo of Cerrano beach in Abruzzo, Italy”
© 2018 Paolo Melchiorre “Photo of Cerrano beach in Abruzzo, Italy”
Read more …

Upgrade PostgreSQL from 9.6 to 10 on Ubuntu 18.04

Howto guide for upgrading PostgreSQL from version 9.6 to 10.0 on Ubuntu, after its upgrade from version 17.10 to 18.04 (Bionic Beaver).

© 2018 Paolo Melchiorre CC BY-SA “Photo of Lake Como taken from the beach of Bellagio (Italy)”
© 2018 Paolo Melchiorre CC BY-SA “Photo of Lake Como taken from the beach of Bellagio (Italy)”
Read more …