Weekly Reading for Week of 07/21/2018

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…



  • The Three-Valued Logic of SQL
  • RULES OR TRIGGERS TO LOG BULK UPDATES?
  • Using search_path and views to hide columns for reporting with Postgres
  • Integrating Tools to Manage PostgreSQL in Production
  • MySQL 8.0: Support for BLOBs in TempTable engine
  • MySQL Swapping With Fsync
  • Another Day, Another Data Leak
  • A PURE POSTGRESQL DOCUMENT DATABASE API
  • UNDERSTANDING MySQL CLIENT / SERVER PROTOCOL USING PYTHON AND WIRESHARK – PART 1
  • Advertisements

    Hacking SQL – Tools, Utilities, and Work flow.

    I recently got a great suggestion from a reader over on Medium about sharing my workflow tools when hacking on SQL (mainly PostgreSQL, but sometimes MySQL also), hence here we are in this blog post.

    (more…)