5 Data
Every entry filed under Data and its subtopics.
What kind of help
What do these mean?
- Beginner
- You are new to this topic.
- Intermediate
- You use it, and want to get better.
- Advanced
- You know it well and need the details.
- Guided project
- Build something small from start to finish, step by step.
- Explains an idea
- Plain words on how something works and why.
- Step by step
- Numbered steps to get one task done.
- Cheat sheet
- Commands and options in a table, to look up fast.
- Fixes an error
- An error message, what it means, and how to solve it.
49 entries match these filters
- 0421 grep, sed, awk and jq: the four text tools you will use every week A working reference for the four commands that handle most text on the command line: grep finds lines, sed edits them, awk… Intermediate · Cheat sheet · Linux, macOS Article jq & JSON on the command line · Modern command-line tools · Text processing 15 Oct 2026
- 0425 jq cheat script: pretty-print, filter and flatten JSON from a file or stdin A small read-only bash wrapper around jq with the recipes you keep looking up: pretty, compact, sorted keys, list paths, pick fields,… Beginner · Cheat sheet · Linux, macOS Script jq & JSON on the command line · Modern command-line tools · Text processing 15 Oct 2026
- 0393 Install PostgreSQL on Linux, macOS and Windows Install the PostgreSQL server and the psql client on each desktop OS, start the service, connect as the postgres superuser and create… Beginner · Step by step · Linux, macOS, Windows Article Install & connect · Installing languages & tools 15 Oct 2026
- 0331 docker compose for an app with a PostgreSQL database A compose.yaml that runs your application next to a PostgreSQL container, with a named volume for the data, a health check so… Intermediate · Step by step · Linux, macOS, Windows Article Docker Compose · Install & connect 15 Oct 2026
- 0326 Fix: too many open files A process hit its file descriptor limit, usually 1024. Raise it for the shell, the systemd unit or the user, fix a… Intermediate · Fixes an error · Linux, macOS Article Performance & tuning · Processes & ports · Services & systemd 15 Oct 2026
- 0293 What is SQL? SQL is the language you use to ask a relational database questions and to add, change or delete its data. Beginner · Explains an idea · Any system Article Queries 15 Oct 2026
- 0295 What is a transaction? A transaction groups several database changes so they all happen together or not at all, keeping the data consistent. Beginner · Explains an idea · Any system Article Queries 15 Oct 2026
- 0296 What is a primary key? A primary key is the column that uniquely identifies each row in a table, like an ID number nobody else can have. Beginner · Explains an idea · Any system Article Queries 15 Oct 2026
- 0297 What is a foreign key? A foreign key is a column that points to the primary key of another table, linking related rows together. Beginner · Explains an idea · Any system Article Joins 15 Oct 2026
- 0294 What is an index (database)? A database index is a lookup structure that lets the database find rows fast instead of reading the whole table. Beginner · Explains an idea · Any system Article Indexes & performance 15 Oct 2026
- 0292 What is a database? A database is an organised store of data that programs can search, update and share safely, even with many users at once. Beginner · Explains an idea · Any system Article Choosing a database 15 Oct 2026
- 0298 What is JSON? JSON is a simple text format for structured data, made of names, values, lists and nested objects, used everywhere on the web. Beginner · Explains an idea · Any system Article CSV & JSON 15 Oct 2026
- 0299 What is YAML? YAML is a human friendly text format for configuration files where indentation shows structure instead of brackets. Beginner · Explains an idea · Any system Article CSV & JSON 15 Oct 2026
- 0260 Design and build a library database in SQLite: tables, keys, joins, reports and backups Model books, members and loans, create tables with keys and constraints, load sample data, write join and aggregate reports, add indexes checked… Beginner · Guided project · Any system Article Joins · Queries 15 Oct 2026
- 0244 MongoDB server source code (mongodb/mongo) The official repository of the MongoDB database server, including mongod, mongos and the core server tests. Linux, macOS, Windows Repo Administration · MongoDB 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 · Cheat sheet · Any system Article Basics 15 Oct 2026
- 0235 Fix: MongoServerSelectionError: connect ECONNREFUSED 127.0.0.1:27017 Your app or tool tried to reach MongoDB on port 27017 and nothing accepted the connection. Usually mongod is not running, crashed… Intermediate · Fixes an error · Linux, macOS, Windows Article Administration · Basics 15 Oct 2026
- 0245 Redis server source code (redis/redis) The official repository of Redis Open Source: the in-memory data structure server, redis-cli, Sentinel and the example redis.conf. Linux, macOS Repo Administration & persistence · Redis 15 Oct 2026
- 0250 Containerize a Node.js app and run it with PostgreSQL using Docker Compose Package a small Node.js web app in a multi-stage Docker image, then run it next to PostgreSQL with Docker Compose, named volumes,… Intermediate · Guided project · Linux, macOS, Windows Article Docker basics · Docker Compose · PostgreSQL 15 Oct 2026
- 0246 Valkey: open source key-value datastore (valkey-io/valkey) Valkey is a BSD-licensed key-value data structure server, forked from Redis just before its 2024 license change and backed by the Linux… Linux, macOS Repo Administration & persistence · Redis 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 · Cheat sheet · Any system Article Basics 15 Oct 2026
- 0237 Use Redis as a cache: TTLs, maxmemory and an eviction health report Set a memory limit and an eviction policy so Redis behaves like a cache, give keys TTLs, then run a bash report… Intermediate · Step by step · Linux, macOS Script Administration & persistence · Basics 15 Oct 2026
- 0241 Choosing a database: relational, document or key-value Relational databases, document stores like MongoDB and key-value stores like Redis each fit different jobs. An honest look at what each does… Beginner · Explains an idea · Any system Article Choosing a database · Database operations 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 · Cheat sheet · Any system Article Administration · Queries 15 Oct 2026
- 0227 Fix: ORA-01017: invalid username/password; logon denied Oracle rejected the login. Check the password (case-sensitive), that you connect to the right PDB service, and whether the account is locked… Intermediate · Fixes an error · Any system Article Administration · Security & access 15 Oct 2026
- 0231 MongoDB documents and collections compared with SQL tables MongoDB stores data as JSON-like documents grouped in collections instead of rows in tables. This explains the model, the _id field, embedding… Beginner · Explains an idea · Any system Article Basics · Choosing a database 15 Oct 2026
- 0212 postgres/postgres: PostgreSQL source code mirror The official read-only GitHub mirror of the PostgreSQL source repository. Browse the code and history here; patches go through the project's mailing… Linux, macOS, Windows Repo Install & connect · PostgreSQL 15 Oct 2026
- 0209 Fix: FATAL: password authentication failed for user PostgreSQL reached the server and found a matching pg_hba.conf rule, but the password check failed. Usually a wrong password, a role without… Intermediate · Fixes an error · Any system Article Roles & administration · Security & access 15 Oct 2026
- 0228 MySQL Server source code Oracle's public GitHub repository with the source code of MySQL Server, including the server, client programs such as mysql and mysqldump, and… Linux, macOS, Windows Repo MySQL & MariaDB 15 Oct 2026
- 0229 MariaDB Server The source of MariaDB Server, the community-developed fork of MySQL started by original MySQL developers, licensed under GPLv2. Linux, macOS, Windows Repo MySQL & MariaDB 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 · Cheat sheet · Linux, macOS, Windows Article Administration · Concepts & tools 15 Oct 2026
- 0223 Oracle users, roles and tablespaces: setup script and usage report (SQL) A SQL*Plus/SQLcl script that creates a tablespace, a role and an application user inside a PDB, then reports tablespace usage from the… Intermediate · Step by step · Any system Script Administration · Security & access 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 · Cheat sheet · Any system Article Install & connect · Roles & administration 15 Oct 2026
- 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 · Cheat sheet · Linux, macOS, Windows Script Command-line tools · jq & JSON on the command line 15 Oct 2026
- 0074 pandas basics: read a CSV, filter rows and summarize with groupby Load a CSV into a pandas DataFrame, inspect it, filter rows with conditions, and compute totals per group, with the SQL equivalent… Intermediate · Step by step · Any system Article Data analysis · Files & automation 15 Oct 2026
- 0078 pandas The most widely used Python library for working with tabular data: DataFrames, file readers and writers, grouping, joining and time series. Any system Repo Data analysis 15 Oct 2026
- 0068 SQL joins explained: INNER, LEFT and finding rows with no match A join combines rows from two tables using a matching condition. INNER JOIN keeps only matches, LEFT JOIN keeps every row from… Intermediate · Explains an idea · Any system Article Joins 15 Oct 2026
- 0070 Indexes and EXPLAIN: making SQL queries fast An index is a sorted lookup structure that lets the database jump to matching rows instead of reading the whole table. EXPLAIN… Advanced · Explains an idea · Any system Article Indexes & performance 15 Oct 2026
- 0080 SQLite (official Git mirror) The source tree of SQLite, the self-contained SQL database engine embedded in phones, browsers and countless applications, mirrored to GitHub by its… Any system Repo Queries · SQL 15 Oct 2026
- 0072 CSV vs JSON: choosing a format and avoiding the classic pitfalls CSV is a simple table of text; JSON holds nested, typed data. Both break in predictable ways: quoting, delimiters, encodings, numbers and… Beginner · Explains an idea · Any system Article CSV & JSON 15 Oct 2026