skip to content

#sql (11)

Cheat sheets (11)

drizzle-orm — TypeScript SQL Toolkit

Package-level reference for Drizzle ORM — schema definitions, type-safe queries, relations, migrations with drizzle-kit, and deployment patterns.
npm package orm sql typescript

mysql2 — Fast MySQL & MariaDB Driver for Node

Package-level reference for mysql2 on npm — promise API, prepared statements, pooling, streaming, and migration from mysql.
npm package mysql mariadb database sql driver

pg — Native PostgreSQL Client for Node

Package-level reference for node-postgres on npm — pools, parameterized queries, transactions, LISTEN/NOTIFY, and COPY streaming.
npm package postgres database sql driver

duckdb — Embedded Analytical SQL

Package-level reference for duckdb — install, versioning, extensions, and gotchas. In-process columnar OLAP for Python.
pip package duckdb sql analytics

SQLAlchemy — The Python SQL Toolkit & ORM

Package-level reference for SQLAlchemy on PyPI — install variants, dialect drivers, version policy, extras, and alternatives.
pip package orm sql database

sqlmodel — Pydantic + SQLAlchemy Fusion

Package-level reference for SQLModel on PyPI — install, version policy, dependencies, and alternatives.
pip package orm sql database

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