Home » MySQL

Tag Archives: MySQL

Real World Use Cases of MongoDB and MySQL

Ever since the start of the digital revolution, we have witnessed the utmost requirement of storing data effectively and efficiently. Data is the lifeblood of business solutions and having an accurate database management system (DBMS) is a crucial tool for handling such large volumes of data.  Each database management system offers specific solutions as per business requirements, and decision-makers are ...

Read More »

Spring Boot tests with Testcontainers and PostgreSQL, MySQL or MariaDB

Testcontainers is a Java library that allows integrating Docker containers in JUnit tests with ease. In a Containerized World, there is little sense to complicate the tests configuration with embedded databases and services. Instead, use run your services in Docker and let the Testcontainers manage this for you. In this blog post you will learn how to configure Testcontainers to ...

Read More »

Database Week at the AWS Loft


Here are my notes: https://databaseweekoctober2019sf.splashthat.com Databases on AWS: The Right Tool for the Right Job I’m not taking super deep notes for many of these talks. I’m focusing on the highlights. PostgreSQL came after MySQL. 8 categories of DBs on AWS: RelationalKey valueDocumentIn-memoryGraphSearchTime seriesLedger Search for: AWS Database Services For relational, they have Amazon Aurora. It’s compatible with MySQL and ...

Read More »

Ultra-Low Latency Querying with Java Streams and In-JVM-Memory

Fundamental rules of nature, such as the speed of light and general information theory, set significant limits on the maximum performance we can obtain from traditional system architectures. Learn how you, as a Java developer, can improve performance by orders of magnitude using in-JVM-technology and Java Streams. If, for example, the application server and the database server are located 100 ...

Read More »

MySQL Stored Procedure Tutorial

1. Introduction In an enterprise level application, there is always a need to perform certain specific set of tasks on the database on a regular basis like database cleanup, processing payroll, creating a new entity with several default entries and lots more. Such a task could involve execution of multiple queries for each task. This process could be eased if ...

Read More »

MySQL Replication Tutorial

1. Introduction to MySQL replication In a large scale enterprise system, data consistency and backup is of prime importance. It is equally important to distribute the load on the database server using copies of the database. However, maintaining backup or additional instances is a difficult task especially when you try to copy entire database repeatedly. MySQL replication helps us precisely ...

Read More »

Exact Matching of a String Containing a Wild Card in QueryDSL

On one of our recent projects, our client asked for a single search field that would be able to search on first name, last name and email address, with the only wildcard being an asterix ‘*’ for partial matches. Sounds simple, but it threw us for a little loop. In our project, we used QueryDSL in combination with JPA and ...

Read More »

MySQL Command Line Tutorial

1. Introduction to MySQL In my previous tutorial, I discussed about installation of MySQL server and getting started with the use of MySQL database. In this article we would be discussing in detail about using the MySQL command line to perform various operations like select, insert, update, delete, database administration, authorization management and several other operations necessary while using MySQL ...

Read More »