Geeky HackerA category for PostgreSQL related articles.
Running tests against a real database provides more confidence in comparison to an in-memory database such as H2. For that, the Testcontainers library is a wise choice as it provides an out-of-the-box solution to write and run integration tests against an actual database of your choice running in a Docker container. In this tutorial, we […]
If you are accessing to PostgreSQL database using programming language, sometimes, you may get exception such as fatal sorry too many clients already or more precisely the following exception in Java. org.postgresql.util.psqlexception fatal sorry too many clients already The reason for such an error is due to the fact that your program perhaps made too […]
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, logs and other stuff. The first thing that I would like to demonstrate is PostgreSQL log file. Basically live PostgreSQL log file is a very […]
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 table A, consequentially a new row will be added to table B with some information that comes from table A. This process also is applicable […]
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 it is also open source software. In this post I demonstrate some basic commands of PostgreSQL for beginners. The first thing you need to know […]
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 also useful for data mirroring and have high usage for load balancing (For example, very useful in designing banking system). To know more please refer […]
The unbeatable, the father and the king of kings, Bitcoin!
Geeky Hacker wallet number: 1NaGzvbXQtM9PCduXgmFeXe8D4i5C1nDyu
BAT is a coin that is used by Brave Browser which is getting more popularity day by day.
Geeky Hacker wallet number: 0x40146D985b995E5bB5b2A7FDc618db689a811DCB
Yet another cryptocurrency that is super popular. You can donate us in Ethereum.
Geeky Hacker wallet number: 0x1f98767fB7c51efc35C313B0015C6aB453D4ED31