Manage your infrastructure in the same ways you manage your applications

We’re shipping containers today! (Image by Pixabay on Pexels)

Docker is a fantastic tool that makes our lives much easier offering us standardization, productivity, efficiency, maintainability and compatibility of our code. It allows us to continuously and rapidly deploy and test our code and it is platform-independent.

If you are unsure of what Docker is, what to use it…

Easily plan, validate, and safely apply changes to your database

Imagine these boxes are stuffed with schema’s and tables (Photo by Ketut Subiyanto on Pexels)

If you are not working with migrations in your database you’re missing out. Like Git manages changes to source code, you can use migrations to keep track of changes to your database. Execute and revert changes and get your database back into a previous state.

Setting up migrations is easier…

Prevent duplicates, insert new records, updated existing ones

In stead of joining roads we’ll be safely joining datasets in our database (image by Sigmund on Unsplash)

When you UPSERT data into a table, you update or ignore records that already exist and insert new ones. After reading this article, you’ll be able to perform a single query in Postgres that allows you to do exactly this. We’ll go through a practical example that demonstrates how to…

Learn how to catch requests and obtain the information that they carry

Our API listening to incoming requests (image by Donald Giannatti on Unsplash)

In the previous article we’ve set up an API in 5 lines of code. We’ve install our dependencies and created a working API with just one simple route. In this article we’ll build further, fleshing out the API with multiple, different routes that’ll show you all the things you can…

Perfect for (unexperienced) developers who just need a complete, working, fast and secure API

Building and using our API will be as easy as using this vending machine (image by Jenna Hamra on Pexels)

You have a great python program that you want to make available to the world. With FastAPI you can speedily create a superfast API that’ll allow you to make your Python code available for other users.

In this article we’re going to create an API in 5 lines of code

No more waiting for slow queries to finish

How can we quickly find our data in these rows of records? (Image by Fabien Barral on Unsplash)

Ever wondered how a database engine can return data for your queries that fast? How it can search through many tables, and millions of records in a flash? This article explores how the database engine works under the hood and sheds light on how to design your tables and indices…

You’ve got values for which you have IDs in a table. Insert the IDs in one go!

Searching some ids (image by Lucas Pezeta on Pexels)

What do you do when our table expects id’s but all we have are strings? Let’s imagine we’re a restaurant. …

Insert a value into a table if it doesn’t already exist

We only want unique values in our table (image by Darius Cotoi on Unsplash)

Imagine we are a restaurant that sells all kinds of dishes. Because we’re smart we keep track of all of our ingredients in a database. The ingredients table will contain only unique ingredients that each have their own id.

The goal of this article is to create a query that…

Easily share and run code in a Docker container

Your packaged code is being delivered (image by Kira auf der Heide on Unsplash)

With Docker, it is easy to package your code into an image that we can run anywhere, anytime; regardless of your hardware or software. It will run on a laptop, Raspberry Pi, Server, Mac, Linux or Windows. This article will detail the process of packaging your script into a Docker…

Lightning-fast insert and/or update with Python

Time to update our storage and insert some new things (image by Steve Johnson on Unsplash)

When you upsert data into a table, you update records that already exist and insert new ones. After reading this article, you’ll be able to connect your Python application to a database and upsert data lightning fast. We’ll go through a few practical examples that demonstrate various ways to do…

Mike Huls

I'm a full-stack developer with a passion for programming, technology and traveling.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store