If you’re using Postgres and need to make an update to a row OR create a new row if one doesn’t exist, new versions of PostgreSQL make this a lot easier. In other databases this concept is usually referred to as upsert which is short for update / insert. Let’s see a full example, …

If you’ve ever had a long JavaScript sting that needs to maintain it’s string like format but is too long for your text editor or IDE’s window then this trick will help. Let’s say for example I need to create an OAuth URL for logging into my favorite provider. The values …

In recent years I’ve changed my approach to GIT version control to use a forking method vs. branching. While I still create branches, sometimes a lot of branches, where I create those branches has changed. Let’s say for example that I’m working on a team of 5 developers creating …