View all tables row count in PostgreSQL

This script will make your life easier to view the total row on all your tables, you need to create a function for it, but its quite easy to maintain

I start learning about Tizen

its been a while since I learn something new, last year is all about big data technology, Spark, Hadoop, jupyter notebook, etc.. so this year I decide to learn something new from the client side development area.
Tizen seems to be an interesting topic to learn about, so I'm going to start blogging about it while learning at the same time.

Running GSUtil 4.19 on Python 2.7 on Centos 6.6

This post is a reminder of how to install and  run gsutil on Centos 6.6 running python 2.7

C++ Input and Output

Since I have a thing about competitive programming like HackerRank and TopCoder, I decide to start blog about it while learning C++ again after 8 years not using it.
I wont explain much unless needed, since the code explains itself
The first one is pretty simple, it starts with input and output

Copy File using SSH in Ubuntu 16.04

its just my note on how to copy files between VM, this command can only works when ssh service is already set and running

Find Active Session and Kill it on PostgreSQL

I happen to encounter a case when I want to drop a database and not allowed by system since there are an active session. I ended up having to restart database and the perform the drop. this is not ideal if there are more than 2 database or its already run on production, but here's how to do it

Restore PostgreSQL Database

Without having to use tools like pgAdmin, you can backup and restore database using console command