gooddata-python-sdk VS fastapi

Our product contains a Headless BI engine where you can connect any application, data platform, or visualization tool to the engine’s semantic layer and consume the same consistent analytics anywhere. Connecting to a semantic layer with the help of GoodData Python libraries is very straightforward! GoodData Pandas allows creating pandas series and data frames from the computations done against a semantic model in GoodData.CN. As mentioned above, imagine you have a database with many tables, and you want to get a data frame consisting of columns from various joined tables. Usually, you have to do many joins manually in SQL before getting the desired data frame in Pandas. But if you connect the database to GoodData.CN, you can forget joins — with the help of a semantic model and GoodData Pandas, you will get your desired data frame with much less hassle. Just for demonstration, compare the two following code snippets. The first one is just pure pandas:

To follow this article, you can download GoodData Python SDK, which contains a docker-compose file, and run the following command in the root folder:

He is probably most well know for creating FastAPI that I taught to some of my clients and Typer that I've never used.

It has been an interesting exercise developing this wrapper component. The fact that it seamlessly integrates with the FastAPI framework is just a bonus for me; I didn't plan for it since I hadn't learned FastAPI at the time. I hope you find this post useful. Thank you for reading, and stay safe as always.

FastAPI is a modern, high-performance web framework for building APIs with Python, based on standard Python type hints.

In this tutorial, I will demonstrate how to use Burr, an open source framework (disclosure: I helped create it), using simple OpenAI client calls to GPT4, and FastAPI to create a custom email assistant agent. We’ll describe the challenge one faces and then how you can solve for them. For the application frontend we provide a reference implementation but won’t dive into details for it.

That’s when I found FastAPI.

FastAPI & Uvicorn

Discussion at FastAPI GitHub: https://github.com/tiangolo/fastapi/issues/2696

An API application framework (such as FastAPI)

It’s been my experience that async Python frameworks tend to turn IO bound problems into CPU bound problems with a high enough request rate, because due to their nature they act as unbounded queues.

This ends up made worse if you’re using sync routes.

If you’re constrained on a resource such as a database connection pool, your framework will continue to pull http requests off the wire that a sane client will cancel and retry due to timeouts because it takes too long to get a connection out of the pool. Since there isn’t a straightforward way to cancel the execution of a route handler in every Python http framework I’ve seen exhibit this problem, the problem quickly snowballs.

This is an issue with fastapi, too- https://github.com/tiangolo/fastapi/issues/5759

Fast API.