Manage your infrastructure in the same ways you manage your applications
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
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
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
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
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
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!
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
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
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
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. https://www.linkedin.com/in/mikehuls
