Author: Gobinath Loganathan

The success of an open-source project highly depends on the contributions of the community. As a maintainer of a few open-source projects, I have seen the power of such contributions. On the other hand, there are people who like to contribute but couldn’t because of technical barriers. This tutorial walks you through how to create GitHub Pull Request in a beginner friendly way. Safe Eyes is one of my open-source projects available for Linux users to prevent asthenopia (eye strain) due to RSI. This tutorial shows you how to contribute to updating the French translation of this application by sending…

Presto lately renamed to TrinoDB is a distributed big data SQL engine initially developed by Facebook and later open-sourced and being led by the community. This article explains the internals of Presto SQL Join algorithms and how Presto executes join operations internally. Implementation of Joins Almost all database engines out there join only two tables at a time. Even if there are more than two tables to be joined in the SQL query, the database will join the first two tables and join the output with the third one and continue this for the remaining tables. Database engineers refer those…

There are hundreds of articles on how to install phpMyAdmin on Ubuntu. However, none of them showed me an error-free way of installing phpMyAdmin in my system. This article is for those who want to install phpMyAdmin and MySQL without any errors. phpMyAdmin depends on Apache Server, PHP, and MySQL. Therefore, I recommend installing them before installing phpMyAdmin. Install Apache Server Step 1:Execute the following command from the terminal, to install Apache Server. Step 2:Start the Apache server using the following command and visit http://localhost to see whether the Apache Server works. If you get “Apache2 Ubuntu Default Page”, your…

This tutorial shows you the way to add the latest MySQL JDBC driver to Eclipse. The same steps can be followed to add any other JDBC drivers to Eclipse. Step 1:Download and extract the platform-independent MySQL JDBC connector, from the official site. Step 2:Copy the mysql-connector-java-xxx-bin.jar file to any desired folder. Step 3:Go to the Window → Preferences in Eclipse. Step 4:Expand the Data Management → Connectivity → Driver Definitions and click on the Add button. Step 5:In the appeared New Driver Definition dialog, select MySQL in the vendor filter combo box and select the latest MySQL JDBC Driver from the…

Hibernate supports different logging implementations but SLF4J-based loggers are preferred over standalone loggers. This article explains how to disable the overwhelming amount of Hibernate logs in the terminal output. Let’s take the “JPA Hello World! using Hibernate and MySQL” project as an example. Add Logback Dependency To disable the logs generated by Hibernate, add the log back dependency to the pom.xml as shown below. Add Logback Configuration to Disable Hibernate Logs Create a new file named logback.xml in the src/main/resources folder with the following content. Save all the changes and run the project. This time, only the warning and error…

Java Persistence API (JPA) is a Java application programming interface specification that describes the management of relational data in applications using Java Standard Edition, and Java Enterprise Edition. Various frameworks like Hibernate, EclipseLink, and Apache OpenJPA provide object-relational mapping according to the JPA standards. This tutorial shows you to develop a simple Java Persistence API (JPA) Hello World project using Hibernate framework and MySQL database. Requirements Create Database and Table in MySQL For the hello world project, let’s create a database named “javahelps” and a table named “student” in MySQL. Create a New JPA Hello World Project Step 1:Create a new…

Scala is a JVM-based functional programming language widely used in data analytics. You can install Scala using the terminal and access it from the terminal. However, IDE support is inevitable these days. Therefore, this article explains how to set up Scala in IntelliJ IDEA and how to create a hello world Scala project in IntelliJ IDEA. Requirements Scala has a strict dependency on Java Development Kit. Please refer to the official Scala website for the required Java Development Kit for the latest Scala version or the Scala version you want to use. Then make sure that you have the required…

Jersey is a REST framework that provides JAX-RS Reference Implementation and more. Jersey provides its own APIs that extend the JAX-RS toolkit with additional features and utilities to further simplify RESTful service and client development. It also exposes numerous extension SPIs so that developers may extend Jersey to best suit their needs. This article introduces the newly released Jersey 3 with a hello world project. Requirements Create a New Hello World Project Step 1:Create a new Maven project in IntelliJ Idea with the group id: com.javahelps.helloworld and artifact id: jersey-hello-world. Step 2:Add the following dependency management and dependencies to the…

The recent article How to Run Apache NiFi on Docker? explains how to run Apache NiFi on Docker. Though it is applicable for traditional x86 or x64 architectures, it does not work for Mac M1 computers. As an alternative still you can run from binary files but Chris Sampson a NiFi committer provided a script to build a NiFi docker image that is compatible with Mac M1. This article explains, how to build an Apache NiFi docker image on your Mac Book M1 and how to run it. Create Apache NiFi Docker Image For Mac M1 Step 1:Create a shell…

Apache NiFi: the famous ETL tool to integrate different data endpoints together provides a friendly GUI to control data pipelines even for non-techy people. For anyone who wants to play with Apache NiFi, running Apache NiFi on Docker is an easy solution to get quick access. Running Apache NiFi on Docker is a simple and hassle-free process if you know the port to access. This article explains how to get Apache NiFi running in Docker on a Linux machine. If you are using Mac Silicon M1/M2, follow this article instead: How to Run Apache NiFi Docker on Mac M1? Spin…