SQLAlchemy

E430980

SQLAlchemy is a powerful Python SQL toolkit and Object-Relational Mapping (ORM) library that provides a high-level, flexible interface for working with relational databases.

All labels observed (7)

How this entity was disambiguated

Statements (66)

Predicate Object
instanceOf Python library
SQL toolkit
object–relational mapping library
author Mike Bayer
category ORM framework
database library
commonlyUsedWith Django (via third-party integrations)
FastAPI
Flask
Pyramid
developer Mike Bayer
documentation https://docs.sqlalchemy.org/
ecosystem Python data and web development ecosystem
feature SQL expression language
asynchronous I/O support
connection URL configuration
connection pooling
database migrations support via Alembic
declarative mapping
eager loading of relationships
event system
extensible dialect architecture
imperative mapping
lazy loading of relationships
object–relational mapping
schema metadata management
schema reflection
transaction management
typed ORM mappings
unit of work pattern
hasComponent Connection pooling
Core
Dialect system
Engine
ORM
initialReleaseYear 2005
license MIT License
maintainer SQLAlchemy project team
linked to: SQLAlchemy
programmingLanguage Python
relatedProject Alembic
repository https://github.com/sqlalchemy/sqlalchemy
linked to: SQLAlchemy
supportsDatabase Amazon Redshift
CockroachDB
Firebird
Google Cloud Spanner
linked to: Cloud Spanner

IBM DB2
MariaDB
Microsoft SQL Server
linked to: SQL Server

MySQL
Oracle Database
PostgreSQL
SQLite
Snowflake
Sybase
supportsLanguage Python
supportsParadigm SQL-first approach
code-first schema definition
data mapper pattern
declarative ORM
supportsStandard SQL
usedFor database-agnostic application development
defining database schemas in Python code
executing SQL queries
mapping Python classes to database tables
relational database access in Python
website https://www.sqlalchemy.org/

How these facts were elicited

Referenced by (18)

Full triples — surface form annotated when it differs from this entity's canonical label.

Flask-SQLAlchemy integratesWith SQLAlchemy
Flask-SQLAlchemy uses SQLAlchemy ORM
linked to: SQLAlchemy
Flask-SQLAlchemy requires SQLAlchemy
Flask-Migrate supports SQLAlchemy
Flask-Migrate requires SQLAlchemy
Flask-Admin supports SQLAlchemy
Django Channels compatibleWith Django ORM
linked to: SQLAlchemy
SQLModel basedOn SQLAlchemy
subject linked to: sqlmodel
SQLModel supports SQLAlchemy Core
subject linked to: sqlmodel
linked to: SQLAlchemy
SQLModel supports SQLAlchemy ORM
subject linked to: sqlmodel
linked to: SQLAlchemy
SQLModel compatibleWith SQLAlchemy 1.4+
subject linked to: sqlmodel
linked to: SQLAlchemy
SQLAlchemy repository https://github.com/sqlalchemy/sqlalchemy
linked to: SQLAlchemy
SQLAlchemy maintainer SQLAlchemy project team
linked to: SQLAlchemy
Alembic usedWith SQLAlchemy
Alembic integratesWith SQLAlchemy ORM
linked to: SQLAlchemy
Alembic integratesWith SQLAlchemy Core
linked to: SQLAlchemy
Flask-Security supports SQLAlchemy