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.
60 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
- 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
- 0364 Schedule PostgreSQL and MySQL dumps with systemd timers Write one dump script for PostgreSQL and MySQL, run it from a systemd service and timer instead of cron, keep two weeks… Intermediate · Step by step · Linux Article Backup tools · PostgreSQL 15 Oct 2026
- 0324 Fix: psql: FATAL: Peer authentication failed On local socket connections PostgreSQL checks that your OS user name equals the database role. When they differ you get this error.… Intermediate · Fixes an error · Linux Article Install & connect · Security & access 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
- 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
- 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
- 0258 Build a MySQL 8.4 source-replica pair with GTIDs and rehearse a manual failover Set up GTID replication between two MySQL 8.4 servers, provision the replica with the clone plugin, then stop the source, promote the… Advanced · Guided project · Linux Article Administration · Replication 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
- 0257 Run PostgreSQL properly on a Linux server: install, lock down, back up, monitor and patch Set up PostgreSQL 18 from the official repository for one application: a dedicated role and database, SCRAM logins from one app server… Intermediate · Guided project · Linux Article Backup & restore · Install & connect · Roles & administration 15 Oct 2026
- 0242 Database security checklist: access, encryption, exposure and patching A practical checklist for hardening any database server, with MongoDB and Redis examples: no public exposure, authentication, least privilege, TLS, protected backups,… Advanced · Step by step · Linux Article Database operations · Security & access 15 Oct 2026
- 0243 Database backup strategy: the 3-2-1 rule and testing restores Keep three copies of your data on two kinds of storage with one copy offsite, choose dump or snapshot methods per database,… Intermediate · Step by step · Linux Article Database operations · Security & access 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
- 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
- 0233 Turn on MongoDB authentication and create least-privilege users A fresh MongoDB install accepts connections without a password. Create a user administrator, enable authorization, then give each application and backup job… Intermediate · Step by step · Linux Article Administration · Security & access 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
- 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
- 0259 Speed up a slow database query with a Redis cache: cache-aside in Python, measured and locked down Put Redis in front of a slow query in a small Python app: cache-aside reads, TTLs with jitter, invalidation on writes, an… Intermediate · Guided project · Linux Article Administration & persistence · Basics 15 Oct 2026
- 0238 Redis persistence and high availability: RDB, AOF, replicas and Sentinel Redis keeps data in memory and writes it to disk with RDB snapshots, an append-only file, or both. Replicas copy data to… Intermediate · Explains an idea · Linux Article Administration & persistence 15 Oct 2026
- 0239 Fix: (error) NOAUTH Authentication required. (and securing Redis with ACLs) Redis requires a login and your client sent a command without one. Pass the right user and password, and use the moment… Advanced · Fixes an error · Linux Article Administration & persistence · Security & access 15 Oct 2026
- 0240 Fix: MISCONF Redis is configured to save RDB snapshots, but it’s currently unable to persist to disk Redis blocks writes because its last background snapshot failed. Find the cause in the log (full disk, permissions, failed fork), fix it,… Intermediate · Fixes an error · Linux Article Administration & persistence 15 Oct 2026
- 0211 Fix: psql connection to server on socket /var/run/postgresql/.s.PGSQL.5432 failed psql tried the local Unix socket and found nothing there. The server is not running, listens on another port, or uses a… Beginner · Fixes an error · Linux Article Install & connect 15 Oct 2026
- 0217 MySQL binary logs and point-in-time recovery The binary log records every change after your last backup. Restore the backup, then replay the binary log up to just before… Advanced · Explains an idea · Linux Article Backup & restore · Replication 15 Oct 2026
- 0221 Oracle Database basics: instance vs database, CDB and PDB An Oracle instance is memory and processes; the database is the files on disk. Since 21c every database is a container database… Beginner · Explains an idea · Linux, Windows Article Concepts & tools 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
- 0226 Fix: ORA-12541: TNS:no listener The client reached the host but nothing was listening on that port. Start or fix the Oracle listener, or correct the host… Intermediate · Fixes an error · Linux, Windows Article Administration · Concepts & tools 15 Oct 2026
- 0225 Oracle Data Pump: export and import schemas with expdp and impdp Data Pump moves schemas, tables or whole databases between Oracle databases as dump files. Set up a directory object, export with expdp… Intermediate · Step by step · Linux, Windows Article Administration · Backup with RMAN 15 Oct 2026
- 0204 VACUUM, autovacuum and table bloat in PostgreSQL Updates and deletes leave dead row versions behind. VACUUM makes that space reusable, keeps statistics fresh and prevents transaction ID wraparound; autovacuum… Intermediate · Explains an idea · Linux Article Performance & tuning · Roles & administration 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
- 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
- 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
- 0202 Back up and restore PostgreSQL with pg_dump, pg_restore and pg_dumpall Make logical backups of one database with pg_dump, of roles and the whole cluster with pg_dumpall, and restore them with pg_restore or… Beginner · Step by step · Linux Article Backup & restore 15 Oct 2026