Export MySQL query results as JSON
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. […]
Coding, Tech & Linux
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. […]
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 […]
Previously I wrote some posts about PostgreSQL such as basic commands, trigger, replications, etc. In this post I will go one more level more and start playing with config files, […]
Triggers in DB provides a facility to set triggers on certain tables for performing events (insert, delete, update) in another table. For instance, I want if any entry added to […]
This is an old school debate, actually some people believe GUID is better some have opposite idea. However, each has its own pros and cons which I have listed as […]
PostgreSQL (AKA postgres) is the one of the well-known relational database. It is pretty capable of doing everything such as storing JSON object, DB replication and so on. Beside that […]