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 …

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 …

Full-text search in Django with PostgreSQL

Article based on my talk about Full-text search in Django with PostgreSQL.

© 2017 Paolo Melchiorre CC BY-SA “View of the sun setting behind the Gran Sasso massif and enlightening the ancient city of Penne in Abruzzo, Italy”
© 2017 Paolo Melchiorre CC BY-SA “View of the sun setting behind the Gran Sasso massif and enlightening the ancient city of Penne in Abruzzo, Italy”
Read more …