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…
- MySQL : InnoDB Transparent Tablespace Encryption
- Replication Monitoring with the Performance Schema
- Persistence of autoinc fixed in MySQL 8.0
- Some Tips on Using Arrays in PostgreSQL
- PostgreSQL: The Versatile INSERT
- POSTGRESQL: IMPROVING SORT PERFORMANCE
- Won’t You Be My Neighbor? Quickly Finding Who is Nearby
- How to update large tables in PostgreSQL
- ARE YOUR FOREIGN KEYS INDEXED?
- Instrumenting Read Only Transactions in InnoDB
- Managing Freezing in PostgreSQL
- Find the number of the longest continuously rising days for a stock
- PostgreSQL Tips: Documenting the Database
- MySQL 8: Performance Schema Digests Improvements
- Track PostgreSQL Row Changes Using Public/Private Key Signing
- Generating Identifiers – from AUTO_INCREMENT to Sequence
- Upgrading to PostgreSQL 11 with Logical Replication
- dentifying High Load Spots in MySQL Using Slow Query Log and pt-query-digest
- PostgreSQL locking, Part 1: Row Locks
- IDEAS FOR SCALING POSTGRESQL TO MULTI-TERABYTE AND BEYOND
- Export to JSON from MySQL All Ready for MongoDB
- One Billion Tables in MySQL 8.0 with ZFS
- MySQL on Docker: Running ProxySQL as a Helper Container on Kubernetes
- Commenting your Postgres database