Popular Articles
Implementing Data Privacy and Row-Level Security Policy in MariaDB
To implement row-level security, you need two things: Some way to label the data. This might be the name of the owner of the data, or a classification level (CONFIDENTIAL, SECRET, TOP SECRET), or it might be something else entirely. ...
Tables size in ClickHouse
We can check the size of ClickHouse tables with this query: SELECT concat(database, '.', table) AS table, formatReadableSize(sum(bytes)) AS size, sum(bytes) AS bytes_size, sum(rows) AS rows, max(modification_time) AS ...
Enabling Binary Logging for MySQL
You must enable binary logging in order to perform transaction log backup. This is done in the MySQL configuration file. On the computer where the MySQL server is installed, navigate to the location of the MySQL configuration file. For example: ...
PostgreSQL Wait Statistics Baseline Analysis
Conducting a baseline analysis of wait statistics in PostgreSQL is a critical step in understanding the normal performance characteristics of your database. This process involves collecting and analyzing data on various wait events over a period of ...
Configuring SSL Encryption for PostgreSQL Server and Client Connections
Configuring PostgreSQL to use SSL involves setting up certificates on the server, configuring PostgreSQL to use these certificates, and then configuring the client to connect securely. This ensures that data transmitted between the PostgreSQL server ...