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

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...