How you write time elapsed stamps in Python?

A common practice in any coding is to get a time stamp for the start and stop of a process, and probably calc the elapsed time since it started (ya know, because that means we don’t have to mentally calc it ourselves the zillion times the code will run!). The following is usually an example... Continue reading →

Chat GPT-4 SQL Refactoring for PostgreSQL

I wanted to do some refactoring to the previous SQL DDL I put together for music collectors. To add a little twist to the refactor I decided to do it all with Chat GPT-4 to see how it would do. This is the result! Continue reading →

Building a Multi-Tenant Music Collector’s Database

UPDATE: A subsequent post is available in refactoring this work with Chat GTP-4. Ok, I’ve gotten deep into collecting music again, after just doing the *streaming* thing for a decade plus. In this deep dive back into music and playing, composing, collecting, reactions, reviews, live shows, and related worlds coming together I’ve found it might... Continue reading →

Normalization in Relational Databases

This is a continuation of my posts on relational databases, started here. Previous posts on this theme, “Data Modeling“, “Let’s Talk About Database Schema“, “The Exasperating Topic of Database Indexes“, “The Keys & Relationships of Relational Databases“, and “Relational Database Query Optimization“. Consider you’re a die-hard fan of progressive death metal, with a particular affinity... Continue reading →