Articles
Explanations, step-by-step guides, cheat sheets and fixes. Pick an area, or tell us what you need.
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.
Area
Clear filters
141 entries match these filters
- 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
- 0187 Terraform concepts: providers, state, plan and apply, modules, and OpenTofu Terraform describes infrastructure in code, compares it with what exists, and changes only the difference. Learn providers, resources, state, the plan/apply loop,… Beginner · Explains an idea · Any system Article Terraform 15 Oct 2026
- 0189 Terraform remote state: backends, locking and migrating local state Move Terraform state from a local file into a shared backend such as S3 with locking, so a team can work safely.… Advanced · Step by step · Any system Article Terraform 15 Oct 2026
- 0190 Fix: Terraform Error acquiring the state lock Another run holds the lock on your Terraform state, or a crashed run left it behind. Find out who holds it, wait… Advanced · Fixes an error · Any system Article Terraform 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
- 0137 Helm basics: install a chart, override values, upgrade and roll back Helm installs packaged Kubernetes apps called charts. Learn to add a repository, install a release, customize it with values files, upgrade it… Intermediate · Step by step · Any system Article Helm 15 Oct 2026
- 0140 kubectl cheat sheet: the commands you use every day A compact reference of everyday kubectl commands: contexts and namespaces, listing and inspecting objects, logs and exec, applying changes, rollouts, scaling and… Beginner · Cheat sheet · Any system Article Concepts · Troubleshooting 15 Oct 2026
- 0150 Logging in with oc and working with OpenShift projects Install the oc client, log in with a password, browser or token, then create, switch and inspect projects. Covers where oc stores… Beginner · Step by step · Any system Article Concepts · Deploying applications 15 Oct 2026
- 0151 Tutorial: deploy a small web app on OpenShift and expose it with a Route A step-by-step first deployment: create a project, build a static website from Git with Source-to-Image, publish it on an HTTPS Route, then… Beginner · Step by step · Any system Article Deploying applications 15 Oct 2026
- 0152 Build and deploy from source with oc new-app and Source-to-Image How oc new-app turns a Git repository or an image into a running app, how Source-to-Image and Docker builds are chosen, and… Intermediate · Step by step · Any system Article Deploying applications 15 Oct 2026
- 0153 Expose apps with OpenShift Routes: edge, passthrough and re-encrypt TLS A Route publishes a service on a host name through the OpenShift router. Learn when to use plain HTTP, edge, passthrough or… Intermediate · Step by step · Any system Article Deploying applications · Ingress & networking 15 Oct 2026
- 0154 OpenShift app configuration: environment, ConfigMaps, Secrets and persistent storage Set environment variables, load ConfigMaps and Secrets into a Deployment as variables or files, and give it persistent storage with a PersistentVolumeClaim,… Intermediate · Step by step · Any system Article Config, secrets & storage · Deploying applications 15 Oct 2026
- 0157 oc cheat sheet: everyday OpenShift CLI commands The oc commands you use every day, grouped by task: login and projects, apps and builds, routes, config, debugging, permissions and admin… Intermediate · Cheat sheet · Any system Article Deploying applications · Troubleshooting 15 Oct 2026
- 0161 Fix: Error from server (Forbidden): … is forbidden: User … cannot … in OpenShift oc refuses a command with Error from server (Forbidden). The message names the user, verb, resource and project. Learn how to read… Intermediate · Fixes an error · Any system Article Cluster administration · Troubleshooting 15 Oct 2026
- 0121 PCA 3.x Service CLI basics: connecting and finding your way around The Service CLI administers the Private Cloud Appliance 3.x Service Enclave. Connect with SSH on port 30006 and use list, show, help,… Intermediate · Cheat sheet · Any system Article Administration & monitoring 15 Oct 2026
- 0117 Configure the OCI CLI for Oracle Private Cloud Appliance 3.x Point the standard OCI CLI at a PCA 3.x Compute Enclave: create an API key, write ~/.oci/config with the appliance as the… Intermediate · Step by step · Any system Article Compute, networking & storage 15 Oct 2026
- 0118 Create a compute instance on PCA 3.x with the Compute Web UI or OCI CLI Launch a VM in the Private Cloud Appliance 3.x Compute Enclave: gather an image, shape, subnet and SSH key, then create the… Intermediate · Step by step · Any system Article Compute, networking & storage 15 Oct 2026
- 0119 PCA 3.x networking basics: create a VCN, subnets and security lists On Private Cloud Appliance 3.x, instances need a VCN and a subnet. Create them in the Compute Web UI or OCI CLI… Intermediate · Step by step · Any system Article Compute, networking & storage 15 Oct 2026
- 0120 Block volumes on PCA 3.x: create, attach and mount a data disk Add storage to a Private Cloud Appliance 3.x instance: create a block volume, attach it as paravirtualized, then format and mount it… Intermediate · Step by step · Any system Article Compute, networking & storage 15 Oct 2026
- 0091 CSS selectors and specificity reference The selectors you will use every day, how the browser decides which rule wins when several match, and practical ways to keep… Intermediate · Cheat sheet · Browser Article References · Selectors & specificity 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
- 0092 Semantic HTML and accessibility basics, with a responsive page skeleton A minimal responsive HTML page built from semantic elements, plus the accessibility basics every page needs: headings, labels, alt text, keyboard focus,… Beginner · Step by step · Browser Article Accessibility · Layout 15 Oct 2026
- 0069 NULL in SQL: why = NULL never matches and how to handle missing values NULL means "unknown", so comparisons with it are neither true nor false. Use IS NULL, COALESCE and careful aggregates to avoid rows… Intermediate · Explains an idea · Any system Article Queries 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
- 0071 Fix: column “x” must appear in the GROUP BY clause or be used in an aggregate function PostgreSQL rejects a grouped query that selects a column with more than one possible value per group. Add the column to GROUP… Intermediate · Fixes an error · Any system Article Queries 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
- 0073 Fix: json.decoder.JSONDecodeError: Expecting value: line 1 column 1 (char 0) Python's json module found nothing it could parse at the very first character. The input is usually empty, HTML, or already consumed.… Beginner · Fixes an error · Any system Article Common errors · CSV & JSON 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
- 0081 How an HTTP request works: methods, headers, and body An HTTP request is a short text message a client sends to a server: a method and path, some headers, and sometimes… Beginner · Explains an idea · Any system Article Making requests 15 Oct 2026
- 0082 HTTP status codes: the common ones and what to do A quick reference to the HTTP status codes you will meet most often, what each one means, and the first thing to… Beginner · Cheat sheet · Any system Article References · Status codes 15 Oct 2026
- 0086 API authentication basics: API keys, Bearer tokens, and OAuth How APIs know who is calling: static API keys, Bearer tokens in the Authorization header, Basic auth, and a high-level tour of… Intermediate · Explains an idea · Any system Article Authentication 15 Oct 2026
- 0089 Fix: 413 Request Entity Too Large A server or proxy rejected your request because its body is bigger than the configured limit. Find which layer set the limit,… Intermediate · Fixes an error · Any system, Linux Article Status codes · Web frameworks 15 Oct 2026
- 0087 CORS explained: why the browser blocks your request CORS is the browser rule that decides whether JavaScript on one origin may read a response from another. The server opts in… Intermediate · Explains an idea · Browser Article Async code · Making requests 15 Oct 2026
- 0088 Fix: Access to fetch at ‘…’ from origin ‘…’ has been blocked by CORS policy The browser refused to give your script a cross-origin response because the server did not send the right Access-Control-* headers. Fix it… Intermediate · Fixes an error · Browser Article Common errors · Making requests 15 Oct 2026
- 0090 Flexbox and CSS Grid: laying out a page Flexbox arranges items along one line, Grid arranges them in rows and columns at once. Learn the handful of properties that cover… Beginner · Step by step · Browser Article Layout 15 Oct 2026
- 0067 Your first SQL queries: SELECT, WHERE, ORDER BY, LIMIT and GROUP BY Read data from a table, keep only the rows you want, sort them, take the first few, and summarize groups with COUNT,… Beginner · Step by step · Any system Article Queries 15 Oct 2026
- 0037 Git cheat sheet The Git commands you reach for most, grouped by task and using the modern switch and restore forms. Copy, paste, and replace… Beginner · Cheat sheet · Any system Article Git 15 Oct 2026
- 0038 The pull request workflow on GitHub A pull request asks to merge your branch into another one, with review and automated checks in between. This is the whole… Beginner · Step by step · Any system Article Pull requests 15 Oct 2026
- 0039 A minimal GitHub Actions workflow that runs your tests Add one YAML file under .github/workflows and GitHub runs your tests on every push and pull request. Here is a small, explained… Intermediate · Step by step · Any system Article GitHub Actions 15 Oct 2026
- 0040 Fix: error: failed to push some refs to … Git refused your push, usually because the remote branch has commits you do not have yet. Bring them in, combine them with… Beginner · Fixes an error · Any system Article Common errors 15 Oct 2026