Linux
441 entries match these filters
- 0099 Proxmox VE repositories and updates: enterprise vs no-subscription A fresh Proxmox VE install uses the enterprise repository, which needs a subscription. Learn how to switch to the no-subscription repository and… Beginner · Step by step · Linux Article Installation & first steps · Packages & updates 15 Oct 2026
- 0096 Flask (pallets/flask) A lightweight Python web framework for building websites and JSON APIs, with routing, request handling, and templates, and extensions for everything else. Any system Repo Python · Web frameworks 15 Oct 2026
- 0100 Create a VM and a cloud-init template with qm Create KVM virtual machines from the command line with qm, then build a reusable cloud-init template from a cloud image and clone… Intermediate · Step by step · Linux Article Basics · VMs & containers 15 Oct 2026
- 0097 Express (expressjs/express) A minimal and flexible web framework for Node.js, built around routes and middleware, and the foundation of countless APIs and other frameworks. Any system Repo Node.js · Web frameworks 15 Oct 2026
- 0075 CSV to JSON converter (Python, standard library) Convert any CSV file with a header row into a JSON array or JSON Lines. Handles quoted fields, a byte order mark,… Beginner · Step by step · Any system Script CSV & JSON · Files & automation 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
- 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
- 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
- 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 · Cheat sheet · Any system Script Joins · 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