#sql
11 pages tagged sql.
sqlmodel
Package-level reference for SQLModel on PyPI — install, version policy, dependencies, and alternatives.
SQLAlchemy
Package-level reference for SQLAlchemy on PyPI — install variants, dialect drivers, version policy, extras, and alternatives.
pg
Package-level reference for node-postgres on npm — pools, parameterized queries, transactions, LISTEN/NOTIFY, and COPY streaming.
mysql2
Package-level reference for mysql2 on npm — promise API, prepared statements, pooling, streaming, and migration from mysql.
duckdb
Package-level reference for duckdb — install, versioning, extensions, and gotchas. In-process columnar OLAP for Python.
drizzle-orm
Package-level reference for Drizzle ORM — schema definitions, type-safe queries, relations, migrations with drizzle-kit, and deployment patterns.
Db2 SPUFI
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.
SQLModel
Define database models with Python type hints using SQLModel. Covers table creation, CRUD, relationships, FastAPI integration, Pydantic validation, and async sessions.
polars
High-performance DataFrames with a lazy expression API. Covers read/write, select, filter, group_by, joins, LazyFrame, datetime, string operations, and pandas interop.
DuckDB
Run fast analytical SQL queries in-process with DuckDB. Covers Python API, CSV/Parquet ingestion, pandas interop, Arrow, window functions, and persistent databases.
sqlalchemy
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.