Author: Osman DİNÇ
-
How to configure HAProxy with external-check to query PostgreSQL database directly
The blog post discusses configuring HAProxy with an external check to query PostgreSQL directly for database server health monitoring. Choosing to deploy PgBouncer on database hosts led to the decision to use an external check in HAProxy. The configuration and benefits of this setup are detailed, along with sample HAProxy configurations for external checks. Deploying PgBouncer directly on PostgreSQL servers minimized network latency and simplified architecture while securing local connections.
-
Oracle Database 23ai Fuzzy Matching and Similarity Searches
This content provides a tutorial on performing similarity searches in Oracle 11g+ databases using various algorithms like Jaro-Winkler and Levenshtein by using ULT_MATCH package. It also introduces the FUZZY_MATCH package in Oracle 23ai release, allowing for greater flexibility and alignment with developer needs. The post includes sample SQL queries for implementing these algorithms and a referral to the Oracle 23ai SQL Language Reference for more information.
-
Unified Audit Trail: SQL Text Not Recorded in Syslog
The Oracle Database 12.2 or later uses Unified Auditing to track activity. However, certain fields are not captured in the syslog of Unified Audit Trail, impacting the completeness of log data. To address this, a simple method of sharing audit records with SIEM tools like WAZUH involves using SQL/JSON functions to stream data in NDJSON format. This can be done using a shell script scheduled with cron.
-
Fuzzy Matching in PostgreSQL: A Guide to pg_trgm extension
PostgreSQL’s pg_trgm extension facilitates efficient similarity searches using trigram matching, breaking text into trigrams for pattern matching and enabling the use of distance operators. It supports fuzzy matching and indexing for speedier searches, allowing for functions like similarity() and operator usage.
-
How to Remove Orphan Large Objects in PostgreSQL
To manage Binary Large Objects (BLOBS) in PostgreSQL, use the lo_unlink() function to remove them properly. Failing to do so can leave orphaned records, but vacuumlo can help clean them up.
-
Comparing Oracle Users’ Decrypted Passwords with RockYou2024
The “RockYou2024” password leak contains 9,948,575,739 unique plaintext passwords, making it valuable for cybercriminals aiming to perform brute-force attacks. Ensuring the security of Oracle databases is crucial, as weak passwords pose a significant vulnerability. To mitigate this risk, it is recommended to compare database passwords against the 1 million most common ones. A provided SQL script guides this process and demonstrates how to perform the comparison.
Osman’s DBlog 