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 Binary Logs (and Filesystems) Affect MySQL Performance
- The (potential) greatest thing in GIS just happened.
- How to MySQL- Getting started
- MySQL Query Optimisation for Database Developers | Lucideus Research
- PostgreSQL Data Types: XML
- A high level overview of SQL Joins
- Getting out of MySQL Character Set Hell
- Change Data Capture(CDC) in PostgreSQL
- Postgres SQL Injection Cheat Sheet
- Don’t be hard-headed… Harden your PostgreSQL database to ensure security
- How to Secure your PostgreSQL Database – 10 Tips
- TECH PREVIEW: POSTGRESQL 11 – CREATE PROCEDURE (I’m excited about this feature)
- Adding Custom Delimiters to a String with Regex, PostgreSQL and PL/pgSQL
- Invisible Indexes – MySQL 8.0
- Keep Sensitive Data Secure in a Replication Setup