fastapi-async-sqlalchemy VS fastapi

I, too, have encountered something similar. In my opinion, abandoning this function and such a solution, for example, solves the problem.

FastAPI

When I was building Ballistic, I chose for FastAPI as the web framework for my backend API in Python, since it had gained significant popularity in the Python community in a very short amount of time. Apart from its performance, powered by the usage of the asyncio library, I was convinced by the core integration of type annotations and the well-built documentation. Take into account that good documentation and a broad community can save you tons of time when developing your backend.

If you work with backend APIs in Python, you've probably used or heard of Pydantic, perhaps from FastAPI. The library advertises itself as "data validation and settings management using Python type annotations" and it makes (de)serialization of data a breeze.1

It's simple. Just take the hydraulic react redux emulator, and attach it to the transdimensional photon nodejs emitter. Bam! New website.

But seriously, nerds these days don't make it easy. Pretty sure they revel in the complexity. The nicest simple stack I've found is this:

1. FastAPI backend - this is almost really good for getting a simple backend running. Some downsides:

- some astonishments, bugs: [1] [2]

- it's coupled with Pydantic, which can get confusing because you end up with basically two sets of models if you use an ORM: your ORM "actual models" and then your Pydantic validation models. Just got a little confusing

- uvicorn? gunicorn? unicorn? WSGI? who?

- it's python, so you'll have to deal with cringe and blue-pilled dependency management, among other things

2. Vanilla HTML, CSS, and JS - nice thing about FastAPI is you can be flexible with how you implement the frontend. I've used it to make everything from simple SPA's using vanilla web components to traditional templated SSR sites, and mixes therein.

[1] https://github.com/tiangolo/fastapi/issues/2872

[2] https://github.com/tiangolo/fastapi/discussions/3970

Because you are already using python I'd recommend having a look at https://fastapi.tiangolo.com/. With this you can write a API that your website can use.

In this tutorial, we're building a simple application which integrates Cerbos with a FastAPI server using AWS Cognito for authentication. FastAPI provides us with the `OAuth2PasswordRequestForm` middleware, which extracts the credentials from the form on the UI, and makes them available within the `form_data` object.

NiceGUI runs on top of FastAPI which allows you to add authentication, routing, OpenAPI specs, and other backend functionality to your projects. The frontend is implemented using Vue, Quasar, and Tailwind, but you don’t need to be familiar with these technologies to create beautiful user interfaces. NiceGUI prioritizes simplicity and user-friendliness, while still offering the option for advanced customization through its extensibility.