How to list all the tables in a PostgreSQL database
Suppose you have to list all the tables of PostgreSQL database. You can achieve this by various means. [Read more...]
Suppose you have to list all the tables of PostgreSQL database. You can achieve this by various means. [Read more...]
Amazon / AWS S3 is an object storage. You can imagine it as a cloud file system. This article shows you how you can download files from Amazon S3 to your local machine. [Read more...]
If you want to encrypt just a single file there exist various options under the Linux, macOS or Windows operating systems. This article shows some of these tools and how and if to use them. [Read more...]
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...]
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 debug the git submodules command. [Read more...]
Because the Windows 10 recovery partition is protected you can not delete it by using the graphical disk management tool which is part of Windows 10. Read on if you want to know how to accomplish this task. [Read more...]
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 delete remote and local branches. [Read more...]
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...]
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...]
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...]