Lib

#cheatsheet

12entries tagged “cheatsheet”.

• Case Conventions in Python, JavaScript and SQL Server

  What snake_case, camelCase, PascalCase and kebab-case actually look like, then where each language and SQL Server expects them — variables, functions, classes, constants, files and identifiers.

  Updated 7 September 2026pythonjavascriptsql-servernamingstylecheatsheet

• Exploratory Data Analysis in Python with marimo

  A working cheat sheet for EDA in Python — why marimo over Jupyter, running it ephemerally with uvx, reactive notebook basics, and the core exploration toolkit.

  Updated 7 September 2026pythonmarimoedauvcheatsheet

• OLAP Design with DuckDB, Parquet and Polars

  Dimensional modeling for an analytical workload, why DuckDB rewards a different schema shape than a transactional database, where Parquet fits as the storage layer, and how to wire it all together in a Python project alongside Polars.

  Updated 7 September 2026pythonpolarsduckdbparquetolapdatabasecheatsheet

• SQL Server: Schema Discovery Without Admin Access

  Querying sys.* catalog views to map schemas, tables, columns and datatypes; getting row counts without a full scan; and using SET STATISTICS as a stand-in for an execution plan you cannot open in SSMS.

  Updated 7 September 2026sqlsql-serverdatabasecheatsheet

• Bash Config Setup

  Where Bash actually sources its startup files from, login vs non-login and interactive vs non-interactive shells, and how Git Bash fits in.

  Updated 6 September 2026bashshellsetupgit-bashcheatsheet

• Git Bash Shell Command Reference

  A working cheat sheet for everyday shell utilities in Git Bash on Windows — navigation, files, text, and permissions.

  Updated 6 September 2026git-bashwindowsshellclicheatsheet

• Git Bash for Windows Setup

  Configuring mintty (the terminal behind Git Bash) for Windows-style copy/paste shortcuts, a modern editor-like color scheme, and a larger font.

  Updated 6 September 2026git-bashwindowsterminalsetupcheatsheet

• Git Command Reference

  A working cheat sheet of everyday Git commands, grouped by task, with the flags I actually reach for.

  Updated 6 September 2026gitclicheatsheet

• MkDocs Material Setup

  Setting up MkDocs with the Material theme for a Python project — config, plugins, markdown extensions, and deployment — plus the move to Zensical.

  Updated 6 September 2026pythonmkdocsdocumentationuvcheatsheet

• Polars: Reading & Exploring Data

  A working cheat sheet for Polars — reading Parquet files and getting a first look at a DataFrame: shape, schema, nulls, and unique values.

  Updated 6 September 2026pythonpolarsdatacheatsheet

• Python uv Command Reference

  A working cheat sheet for uv — Python packaging, venvs, and project management — grouped by task.

  Updated 6 September 2026pythonuvclicheatsheet

• Modern Python Project Setup with uv

  A walkthrough for scaffolding a new Python project with uv — layout, pyproject.toml, dependency groups, linting, testing, and locking.

  Updated 6 September 2026pythonuvsetupcheatsheet