SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that is used as flexible database access using SQL. In this article, we will look into the process of installing SQLAlchemy on a windows machine.
Pre-requisites:
The only thing that you need for installing Numpy on Windows are:
Installing SQLAlchemy on Linux using Conda:
If you want the installation to be done through conda, you can use the below command:
conda install -c anaconda sqlalchemy
Type in “y” for yes when prompted.
You will get a similar message once the installation is complete
Make sure you follow the best practices for installation using conda as:
- Use an environment for installation rather than in the base environment using the below command:
conda create -n my-env conda activate my-env
Note: If your preferred method of installation is conda-forge, use the below command:
conda config --env --add channels conda-forge
Verifying SQLAlchemy Installation on Linux using Conda:
Use the below command to verify if the above package has successfully installed:
conda list sqlalchemy
You will get a similar message as shown below if the installation has been successful:
Installing SQLAlchemy on Linux using PIP:
Users who prefer to use pip can use the below command to install the package:
pip install sqlalchemy
You will get a similar message once the installation is complete:
It is a good programming practice to install packages in a virtual environment rather than installing them globally. PIP users can use the below command to create a virtual environment:
python3 -m venv my-env
Activate the virtual environment (ie, my-env) using the below command:
source my-env/bin/activate
Verifying SQLAlchemy Installation on Linux using PIP:
Use the below command to check if the package has been successfully installed:
python3 -m pip show sqlalchemy
You will get a similar message as shown below if the installation is successful: