Install SQLAlchemy 1.4.3
ActiveState has made it easy to install the latest version of SQLAlchemy. Copy and paste the snippet below into your terminal to install a verified, built-from-source version of SQLAlchemy from ActiveState's free repository. We've taken care of all the dependencies so you don't have to.
Run the following command in your terminal
pip3 install --index-url https://har.activestate.com/activestate/trusted-artifacts/latest SQLAlchemy==1.4.3The --index-url parameter tells pip to install the package from ActiveState's repository.
Why install Python packages from ActiveState?
| ActiveState | PyPI | Anaconda / conda | |
|---|---|---|---|
Built from source codeWe build all packages from known and vetted source code. The source code is stored indefinitely on our secure supply chain. This reduces the likelihood of specific types of exploits while eliminating typosquatting. | Varies | Varies | |
Support for OS-level dependenciesArtifact dependencies extend to the operating-system level. For example, when building XML libraries for Python, we also build Expat from its C source files. | |||
Vetted new source releasesSource is updated as new versions are released, but after a manual and automatic review process and at 24-48 hour delay compared to the main public repository. | Varies | ||
Artifacts built for Linux, MacOS, Windows | |||
Isolated and ephemeral build environmentsBuild stages are conducted in single-use build environments that are discarded after the build is complete. Builds are run automatically based on known and version-controlled configurations. | Varies | ||
Revision-controlled build historyThe ActiveState Platform maintains a catalog of all source code used to build artifacts, along with all available metadata. This information is revision-controlled and immutable (except when a change is essential for security or privacy reasons). | Varies | ||
Machine-readable SBOMWe store all provenance metadata available for all artifacts, exposing it as machine-readable SBOM files. | |||
Supply chain levels for Software Artifacts (SLSA) Level 4SLSA is led by an initial cross-organization, vendor-neutral steering group committed to improving the security ecosystem for everyone. SLSA Level 4 requires two-person review of all changes and a hermetic, reproducible build process. |
Get these features and more with the ActiveState Platform.
Our enterprise-grade platform can help streamline your Python, Perl & Tcl workflows.
97% of the Fortune 1000 companies use ActiveState
For more than 20 years, ActiveState has been making open source easier, more secure, and less risky.
Frequently Asked Questions
SQLAlchemy is a Python SQL toolkit and Object Relational Mapper (SQLAlchemy ORM) that gives application developers the full power and flexibility of SQL from the command line.
It provides a full suite of well known enterprise-level persistence patterns, designed for efficient and high-performing database access, adapted into a simple and Pythonic domain language.
SQLAlchemy is compatible with Python 2 (v2.7 and later), as well as Python 3 (v3.6 and later).
As with all Python packages installed with pip, SQLAlchemy will be installed to %PYTHONHOME%/site-packages. This will always be true for global installations of SQLAlchemy. Once installed, you can then run import sqlalchemy. If you’re using a virtual environment (like virtualenv), SQLAlchemy will be installed differently, depending (for example) on where you created the directory for your virtual environment.
Note that you will have to install an SQL database (like MySQL, Oracle or postgresql) separately.
Yes, SQLAlchemy will work Windows, Mac, and Linux (Ubuntu, CentOS, RHEL, etc.).
SQLAlchemy is commonly used to facilitate communication between Python programs and databases. Most of the time, this library is used as an Object Relational Mapper (ORM) tool that translates Python classes to tables on relational databases, and automatically converts function calls to SQL statements.
The manual way to install SQLAlchemy package is to use pip package manager to download from PyPI and install in one step. You can also install it by following the directions on the repository.