{"id":49687,"date":"2024-12-04T07:03:14","date_gmt":"2024-12-04T07:03:14","guid":{"rendered":"https:\/\/accuweb.cloud\/resource\/?post_type=faq&p=49687"},"modified":"2026-02-17T13:40:15","modified_gmt":"2026-02-17T13:40:15","slug":"fastapi-with-relational-database-on-ubuntu","status":"publish","type":"faq","link":"https:\/\/accuweb.cloud\/resource\/articles\/fastapi-with-relational-database-on-ubuntu","title":{"rendered":"How to use FastAPI with a Relational Database on Ubuntu OS?"},"content":{"rendered":"

How to Use FastAPI with a Relational Database on Ubuntu on AccuWeb.Cloud?<\/h2>\n

FastAPI is a powerful and highly performant Python<\/a> web framework for creating APIs. With PostgreSQL and Fastapi, developers can create high-effectiveness web applications with a light structure. In this tutorial, we will guide you through setting up a FastAPI, connecting it to a PostgreSQL database<\/a>, and deploying it on a Ubuntu server, hosted on AccuWeb.Cloud.<\/p>\n

\"FastAPI<\/a><\/p>\n

Introduction to FastAPI<\/h3>\n

FastAPI is a Python-based framework designed to build APIs quickly with minimal effort. It is built on Starlette (for web parts) and Pydantic (for data validation), allowing developers to use modern Python objects such as type hints, asynchronous programming, and automatic documentation generation.
\nOne of FastAPI’s key advantages is its speed. By benchmarks, FastAPI is one of the fastest web tools available. It tends to perform better than frameworks like Flask and Django in terms of performance<\/a>. Another important benefit is the automatic generation of OpenAPI documentation, which makes it easier for developers to test and interact with APIs during development.<\/p>\n

Setting Up an Ubuntu Server on AccuWeb.Cloud<\/h3>\n

Step 1:<\/b> Log in to your AccuWeb.Cloud dashboard<\/b> and create a new virtual private server (VPS).<\/p>\n

\"Create<\/a>Step 2:<\/b>Select Ubuntu 20.04<\/b> or the latest version as your operating system and database<\/a> server as a PostgreSQL<\/b>.
\n<\/b><\/p>\n

Step 3: <\/b>Choose the appropriate resources for your server based on your needs and enter the environment name.
\n<\/b><\/p>\n

Step 4: <\/b>After configuring the server, click on the Create<\/b> button.<\/p>\n

\"Configuring<\/a><\/p>\n

Accessing the Server via Web SSH<\/h3>\n

AccuWeb.Cloud offers a convenient Web SSH feature. You don’t need a terminal application<\/a> on your computer for SSH access. After your server is created, you’ll see the option to access your server via Web SSH<\/b> in your AccuWeb.Cloud dashboard. Click on the Web SSH<\/b> button.
\nYou are now logged in to your Ubuntu server.<\/p>\n

\"Web<\/a><\/p>\n

Installing Necessary Software on Ubuntu<\/h3>\n

Now that you have access to the Ubuntu server, it’s time to install the necessary software for our FastAPI project.<\/p>\n

Updating Ubuntu<\/h4>\n

First, update your system to ensure all existing software packages are up to date. Run the following commands:<\/p>\n

sudo apt update && sudo apt upgrade -y<\/b><\/code><\/pre>\n
\"Updating<\/a><\/h4>\n
Installing Python 3, pip, and Virtual Environment<\/h4>\n
FastAPI requires Python 3. Install it along with pip (Python’s package manager) and the virtual env tool to create isolated environments for your Python<\/a> applications:<\/p>\n
sudo apt install python3 python3-pip python3-venv -y --fix-missing<\/b><\/code><\/pre>\n
\"Installing<\/a><\/h4>\n
Install Dependencies for FastAPI<\/h4>\n
<\/div>\n\t\t
\n\t\t\t        
\n            \n                        
\n                    
\n        
\n                    \n        \t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t            <\/div>\n        <\/div>\n                    <\/div>\n        <\/section>\n        \t\t<\/div>\n\t\t\n
<\/div>\n
Next, install FastAPI and Uvicorn, which is the ASGI server required to run FastAPI applications:<\/p>\n
pip install fastapi uvicorn<\/b><\/code><\/pre>\n
\"Install<\/a><\/p>\n
To connect to PostgreSQL, you’ll also need the psycopg2 library:<\/p>\n
pip install psycopg2<\/b><\/code><\/pre>\n
Setting Up PostgreSQL Database<\/h3>\n
To interact with the database, we’ll need to create a new database and user in PostgreSQL. You should receive the PostgreSQL Database<\/a> login details in the email.
\nStep 1:<\/b> Log in with your PostgreSQL username<\/b> and password<\/b>.
\n<\/b><\/p>\n
\"Log<\/a><\/p>\n
Step 2:<\/b> On the left-hand side, click on the PostgreSQL server where you want to create the database.
\n<\/b><\/p>\n
\"PostgreSQL<\/a><\/p>\n
Step 3:<\/b> At the bottom of the phpPgAdmin interface, click on the “Create Database<\/strong>” link.
\n<\/b><\/p>\n
\"Create<\/a><\/p>\n
Step 4:<\/b> Fill in Database Details:<\/p>\n