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

    MySQL Stored Procedures: Create functions with error handling for repetitive tasks.

    A previous blog post I wrote, INSERT with SELECT statement for columns with FOREIGN KEY constraint in MySQL with examples, we visited using INSERT with SELECT syntax adding records to one table, honoring FOREIGN KEY constraints in another. Constantly retyping that SELECT for each INSERT can be automated by ‘wrapping’ it up a function and that will be the focus for this blog post.

    (more…)

    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…)

    Exploring subqueries in PostgreSQL – Column names and expressions.

    There is an old saying that there is more than one way to skin a cat. Fear not, I won’t be skinning any, but that saying applies for many queries within PostgreSQL (and SQL in general). While the structure of some queries are ideal for execution, speed, and performance others are useful for analysis, exploration, and reporting. In this blog post, I’ll explore using subqueries to generate SELECT statement columns.

    (more…)