5 Data

Every entry filed under Data and its subtopics.

8 entries match these filters

0076 jq recipes: 23 one-liners for JSON on the command line A runnable collection of jq filters for everyday JSON work: pick fields, filter with select, reshape, sort, count, group, pass shell variables,… Intermediate · Reference · Linux, macOS, Windows Script Command-line tools · jq & JSON on the command line 15 Oct 2026
0077 SQL cheat sheet: a runnable reference for everyday queries One SQL file that builds a tiny database and demonstrates filtering, sorting, grouping, joins, CASE, CTEs, window functions, safe updates and indexes.… Beginner · Reference · Any system Script Joins · Queries 15 Oct 2026
0199 psql meta-commands cheat sheet The backslash commands you use every day in psql: connecting, listing databases, tables and roles, describing objects, timing queries, expanded output and… Beginner · Reference · Any system Article Install & connect · Roles & administration 15 Oct 2026
0207 Find long-running PostgreSQL queries and slow statements A psql-based script that lists sessions whose current query or open transaction is older than a threshold, plus pg_stat_statements queries to find… Intermediate · Reference · Linux Script Performance & tuning · Roles & administration 15 Oct 2026
0215 mysql command-line client cheat sheet The connection options, built-in commands and everyday SQL you need in the mysql (and mariadb) command-line client, on one page. Beginner · Reference · Any system Article Administration · Queries 15 Oct 2026
0222 Connecting to Oracle: SQL*Plus, SQLcl, EZConnect, tnsnames.ora and the listener Clients reach an Oracle database through the listener, using an Easy Connect string or a tnsnames.ora alias. Here are the formats, the… Intermediate · Reference · Linux, macOS, Windows Article Administration · Concepts & tools 15 Oct 2026
0232 mongosh cheat sheet: CRUD, indexes and explain() The mongosh commands you use every day: switching databases, inserting, querying, updating and deleting documents, creating indexes and checking a query plan… Beginner · Reference · Any system Article Basics 15 Oct 2026
0236 Redis data types and commands: a quick reference Redis stores values under keys, and each value has a type: string, hash, list, set, sorted set or stream. The essential commands… Beginner · Reference · Any system Article Basics 15 Oct 2026