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…
- PostgreSQL Streaming Replication vs Logical Replication
- Cost of a Join
- Fun with SQL: Common Table Expressions for more readable queries
- PostgreSQL – convert a user to a role
- An example of PostgreSQL rules: updating pg_settings
- Making MySQL Easier to Use – Our New Server Usability Guidelines
- How large can JSON Documents be?
- MySQL Shell: Using External Python Modules
- How to reset your `root` password on your MySQL server
- Replication from Percona Server for MySQL to PostgreSQL using pg_chameleon
- MySQL on Docker: How to Monitor MySQL Containers with Prometheus – Part 1 – Deployment on Standalone and Swarm
- Database Security Monitoring for MySQL and MariaDB
- ProxySQL Series : Percona Cluster/MariaDB Cluster (Galera) Read-write Split