SQLAlchemy 2.0.46

Database Abstraction Library

Stars: 11517, Watchers: 11517, Forks: 1640, Open Issues: 209

The sqlalchemy/sqlalchemy repo was created 7 years ago and the last code push was Yesterday.
The project is extremely popular with a mindblowing 11517 github stars!

How to Install sqlalchemy

You can install sqlalchemy using pip

pip install sqlalchemy

or add it to a project with poetry

poetry add sqlalchemy

Package Details

Author

Mike Bayer

License

MIT

Homepage

https://www.sqlalchemy.org

PyPi:

https://pypi.org/project/SQLAlchemy/

Documentation:

https://docs.sqlalchemy.org

GitHub Repo:

https://github.com/sqlalchemy/sqlalchemy

Classifiers

• Database/Front-Ends

Related Packages

Errors

A list of common sqlalchemy errors.

Code Examples

Here are some sqlalchemy code examples and snippets.

GitHub Issues

The sqlalchemy package has 209 open issues on GitHub

• Typed table support
• Add JSON type support for Oracle dialect, addresses #10375
• docs: fixups in PostgreSQL dialect rST docstrings
• Added implementations for avg & abs
• Provide an implementation for avg / abs function with proper type
• Add option for disabling automatic addition of constraint/indexes to the table
• support new MSFT driver, when it's usable
• Warn when distinct() is used outside of aggregated functions
• support Oracle JSON datatype
• extend_existing will add copies of indexes, constraints, etc. as there is no deduplication on name
• support autocommit w/ explicit isolation levels

See more issues on GitHub