Use HTTPS instead of SSH when cloning git submodules

Git is a free and open source distributed version control system designed to handle everything from small to very large projects with speed and efficiency. In this article you will learn how to use HTTPS instead of SSH when using the git submodules command. [Read more...]

Signing commits for GitLab using GnuPG on macOS

git is a free and open source distributed version control system designed to handle everything from small to very large projects with speed and efficiency. In this article you will learn how to setup git to sign your commits using GnuPG (GPG) and how to properly configure GitLab to deal with those signed commits. [Read more...]

Using named parameters with the sqlx Golang library

When it comes to SQL the Golang ecosystem offers a lot of choices. You can choose between full-featured object-relational mappers like gorm, the Golang standard library or sqlx for instance. This article will show you how you can use named parameters together with sqlx. [Read more...]

If a Postgres table is dropped, do you also have to delete it's indexes, triggers or constraints?

I have come accross this question many times: “If I delete a Postgres table, do I also have to delete it’s indexes, triggers and constraints before or afterwards?“. The short answer is no. When a table is dropped, Postgres will also delete it’s related indexes, triggers and constraints. In the following article a docker-compose.yml file and some code snippets are provided if you want to validate this behaviour. [Read more...]