Software, data, and opinions

Features Posts

All Blog Posts

Hardwired Setup for Sonos 5.1 Theater System

How to hardwire a Sonos 5.1 setup

SQLAlchemy's ORM ilike Queries Do Not Preserve String Casing on Results

SQLAlchemy with Posgresql generates an unexpected result when using ilike ORM queries.... The strings that are returned on the fields which "ilike" queries are performed are returned in all lowercase despite being stored in the database with varied casing.

Python ModuleNotFoundError: No module named ‘XYZ’ not found; TLDR: CRLF

Finding and Indexing Columns Across Entire Postgresql Database, Easily

In this post I provide a query that generates SQL statements to easily index identifier columns in your postgresql database.