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 Persist Global Variables Without Using Option Files in MySQL 8.0
- Backup and Restore a PostgreSQL Cluster With Multiple Tablespaces Using pg_basebackup
- A POSTGRESQL STORY ABOUT “NULL IS NULL = NULL AND NOT NULL”
- Why You Should Avoid Using “CREATE TABLE AS SELECT” Statement
- PostgreSQL Replication for Disaster Recovery
- An Overview of Just-in-Time Compilation (JIT) for PostgreSQL
- What is MariaDB TX? How to Manage the New MariaDB MySQL Fork!
- SQLite vs. MySQL vs. PostgreSQL: A Comparison of Relational Databases
- Common Table Expression (CTE) MySQL 8.0.
- MySQL 8.0 and keywords
- ProxySQL Series : Query Cache with ProxySQL
- Understanding MySQL X (All Flavors)
- PostgreSQL B-Tree Index Explained – PART 1