Tag: Database
-
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.
-
Optimizing Joins with CTE
This week, I faced a problem with the performance of a query in PostgreSQL. I came from a cardinality result of more than 70.000.000 rows with a time response of 3 minutes to only 10 seconds.
-
MongoDB with Spring Data
In this article I show how connect a Spring Boot application with MongoDB. I will show how to configure a Spring Boot application to be connected to a single noSQL database as MongoDB. And I will show how to use Spring Data to request a MongoDB database.
-
SQLAlchemy
In this article I show how to configure SQLAlchemy in a Flask backend. I also show how to create entities which reflect some tables in a database. And show how some relationships are managed with SQLAlchemy as one-to-one, one-to-many and many-to-many.
-
Liquibase on Maven with SQL files
In this article, I show the usage of Liquibase to manage the database migrations with SQL files. I also show how to configure Liquibase on Maven.
-
Spring JPA and database connection with Spring Boot
In this article, I show the Spring JPA configuration for the database connection with Spring Boot, and the entities and Spring Repositories creation to read the data.
The Dev World - Sergio Lema 