A wise man said: “If you want to go to the backend, the database is a part that cannot be ignored.” Well, Let’s talk about optimizing database performance on my blog, connection pooling should be the suitable first candidate. So what is connection pooling? How to use the connection pool? Just take a cup of…
I have been working as a software developer for 4 years, actually, I worked with .NET most of the time, but I primarily worked with Microsoft .NET technology. Last year, I decided to switch to Go because of its performance and simplicity, and because of this reason, many big products and startups choose to use…
ID is important! ID is so important! I have to mention it twice, as the word, IDs play a crucial role in uniquely identifying records in a database. An ID must be unique in the system, and there are many strategies to generate a unique ID, but not all of them are good for the…
Go Generics I’ve been working on some Go projects lately, and I gotta say – there’s been a lot of duplicated code going on. It’s weird, because I’ve never seen so much of it in my previous projects. It’s like the more I work with Go, the more I realize that some of its built-in…
Go is a popular programming language used for developing fast and efficient applications. When programming with Go, some frequently asked questions arise, just as they do with any other language. In this article, we will go over four of the most common Go programming questions. How to Check if a Map Contains a Key in…
In this tutorial, you will learn about PostgreSQL recursive queries that use recursive common table expressions (CTEs) to generate the depth of a hierarchy. Introduction to the PostgreSQL Recursive Query PostgreSQL includes the WITH statement, which allows you to create auxiliary statements for use in queries. These statements are frequently referred to as common table…
Working with Git is very necessary, but sometimes, a bunch of branches were created during our work, and we want to delete them all. And a popular question is: how to delete all local Git branches except for the master branch. Delete a Git branch wont delete the associated commits or data. You just remove…
JWT (JSON Web Token) and OAuth are two forms of authentication that are used to verify a user’s identity in different ways. Both have key advantages and limitations, and knowing the differences between them is important when making a decision about which authentication method to use for your application. Short answer TL;DR If you have very…
When creating a SQL database, one of the most important elements to consider is its acid properties. Acid stands for Atomicity, Consistency, Isolation, and Durability. These four properties help ensure that any data stored in the database is safe and will remain consistent no matter what changes occur.
Vscode is a perfect editor for programming. In the previous post, I show you how to install vscode on your machine. But with Java developers or newbies of the Java programming world, Java debugging in vscode is a big question. Let me show you how to do it. Install Java SDK You can find and…
Recently, I got a new task to implement a new API in our Go microservice to save the telemetry data (event data) into the new MongoDB instance. The problem I realized that the payload of the events does not have a specific schema. Excludes some properties like userId, IP address, and event name, they have…
