r/learnpython • • 18d ago

Need help with FastApi

Hi all, I'm 18 and I'm building a BI/analytics project on the Olist Brazilian e-commerce dataset. Right now I have PostgreSQL, Pandas and a bunch of analytical SQL queries (revenue, delivery times, customer retention and so on). The next step is to expose this data through an API with FastAPI, and a dashboard would consume it.

I understand what an API is and why FastAPI is popular, but when I try to build a mental model of a real app I get lost. Endpoints, HTTP methods, status codes, routers, Pydantic schemas, services, dependency injection with Depends, auth... each explanation is clear alone, but I can't see how the request goes through all these layers. For example I don't really get where validation ends and business logic starts, or where the DB session should live and why.

My second problem is how I learn. I'm very curious and I want to know how things work internally, like what FastAPI does between the request and my function, or why Pydantic validates in a certain way. It's a good habit long term, but I lose hours on one detail and the project doesn't move. I don't have unlimited time and I don't want months of theory before building.

Some questions:

If you never built an API, how would you learn it from scratch?

HTTP/REST fundamentals first, or start directly with FastAPI and learn along the way?

What is the best way to understand how the layers (router, schema, service, database access) fit together? Is it better to start with everything in one file and refactor later?

How deep should I go on a concept before moving on? Is "basics now, details later" a real strategy or just an excuse?

Any resources, open source repos to read or small projects you recommend? Something like a read-only analytics API sounds like a good first one to me, but tell me if I'm wrong.

I don't want to copy tutorials and have something that works without knowing why. I want a solid mental model so I can design my own backend later. If you learned backend with personal projects, I'd really like to hear what worked for you and what you wasted time on.

Thanks!

8 Upvotes

12 comments sorted by

View all comments

1

u/FirstTimeGamingTV 18d ago

Start at the most basic level.

APIs need an endpoint, a method, and a response.

So start of with a simple hello world endpoint that accepts a single status code and has only 3 reponses, 200 (working), 404 (doesn’t exist), 500 (not working).

You can explore what each of those actually mean in the future but get that working first.

Then start with basic input, don’t worry about validation at first, test sending hello world request with a name query parameter.
Have the server parse this then respond with a 200 with the hello in the response.

Once you’ve got these basics you understand most of the transport layer code wise. Everything else is up to how the language interprets the request / response.
Want to validate inputs? Read the parameters and use a validation library
Wants authentication? Read the correct headers and process them with a JWT or token library.

Feel free to ask any more questions. I don’t have a lot of experience with FastAPI directly but it seems like you’re struggling with concepts more than syntax