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…
- CHAR: What is it good for?
- Parallel PostGIS and PgSQL 11
- Getting Started with PostgreSQL Streaming Replication
- SQL Performance Tuning Tutorial – MySQL Query Optimization Tips
- JSON_TABLE – The Best of Both Worlds
- Why Covering Indexes Are Incredibly Helpful
- Be careful with CTE in PostgreSQL
- CORRELATION OF POSTGRESQL COLUMNS EXPLAINED
- Use cases for followers (read replicas) in Postgres
- Cost of a Join
- Cost of a Join – Part 2: Enums, Wider Tables
- How To Use Procedures To Increase Security In MySQL