Tag: Database
-
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.