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…
- Page Checksum Protection in PostgreSQL
- How ServiceNow deploys MariaDB to handle 25 billion queries per hour
- A Guide to Pgpool for PostgreSQL – Part One
- A Guide to Pgpool for PostgreSQL – Part Two
- A Guide to PGpool Part Three – Hints & Observations
- Using PostgreSQL Foreign Data Wrapper to Keep Track of Files
- Installing MySQL 8.0 on Ubuntu 16.04 LTS in Five Minutes
- PostgreSQL: Can’t update a table without finishing execution of function
- PostgreSQL: VACUUM VERBOSE to find data pages and dead row versions
- PostgreSQL: Use RAISE Statements to debug your Query and Function performance
- Fun with SQL: Recursive CTEs in Postgres
- PostgreSQL: Replace String data in all the Columns of a Table
- Planes, Trains, and Automobiles: MySQL XA Transactions