Aymane is a Software Engineer at Skypay mainly focused on the Java ecosystem. He became passionate about new technologies at an early age, he is always eager to learn more and share knowledge with others.
Database migrations often require dealing with multiple interdependent scripts, Manually executing these scripts across databases deployed on various environments with diverging states can lead to situations like running scripts out of order or re-executing the same scripts multiple times against the same database.
Database migration management tools such as Flyway, Liquibase, Alembic, or Phinx are gaining in popularity in the software development world. Unlike the significant effort and ad-hoc modifications required for a manual migration, these tools offer a structured and automated strategy for keeping database in sync with the latest changes, and help promote confidence among developers.
In this session, we will cover the fundamental concepts of database migrations, the challenges associated with manual execution of migrations, and how modern tools can streamline this process during both the development and release phases.
Database management systems are increasingly confronted with handling multiple transactions running concurrently, while this capability can boost performance, it also brings serious challenges to the table especially when it comes to maintaining data integrity and consistency.
Having a good understanding of the various issues that might arise when running concurrent transactions is essential for selecting the right database engine and the isolation level that best suits your needs.
In this session, we will cover what lies behind each particular concurrency phenomenon, how it can affect data integrity, then we will examine how database engines control concurrency through the implementations of the different isolation levels.
Searching for speaker images...