Knowledge Base
Knowledge Base is an area where I share my experiences and expertise as a database architect on topics ranging from architecture and design to project management. I include tips & tricks, as well as useful code snippets wherever possible. Happy reading!
Project Management: Minimizing interruptions to software developers
Why minimizing interruptions to software developers is important.
Project Management: Time estimations
How to do time estimations in a software project.
Heroku: Can app.json Provision Staging and Production Apps?
Heroku staging and production apps do not make use of the app.json file.
Heroku: Use Selenium to run Google Chrome in a Python Script
How to run Google Chrome on Heroku using Selenium and Python.
Heroku: Run a Python App Locally
How to run a Heroku Python app locally using the app's config vars.
Using ON Versus WHERE Clauses to Combine and Filter Data in PostgreSQL Joins
In an SQL query, data can be filtered in the WHERE clause or the ON clause of a join. This guide
will examine the difference between the two in PostgreSQL.
SQL Developer: Autocomplete
Better autocomplete settings in SQL Developer.
SQL: LEFT JOIN and multiple matches on a key
Use ROW_NUMBER to deal with multiple matches on a key in a LEFT JOIN.
Bash: Error handling in scripts
Find errors and handle them in Bash.
Control-M: Exclusive resource
Prevent jobs from running in parallel.