Software, data, and opinions
Orsa is a
minimalistic
blog template
Features Posts
Tutorials
September 19, 2020
Replicating Aurora MySQL Database to Aurora Postgresql with pg_chameleon using Docker
Need to replicate a MySQL database to Postgres? This blog covers all the steps to get this working.
All Blog Posts
Python
October 9, 2020
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.
Tutorials
September 22, 2020
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.