Geeky HackerA category for MySQL related articles.
When it comes to writing database integration tests with Spring Boot, there are two options: an in-memory database or Testcontaienrs. As we already covered Testing Spring Data Repositories with H2 in-memory database, we shift the gear in this article and focus on writing Spring Boot MySQL integration tests with Testcontainers. Introduction Although utilizing an in-memory […]
To inspect MySQL query execution, one can enable query logging and pipe the output to a file or table to gain insights about running queries. In this article, we cover how to enable MySQL querying logging and save queries to a file. When using an ORM framework, developers often want to know what’s happening behind […]
In one of the latest post, I discussed how to transform a large MySQL table to JSON using Apache Spark. Well, that approach works for any tables with any volume. But it’s an overkill for simple and small tables. The good news is MySQL by default has a feature for that. In this article, I […]
As you may know, MySQL does not support INTERSECT operation. Hence, to get the intersection between two result sets in the same table, we need to use self-join. In this tutorial, I cover the emulating intersection in MySQL with self-join. But what the heck is self-join? Essentially, self-join is a simple join where both sides […]
Batch insertion is essential when it comes to large data sets batch operations. It significantly reduces the database round trips and boosts the operation performance. Hence, it facilitates scaling the application with good performance. In this post, we will discuss how to do MySQL batch insertion with Spring Data JPA. Introduction Spring Data JPA uses […]
In this post, I explain about how to enable MySQL query logging for all queries. To enable query logging, historically you needed to edit my.cnf file under /etc/mysql path. However, the path and the file name is not valid anymore. In the newer versions, you need to edit mysqld.cnf that is located at /etc/mysql/mysql.conf.d. To […]
The unbeatable, the father and the king of kings, Bitcoin!
Geeky Hacker wallet number: 1NaGzvbXQtM9PCduXgmFeXe8D4i5C1nDyu
BAT is a coin that is used by Brave Browser which is getting more popularity day by day.
Geeky Hacker wallet number: 0x40146D985b995E5bB5b2A7FDc618db689a811DCB
Yet another cryptocurrency that is super popular. You can donate us in Ethereum.
Geeky Hacker wallet number: 0x1f98767fB7c51efc35C313B0015C6aB453D4ED31