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…
- How to Overcome Accidental Data Deletion in MySQL & MariaDB
- Causes and Workarounds for Slave Performance Too Slow with Row-Based Events
- Playing with PostgreSQL and Pgpool
- Bobby Tables: A guide to preventing SQL injection
- Helping to Secure your PostgreSQL Database
- PostgreSQL’s fsync() surprise
- Adding a column via ALTER TABLE ADD COLUMN
- PostgreSQL Data Types: Ranges
- Postgres as the Substructure for IoT and the Next Wave of Computing
- Using Hints to Analyze Queries
- PG Phriday: Securing PgBouncer
- How to do Point-in-Time Recovery of MySQL & MariaDB Data using ClusterControl (Really good one here)
- PostgreSQL Data Types: Network Addresses
- How to Backup MySQL Databases Automatically on Ubuntu 17.10