Jun 14, 2026 in Programming, Data, Databases - SQL is the standard language for storing, querying and changing data in relational databases. Core commands (SELECT, INSERT, UPDATE, DELETE), how a query works, SQL vs NoSQL, and why it is still essential in 2026.
Jun 14, 2026 in Programming, Tools, Workflow - Git is a distributed version-control system that tracks every change to your code so you can branch, merge, collaborate and undo. Core concepts (commit, branch, merge, remote), the daily workflow, and how it differs from GitHub.
Jun 14, 2026 in Programming, Concepts - An algorithm is a finite, step-by-step procedure that turns input into output. Its key properties, everyday and code examples, why efficiency (Big-O) matters, and how it differs from a program.
Jun 14, 2026 in Programming, Web, Data - JSON is a lightweight, human-readable text format for structured data - the language most web APIs and config files speak. Its syntax, why it is everywhere, how it compares to XML, and its honest limits.
Jun 14, 2026 in Programming, Web, Concepts - An API is a contract that lets one piece of software talk to another. The main kinds (web/REST, library, OS), how a web request and response work, and why APIs are everywhere in modern software.
Jun 14, 2026 in Haskell, Concepts - Haskell is a purely functional, statically typed, lazy language with powerful type inference. The ideas that define it - purity, immutability, laziness, strong types - what it is used for, and how to start.
Jun 14, 2026 in Haskell, Syntax - A list comprehension builds a list from generators with optional guards - concise and close to set-builder notation. Syntax, multiple generators, guards, and how they relate to map and filter.
Jun 14, 2026 in Haskell, Concepts - Haskell computes a value only when it is actually needed. What lazy evaluation is, thunks, infinite data structures, the space-leak trap, and forcing strictness with seq and BangPatterns.
Jun 14, 2026 in Haskell, Concepts - A monad sequences computations carrying context - Maybe, Either, IO, lists. What it really is, bind (>>=) and return, and do-notation, plainly.
Jun 14, 2026 in Haskell, Compiler - What GHC is, installing it with GHCup, using GHCi, the flags that matter (-O2, -Wall, -threaded, -j), and how it fits with Cabal and Stack.
Jun 14, 2026 in Haskell, Editor - What HLS does, installing it with GHCup, wiring it into VS Code and Neovim, matching it to your GHC, and fixing the usual errors.
Jun 14, 2026 in Haskell, Toolchain - GHCup is the recommended way to install GHC, Cabal, Stack and HLS in 2026 - clean install, version switching, and the common pitfalls that trip newcomers.