SQLAlchemy

SQLAlchemy is a Python SQL toolkit and object relational pairer (ORM) that supports patterns of permanence at the corporate level. It includes both the high-level ORM structure and the Core system, an independent database abstraction layer. It offers the ability to mirror database schemes, link pool management, and create complex relational queries in a Pythonic language.

SQ

sqlalchemy · ORM & Database Tooling

STARS12.3K
FORKS1.8K
COMMITS—
CONTRIBUTORS841
VERSIONrel_2_1_0b3
UPDATEDtoday
pythonormDatabasesqlMIT
What can it do?
  • You manage database tables and relationships through Python objects.
  • You create SQL queries with Python expressions and perform database operations.
  • You automatically reflect database schemas and manage them through metadata structures.
User reviews
  • • NeutralHacker News

    SQLAlchemy 2.0 Released

    “I can't see the difference between the first two "VS" examples you have above, it just looks like they are formatted differently (oh, one has annotations and the other doesn't. you'd use the annotated version. I guess you are cut-and-pasting from a migration guide that's for…”

  • ↑ PositiveHacker News

    SQLAlchemy 2.0 Released

    “> Someone above mentioned that the new 2.0 docs are better, I seriously hope they are, they will make my suffering more tolerable. However, even if the docs are good the API is still the worst and least intuitive I've ever seen Thats Exactly my experience using SqlAlchemy on…”

My note

More in: ORM & Database Tooling