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 »Home »
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 »SQL Interview Questions and Answers – The ULTIMATE List
This is a summary of numerous important questions that have the potential to be asked in an SQL related job interview. There is no need to worry for your next interview test, because Java Code Geeks are here for you! The majority of the things you may be asked is collected in the list below. You can also check this ...
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 »