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 Triggers and Stored Function Basics (One of two very special shares here)
- Self-Provisioning of User Accounts in PostgreSQL via Unprivileged Anonymous Access (Two of two very special shares here)
- Why MySQL Stored Procedures, Functions and Triggers Are Bad For Performance
- Galera Cluster Recovery 101 – A Deep Dive into Network Partitioning
- AUDIT LOGGING USING JSONB IN POSTGRES
- Why PostgreSQL is the Linux of Databases
- How SQL DISTINCT and ORDER BY are Related
- How to perform Schema Changes in MySQL & MariaDB in a Safe Way
- A Beginner’s Guide to the True Order of SQL Operations (Epic resource)
- Descending index in MySQL 8.0
- PostgreSQL Event Based Processing
- SQL and Business Logic