Welcome to the FastAPI with Strawberry GraphQL, SQLModel and Postgres project! This project is designed to showcase a robust implementation of FastAPI integrated with Strawberry GraphQL, providing a seamless experience for building high-performance web applications with asynchronous capabilities.

This project demonstrates the integration of FastAPI with Strawberry GraphQL to create a modern, scalable, and efficient web application. The application includes a sample GraphQL schema with queries and mutations, database management, and a simple FastAPI endpoint. The project also includes a PostgreSQL database for storing data and SQLModel for defining database models.

• FastAPI: A modern, fast (high-performance) web framework for building APIs with Python 3.7+ based on standard Python type hints.
• Strawberry GraphQL: A new GraphQL library for Python 3, inspired by dataclasses.
• Asynchronous Database Operations: Leveraging SQLAlchemy and async/await for high-performance database interactions.
• Structured Project Layout: A well-organized project structure with separate modules for models, schemas, and routes.
• SQLModel: A library for interacting with databases using Python type hints.
• PostgreSQL Database: A PostgreSQL database for storing data with SQLAlchemy as the ORM.

• Python: The core programming language used for development.
• FastAPI: The web framework used to create the API.
• Strawberry GraphQL: The GraphQL library used for defining and serving the GraphQL schema.
• SQLAlchemy: The ORM used for database interactions.
• uvicorn: The ASGI server used for running the FastAPI application.
• PostgreSQL: The relational database used for data storage.

• Python 3.8+
• PostgreSQL
• pgAdmin4 (optional)

1. Create and activate virtual environment

python -m venv venv

cd venv/Scripts

activate

2. Install dependencies

pip install -r requirements.txt

or

pip install fastapi uvicorn sqlmodel sqlalchemy psycopg2 python-dotenv strawberry-graphql[fastapi]

3. Create a .env file in the root directory and add the following environment variables:

DATABASE_URL=postgresql://username:password@localhost/dbname

The Database can be created using the pgadmin4 or any other database management tool. The DATABASE_URL should be in the format postgresql://username:password@localhost/dbname

To run the FastAPI application, use the following command:

python main.py

The application will start running on `http://localhost:8888

To access the GraphQL Playground, navigate to `http://localhost:8888/graphql in your browser.

Here are some sample queries and mutations that you can try in the GraphQL Playground:

1. POST

   Mutation to create a new Note:

   mutation MyMutation {
     createNote(noteData: {
       name: "This is summer", 
       description: "This is the summer in 2024 and we are burning with code"
     })
   }

   

2. GET

   Query to get all Notes

   query MyQuery {
     getAll {
       description
       id
       name
     }
   }

   

3. PUT

   Update a Note:

   mutation UpdateNoteMutation {
     updateNote(
       noteData: {
         name: "This is updated", 
         description: "Description also updated"
       }
       noteId: 2
     )
   }

   

4. DELETE

   Delete a Note:

   mutation DeleteNoteMutation {
     deleteNote(noteId: 2)
   }

   

This project provides a solid foundation for building web applications with FastAPI and Strawberry GraphQL. By leveraging the power of Python's type hints and asynchronous capabilities, developers can create high-performance APIs with ease. The integration of SQLModel and PostgreSQL further enhances the application's database interactions, making it a robust solution for modern web development.

Contributions are welcome! If you have any ideas, enhancements, or bug fixes, feel free to submit a pull request.

This project is licensed under the MIT License.

I am a passionate Full Stack Developer with over 3 years of experience in web development. I specialize in creating robust and scalable web applications using modern technologies. My expertise includes FastAPI, GraphQL, PostgreSQL. I am dedicated to writing clean, maintainable code and following industry best practices.

GitHub: https://github.com/bilalmohib LinkedIn: https://www.linkedin.com/in/bilalmohib

I am always eager to take on new challenges and collaborate with innovative teams. Let's build something amazing together!