In-memory databases
Sometimes in programming need to hold many objects and classes into memory, however, this will cause shortage of heap memory or memory leakage eventually. In order to avoid this bad […]
Coding, Tech & Linux
Meta category for database related articles.
Sometimes in programming need to hold many objects and classes into memory, however, this will cause shortage of heap memory or memory leakage eventually. In order to avoid this bad […]
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 […]
In PostgreSQL 9.1 and later database replication feature is provided built in. This feature allows you to have high up time and very low risk of data lose. It is […]
Recently, I have faced with the situation that I had to update one column value with the combination of two strings (one is another column string and the other one […]
In this post I discuss about how to connect to remote Postgresql database with SSH tunneling. Basically, with SSH you are capable to do almost whatever that you can do […]