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…
- Understanding Check Constraints in PostgreSQL (One here from yours truly)
- 4 Things You Should Stop Doing in SQL and Start Doing in Python
- Don’t LOCK tables. Just don’t.
- 10 Easy Steps to a Complete Understanding of SQL (A great read!)
- PostgreSQL: why and how WAL bloats
- WHAT HOT_STANDBY_FEEDBACK IN POSTGRESQL REALLY DOES
- An Overview of Volume Level Replication for PostgreSQL Using DRBD
- Setting up Streaming Replication in PostgreSQL
- Manipulating queries with non-conforming data via MySQL Query Rewrite Plugin, triggers and stored procedures
- Using ProxySQL to connect to IPv6-only databases over IPv4
- Multi-master with MariaDB 10 – a tutorial
- Transaction Isolation in PostgreSQL
- The Easy Way to Deploy MySQL Replication and ProxySQL with Automatic Failover
- PostgreSQL 11 and Just In Time Compilation of Queries