MySQL table to JSON with 10 lines of Spark
Apache Spark is the de facto framework of the big data world. Any serious organization that’s dealing with big data uses Spark almost exclusively. Though, it has some caveats. For […]
Coding, Tech & Linux
Apache Spark is the de facto framework of the big data world. Any serious organization that’s dealing with big data uses Spark almost exclusively. Though, it has some caveats. For […]
In the last article, we created User RESTful APIs using Express.js. But for the persistence, we didn’t code anything. We just mocked the data since we had no database connection. […]
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 […]
ActiveJDBC is a Java library implements Active record design pattern. It was inspired by ActiveRecord ORM from Ruby on Rails. ActiveJDBC can be used as an alternative to Hibernate in […]
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, […]
MySQL Workbench is a useful visualization tool for database architects, which provides similar features to PostgreSQL pgAdmin. Even though, that I am not a big fan of MySQL (I am […]