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 Write a Multiplication Aggregate Function in SQL
- DRIVING INNOVATION WITH MYSQL 8.0 AND DOCKER
- Postgres multi-column unique index
- A history lesson on SQL joins (in Postgres)
- Fun with SQL: Unions in Postgres
- The “O” in ORDBMS: PostgreSQL Inheritance
- Per-Table Autovacuum Tuning
- Tuning Input/Output (I/O) Operations for PostgreSQL
- Prepared Statements for MySQL: PDO, MySQLi, and X DevAPI
- MySQL Explain Example – Explaining MySQL EXPLAIN using StackOverflow data
- How To Fix MySQL Replication After an Incompatible DDL Command
- Shutdown and Restart Statements
- MySQL and Memory: a love story (part 2)