For businesses handling personal data, the security of their database is a serious matter. Faced with an increasing number of attacks, organizations must improve their security and compliance policies, enhance...
PostgreSQL 13 introduces two useful features to enhance automated validation of physical backups: backup manifests and a new tool called pg_verifybackup. In this short article I attempt to provide an...
K-nearest neighbor is a proximity algorithm to find data in order of distance. Typically, this data cannot be indexed in advance, as both the centroid and the data can be...
Partitioning is one of the coolest features in the latest PostgreSQL versions. PostgreSQL 10 introduced native partitioning and more recent versions have continued to improve upon this feature. This article...
This article gives a step by step guide to utilizing Machine Learning capabilities with 2UDA. In this article, we will use examples of Animals to predict whether they are Mammals...
We find ourselves at the third article in the Oracle migration series. This time, we look at those strange operators that modify the WHERE clause criteria in Oracle (+). Like...
Handling dates, time, and time zones is a very complex matter and gets even more complicated when you implement them into databases. PostgreSQL is well equipped to handle such complexities...
Let’s say you want to implement a password authentication method in a client/server protocol. How would you do that and what would be the possible problems? The following is the...
Discover how BDR and Kubernetes allow you to reach very high uptimes in a year for a database solution thanks to the fast failover capability. Watch the demo! In my...
PostgreSQL is a hyperconverged DBMS offering functionalities that otherwise require specialized database technology. Developing a Graph Database is one such use case. To explore Graph Databases in more detail, 2ndQuadrant...
![Security and Compliance with PostgreSQL [Webinar]](/sites/default/files/styles/blog_image/public/blog_posts_images/13724-Webinar-Youtube-Template-Thumbnail-Security-Compliance.png?h=2dba036e&itok=3MQmeZe- "Security and Compliance with PostgreSQL [Webinar]")
