skip to content

#database (10)

Cheat sheets (10)

mongoose — MongoDB ODM for Node

Package-level reference for mongoose on npm — schemas, models, transactions, populate, indexes, and 7-to-8 migration.
npm package mongoose mongodb database odm schema

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

prisma — Type-safe ORM and migration toolkit

Package-level reference for prisma (CLI) and @prisma/client (runtime) on npm — install, generator, peer setup, Node and database support, and alternatives.
npm package orm database typescript

redis — Official Redis Client for Node

Package-level reference for node-redis on npm — pipelining, pub/sub, TTL, the v3-to-v4 API rewrite, and rate-limit patterns.
npm package redis cache pubsub database

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

Prisma — Type-Safe Node.js ORM

Schema-first ORM for Node.js with auto-generated typed client, declarative migrations, relations, transactions, and seeding — for PostgreSQL, MySQL, SQLite, MongoDB, and more.
javascript typescript orm database prisma node

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