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…
- SELECT DISTINCT ON in PostgreSQL
- Why do we install as root?
- Archive MySQL Data In Chunks Using Stored Procedure
- MySQL Backup-Restore and PERSIST file handling
- The Importance of mysqlbinlog –version
- MySQL : InnoDB Transparent Tablespace Encryption
- Setting up MySQL Group Replication with MySQL Docker images
- Master-Slave Replication with MySQL 8.0 in 2 mins
- How to Transfer All MySQL Databases From Old to New Server
- Moving Tablespaces
- MySQL Adventures: How max_prepared_stmt_count can bring down production
- Sharding writes with MySQL and increment offsets