MySQL

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

    Weekly Reading – Week of 07/14/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…


  • Upgrading to MySQL 8.0 with Spatial Data
  • Detecting Incompatible Use of Spatial Functions before Upgrading to MySQL 8.0
  • Should Red Hat Buy or Build a Database?
  • Fixing ER_MASTER_HAS_PURGED_REQUIRED_GTIDS when pointing a slave to a different master
  • A Nice Feature in MariaDB 10.3: no InnoDB Buffer Pool in Core Dumps
  • MySQL 8.0 Hot Rows with NOWAIT and SKIP LOCKED
  • Understanding Window Functions
  • NULL in SQL: Indicating the Absence of Data (Great blog post here!)
  • NULL-Aware Comparison: is [not] distinct from

    • Utilize parameters with MySQL Stored Procedure by examples.

    MySQL Stored Procedures and Functions enable database devs the ability to wrap useful bits of code in a nice little ‘package’ for reuse. In this blog post, I will provide a simple example to get you started on incorporating stored procedures into your own daily work flow.
    Note: All data, names or naming found within the database presented in this post, are strictly used for practice, learning, instruction, and testing purposes. It by no means depicts actual data belonging to or being used by any party or organization.

    (more…)

    Weekly Reading For Week of 07-07-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…


  • PostgreSQL Features You May Not Have Tried But Should
  • How to do histograms in PostgreSQL
  • Scaling past the single machine
  • Is Serverless Just a New Word for Cloud Based?
  • Back to basics: Isolation Levels In MySQL
  • How Oracle’s Acquisition Was Actually the Best Thing to Happen to MySQL
  • PostgreSQL Concurrency: Data Modification Language
  • Top 10 reasons for NoSQL with MySQL
  • Fun with SQL: Functions in Postgres
  • Planning queries involving foreign PostgreSQL tables
  • A Performance Cheat Sheet for PostgreSQL
  • The connection_control plugin : Keeping brute force attack in check
  • SELECT HELLO WORLD FROMDUAL WITH MARIADB PL/SQL
  • A Billion Taxi Rides in PostgreSQL