Home » Tag Archives: MySQL

Tag Archives: MySQL

Database Week at the AWS Loft

java-interview-questions-answers

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 »

MySQL Server Tutorial

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

Read More »

MySQL Workbench Tutorial

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

Read More »