Tag: Database
-
Microservices Communications
Here is a list of the most used communictions protocols in microservices architecture. REST, a commonly used protocol, is simple and synchronous. SOAP uses XML and is often more verbose. RPC uses binary format, offering fast and compact communication. Messages or queues allow asynchronous communication, but require a message broker. Lastly, database communication uses a…
-
My Problems with Flyway
How I’ve created a framework to solve the most common problems with the Flyway migrations. I must first identify the problem from the log files. Then apply the solution depending on the problem. It can go from a simple changeset rollback to stop the production.
-
Stop Using Null on Database Rows
Stop Using Null on Database Rows. In this article I show why it’s a bad idea, what problem I’ve encountered and what is the solution I used.
-
The Hardest Bug I’ve Faced
In this article, I will describe some of the worst bugs that happen in an application. Let’s start by splitting them into two main categories: those which I can reproduce on my laptop, and those I can’t reproduce on my laptop.
-
PostgreSQL’s Deadlocks
Have you ever faced a database deadlocks in Postgres? In this article, I will tell a story about the deadlocks, A Journey Through PostgreSQL’s Conundrums.
-
Connect a Database to a Spring Boot Application
In this article, I will connect my Spring Boot Application to a PostgreSQL database. Adding the dependencies, configuring the application and creating the entities and repositories.
-
How to connect to a PostgreSQL database through a SSH tunnel
When working with a remote database, it’s infrequent to have it accessible through the Internet. When accessing a database of a project, I use to go through another machine, through a bastion host.
-
What You Should Know When Using Liquibase
A lot of years working now with Liquibase. It’s a powerful tool to integrate into every application which has a database connection. Still, there are some best practices to take into account if you don’t want Liquibase to be against you.
-
Feedback on AWS Proxy RDS with AWS Lambda
When I’ve decided to migrate the calculation process to AWS Lambda, I didn’t take into account the enormous CPU consumption on RDS this will lead. Still, there is a solution for that, the Proxy RDS.
-
How to Handle the Database Migrations with Alembic
In this video I will show how to use Alembic to Handle the database migrations. I show and explain the main commands of Alembic.