Dec 21, 2022 · Databases

Master MySQL: 14 Essential Functions & Commands Every Developer Should Know

This guide walks through fourteen practical MySQL techniques—from aggregating rows with group_concat and measuring string length with char_length, to locating substrings, replacing text, retrieving timestamps, bulk inserting, handling duplicates, using pessimistic locks, inspecting tables, explaining queries, monitoring processes, and exporting data with mysqldump.

MySQLQuery OptimizationSQL Functions

0 likes · 13 min read

Master MySQL: 14 Essential Functions & Commands Every Developer Should Know

Hacker Afternoon Tea

Mar 31, 2022 · Databases

Manual Query Propagation in Citus Distributed PostgreSQL Clusters

The article explains how Citus lets you manually propagate SQL statements to workers, shards, or placements using functions like run_command_on_workers, run_command_on_shards, and run_command_on_placements, provides concrete examples, and outlines important limitations and safety considerations.

CitusManual Query PropagationPostgreSQL

0 likes · 7 min read

Manual Query Propagation in Citus Distributed PostgreSQL Clusters