Enjoy the weekend with these great open-source SQL blog posts from around the web… At times, a few may be a bit dated, but worth the read, while others are relatively current… Share them along…
- Implementing the harmonic mean and geometric mean as user-defined aggregates in PostgreSQL
- 3 WAYS TO DETECT SLOW QUERIES IN POSTGRESQL
- TRANSACTIONAL DATA OPERATIONS IN POSTGRESQL USING COMMON TABLE EXPRESSIONS (Awesome post here! Be sure to read.)
- Simplifying Recursive SQL Queries
- What’s New in MariaDB 10.3
- MySQL Shell 8.0.12 – storing MySQL passwords securely
- Question about Semi-Synchronous Replication: the Answer with All the Details
- Foreign Data Wrappers in PostgreSQL and a closer look at postgres_fdw
- MySQL InnoDB Cluster 8.0.12 – avoid old reads on partitioned members
- PostgreSQL Accessing MySQL as a Data Source Using mysql_fdw
- Using Barman to Backup PostgreSQL – An Overview