Let's load dataset into postgres. Run postgres docker container 1docker run -d --name postgres-shared-buff-default -e POSTGRES_PASSWORD=ungabunga postgres If you use tools like pgadmin, please follow this link to import csv data into database. Let's see how many rows we have using count query. 1select count(id) from …

Read More

Introduction Address WebApi and test example to display Country, State and City Prerequisite Java SDK node.js Building Backend 1https://gitlab.com/address-api/api-server.git Create Database in mysql create database address_api_db; Export Env variable 1MYSQL_HOST=localhost 2MYSQL_PORT=3306 …

Read More

Introduction How to create row hash for columns from multiple table in sql. There exists a lot of excryption and compression function in mysql https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html. We shall use https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html#function_md5 in this example. …

Read More