Why You Need To Backup Your Postgres Database and How To Do It
This article will demonstrate why database backups are crucial and how to back up your PostgreSQL database using pg_dump and pg_dumpall.
A Guide to Transparent Data Encryption in PostgreSQL
Transparent Data Encryption, or TDE, is used to secure the data at rest. In other words, it encrypts the data in a database to prevent an attacker from reading the data if they break the first line of defense.
PostgreSQL Transactions and How To Use Them
Transactions come up often when dealing with PostgreSQL, and if you’re new to it, you may have many questions about what they are and how they work. You might also want to know how can we implement transactions, and what are the best tools to do so.
Should You Invent a New Query Language? (Probably Not)
There are too many different query languages out there and ORMs often don't help or even make things worse. Find out why and what can be done against it.