Articles tagged with "databases"

• SQLIte database file format diagrams

  09 Nov 2022

• Modern approaches to replacing accumulation user-defined variable hacks, via MySQL 8.0 Window functions and CTEs

  06 Jun 2020

• Storage and Indexed access of denormalized columns (arrays) on MySQL 8.0, via multi-valued indexes

  16 Mar 2020

• An introduction to Functional indexes in MySQL 8.0, and their gotchas

  10 Mar 2020

• Generating sequences/ranges, via MySQL 8.0's Common Table Expressions (CTEs)

  09 Mar 2020

• PreFOSDEM talk: Upgrading from MySQL 5.7 to MySQL 8.0

  23 Feb 2020

• Summary of trailing spaces handling in MySQL, with version 8.0 upgrade considerations

  09 Jul 2019

• Publicly available SQL (ISO/IEC 9075) and JPEG 2000 Core coding system (ISO/IEC 15444-1) documents

  09 Jul 2019

• An in depth DBA's guide to migrating a MySQL database from the `utf8` to the `utf8mb4` charset

  25 Mar 2019

• Dropping a database column in production without waiting time and/or schema-aware code, on a MySQL/Rails setup

  12 Feb 2019

• Quickly setting up PostgreSQL for running without admin permissions

  15 Feb 2018

• Impact of ENUM data type on MySQL data storage

  17 Aug 2017

• Data storage analysis and optimization of (MySQL) InnoDB indexes

  01 Aug 2017