skip to content

#sql (5)

Cheat sheets (5)

Db2 SPUFI — Interactive SQL, DSN commands, BIND, and catalog queries on z/OS

Run SQL through SPUFI, drive Db2 with DSN subsystem commands, BIND packages and plans, schedule DSNTEP2 in JCL, query the SYSIBM catalog, and generate DCLGEN.
db2 sql spufi dsn zos mainframe web-researched

DuckDB — Embedded Analytics Database

Run fast analytical SQL queries in-process with DuckDB. Covers Python API, CSV/Parquet ingestion, pandas interop, Arrow, window functions, and persistent databases.
python duckdb sql analytics olap parquet pandas arrow

polars — Fast DataFrames

High-performance DataFrames with a lazy expression API. Covers read/write, select, filter, group_by, joins, LazyFrame, datetime, string operations, and pandas interop.
python polars dataframes data csv parquet sql

SQLModel — Typed ORM for FastAPI

Define database models with Python type hints using SQLModel. Covers table creation, CRUD, relationships, FastAPI integration, Pydantic validation, and async sessions.
python sqlmodel orm sql fastapi pydantic sqlalchemy database

sqlalchemy — SQL Toolkit & ORM

Connect to databases, write queries, and define ORM models with SQLAlchemy 2.0. Covers the engine, sessions, Core queries, ORM declarative models, relationships, session lifecycle, migrations with Alembic, and connection pool configuration.
python sqlalchemy orm sql database sqlite postgres