Skip to content

In this article, I'll provide you with a simple and straightforward guide on how you can build a CRUD app with FastAPI and SQLAlchemy. The FastAPI app will run on a Starlette web server, use Pydantic for data validation, and store data in an SQLite database.

wpcodevo/fastapi_sqlalchemy

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

12 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Build a CRUD App with FastAPI and SQLAlchemy

In this article, I'll provide you with a simple and straightforward guide on how you can build a CRUD app with FastAPI and SQLAlchemy. The FastAPI app will run on a Starlette web server, use Pydantic for data validation, and store data in an SQLite database.

Build a CRUD App with FastAPI and SQLAlchemy

Topics Covered

  • Run the SQLAlchemy FastAPI App Locally
  • Run the Frontend App Locally
  • Setup FastAPI and Run the HTTP Server
  • Designing the CRUD API
  • Setup SQLAlchemy with SQLite
  • Setup SQLAlchemy with PostgreSQL
  • Create Database Model with SQLAlchemy
    • Database Model for SQLite Database
    • Database Model for Postgres Database
  • Create Validation Schemas with Pydantic
  • Define the Path Operation Functions
    • Get All Records
    • Create a Record
    • Update a Record
    • Retrieve a Single Record
    • Delete a Single Record
  • Connect the API Router to the App

Read the entire article here: https://codevoweb.com/build-a-crud-app-with-fastapi-and-sqlalchemy

About

In this article, I'll provide you with a simple and straightforward guide on how you can build a CRUD app with FastAPI and SQLAlchemy. The FastAPI app will run on a Starlette web server, use Pydantic for data validation, and store data in an SQLite database.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published