Programming Protips

Small posts meant to document the solutions to problems I've encountered while writing code and deploying apps.

Performing a "Select where property equals A or B" in CouchDB

Sometimes it can be difficult to translate SQL concepts over to document-style databases like CouchDB. In this post you'll learn how to select only documents with a specific set of property values while leaving out all other documents.

Backing up a Docker SQL Server database instance

Ever forget to set up data volumes for a Docker container, and then wondered how the heck you're supposed to back up the data inside? It's as easy as running a docker exec and a docker cp command!

Using Dapper with F#

A quick post showing you how to get up and running with Dapper in F#, including functions for getting, listing, deleting, updating and creating an object.

Implementing a JWT auth system with TypeScript and Node

JSON Web Tokens are a relatively popular method for implementing authentication and authorization systems in modern web applications. With wide package support across many programming languages, JWT is a simple way to secure your app and massively reduce requests to your user database.