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 locking, part 2: heavyweight locks
- A Poor Man’s Column Oriented Database in PostgreSQL
- How to Set up a Password as a Default User in PostgreSQL
- It’s just an expression
- The Biggest Mistake Postgres Ever Made
- PostgreSQL locking, part 3: lightweight locks
- MySQL on Docker: Running ProxySQL as Kubernetes Service
- SQL Firewalling Made Easy with ClusterControl & ProxySQL
- How to Create a Single Endpoint for your PostgreSQL Replication setup using HAProxy
- MySQL Shell 8.0.13 Prompt: Now with New Line Support
- GH-OST for MySQL Schema Change.
- On the consequences of sync_binlog != 1 (part #1)
- Remember your history
- Materialized views vs. Rollup tables in Postgres
- Temporary tables are now allowed in transactions when GTIDs are enabled
- OmniDB debugger for PostgreSQL 11
- PostgreSQL: Efficient Queries – Indexing
- Migrating from MSSQL to PostgreSQL – What You Should Know
- KILLED INDEX TUPLES