Audience
Developers and companies interested in a toolkit and object-relational mapping solution
About SQLAlchemy
SQLAlchemy is the Python SQL toolkit and object-relational mapper that gives application developers the full power and flexibility of SQL. SQL databases behave less like object collections the more size and performance start to matter; object collections behave less like tables and rows the more abstraction starts to matter. SQLAlchemy aims to accommodate both of these principles. SQLAlchemy considers the database to be a relational algebra engine, not just a collection of tables. Rows can be selected from not only tables but also joins and other select statements; any of these units can be composed into a larger structure. SQLAlchemy's expression language builds on this concept from its core. SQLAlchemy is most famous for its object-relational mapper (ORM), an optional component that provides the data mapper pattern.
Other Popular Alternatives & Related Software
CData Python Connectors
CData Python Connectors simplify the way that Python users connect to SaaS, Big Data, NoSQL, and relational data sources. Our Python Connectors offer simple Python database interfaces (DB-API), making it easy to connect with popular tooling like Jupyter Notebook, SQLAlchemy, pandas, Dash, Apache Airflow, petl, and more.
CData Python Connectors create a SQL wrapper around APIs and data protocols, simplifying data access from within Python and enabling Python users to easily connect more than 150 SaaS, Big Data, NoSQL, and relational data sources with advanced Python processing.
The CData Python Connectors fill a critical gap in Python tooling by providing consistent connectivity with data-centric interfaces to hundreds of different SaaS/Cloud, NoSQL, and Big Data sources.
Download a 30-day free trial or learn more at: https://www.cdata.com/python/
Learn more
Apache Superset
Superset is fast, lightweight, intuitive, and loaded with options that make it easy for users of all skill sets to explore and visualize their data, from simple line charts to highly detailed geospatial charts. Superset can connect to any SQL based datasource through SQLAlchemy, including modern cloud native databases and engines at petabyte scale. Superset is lightweight and highly scalable, leveraging the power of your existing data infrastructure without requiring yet another ingestion layer.
Learn more
Voldemort
Voldemort is not a relational database, it does not attempt to satisfy arbitrary relations while satisfying ACID properties. Nor is it an object database that attempts to transparently map object reference graphs. Nor does it introduce a new abstraction such as document-orientation. It is basically just a big, distributed, persistent, fault-tolerant hash table. For applications that can use an O/R mapper like active-record or hibernate this will provide horizontal scalability and much higher availability but at great loss of convenience. For large applications under internet-type scalability pressure, a system may likely consist of a number of functionally partitioned services or APIs, which may manage storage resources across multiple data centers using storage systems which may themselves be horizontally partitioned. For applications in this space, arbitrary in-database joins are already impossible since all the data is not available in any single database.
Learn more
Alembic
Alembic is a lightweight database migration tool that can be used with the SQLAlchemy database toolkit for Python. Alembic is written by the author of SQLAlchemy. While Alembic can be installed system-wide, it’s more common that it’s installed locally in a virtual environment, as it also uses libraries such as SQLAlchemy and database drivers that are more appropriate for local installations. Can emit statements to a database in order to change the structure of tables and other constructs. Provides a system whereby "migration scripts" may be constructed; each script indicates a particular series of steps that can "upgrade" a target database to a new version, and optionally a series of steps that can "downgrade" similarly, doing the same steps in reverse. Very open-ended and transparent configuration and operation. A new Alembic environment is generated from a set of templates which is selected among a set of options when setup first occurs.
Learn more
Integrations
Company Information
SQLAlchemy
United States
www.sqlalchemy.org
Videos and Screen Captures
Other Useful Business Software
MongoDB Atlas runs apps anywhere
MongoDB Atlas gives you the freedom to build and run modern applications anywhere—across AWS, Azure, and Google Cloud. With global availability in over 115 regions, Atlas lets you deploy close to your users, meet compliance needs, and scale with confidence across any geography.
Product Details
Platforms Supported
Cloud
Training
Documentation
Support
Online
