it's not about being the best it's about being better than yesterday
In the vast landscape of database management, MySQL’s binary log emerges as a silent guardian, recording the ebbs and flows of data modifications within the server. This indispensable component plays a pivotal role in tasks ranging from data replication to point-in-time recovery. In this exploration, we embark on a journey into the intricacies of MySQL…
Micronaut, a powerful and lightweight framework, provides an excellent platform for building microservices. In this blog, we’ll explore the seamless integration of MySQL, a popular relational database, into a Micronaut application. This integration ensures data persistence with efficiency and simplicity. Prerequisites Before connecting to a database in Micronaut, make sure you have the following prerequisites:…
One of the common problem that we may face during joining multiple tables in a SQL is we want only one row across the entire tables even if we have duplicate records. Consider the following tables In a given scenario, we have customers, invoices and items table. Now we want to list down a summary…
Over the years, there were many competing approaches to data storage and querying. The oldest and best-known database is a relational database, where the data is organized into relations called a table. To overcome the drawbacks of Relational Database like scalability, a document model database is introduced the term NoSql got famous. The term NoSQL…