Showing 1 to 6 of 15 blog posts tagged with "postgresql".
-
Avoiding Timezone Traps: Correctly Extracting Date/Time Subfields in Django with PostgreSQL
Working with timezones can sometimes lead to confusing results, especially when combining Django's ORM, raw SQL for performance (like in PostgreSQL materialized views), and spe... Read more
June 16, 2025 -
Tips for Tracking Django Model Changes with django-pghistory
Django and its admin interface are a big part of why Caktus uses Django, but the admin's ability to log database changes is limited. For example, it shows only changes made via... Read more
April 7, 2025 -
How to Use regexp_matches and regexp_match in PostgreSQL
Introduction regexp_matches() and regexp_match() are two similar string functions that support regular expression matching directly in the PostgreSQL database. regexp_matches(... Read more
March 19, 2025 -
Getting Started with Dagster
Recently, Caktus has been using Tailscale to manage VPN connections between Android tablets and a central server. We wanted to report on the devices connected to the network us... Read more
December 9, 2024 -
How to Use Kubernetes on Azure for Cloud Computing
For the Review, Appraisal, and Triage of Mail (RATOM) project, funded by the Andrew W. Mellon Foundation, we were tasked with deploying to a Microsoft Azure environment. More d... Read more
April 28, 2020 -
Postgres Present and Future (PyCon 2016 Must-See Talk: 6/6)
Coming from a heavy database admin background, I found Craig Kerstiens’s “Postgres Present and Future" to be incredibly well organized and engaging. Read more
August 18, 2016