Tag Archives: MySQL

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. The term SQL basically connects ...

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

1. Introduction to MySQL Server MySQL is an open source relational database management system developed by a Swedish company in 1995. MySQL being an open source system, it has been used by numerous famous companies like Facebook, Google, Twitter, Flickr as well as Youtube. MySQL server is also a central component in LAMP, an open source web application framework. MySQL ...

1. About MySQL Workbench MySQL Workbench, as the name indicates, is a desktop tool to manage MySQL database servers and the databases too. MySQL Workbench comes integrated with a whole bunch of tools to help make the task of working with the database easier. It is mainly a visual database design tool that integrates variety of facilities as listed below: ...

In this article, I will show you how to connect a MySQL database with your Spring Boot application. Tools used in this article include: Spring Boot 1.5.6 Release MySQL 5.7.X Maven Java 8 Spring Data JPA 1 – Project Structure The project structure is a typical Maven structure. 2 – Project Dependencies Please note that the parent needs to declared. ...