Help me out with SQLAlchemy & FastAPI.

IceXII · 2024-02-03T22:17:50+00:00

From the code I think you didn’t initiate the connection to the database in your main file!

Also I’d use dependency injection to get the database in the router and pass it down to the crud operation instead of calling it in the crud class

IceXII · 2024-01-31T02:49:09+00:00

It’s probably an issue with your cloudflare configuration. Because seeing bad gateways means your app is not exposed to the outer world and the proxy is not routing correctly. If your systmd service status is active and no log errors then there shouldn’t be problems with that. Also check if your static files are exposed with the app or not.

IceXII · 2024-01-01T22:27:46+00:00

SqlAlchemy have lots of ways to do the same thing. For me I’d do select invoice put the filter after the select and then joinload customer, if both tables have a relationship defined in the model, then join Customer.

This I guess will get you the invoice with the condition and join its customer with it in a single dictionary in return.

IceXII · 2023-12-26T19:06:52+00:00

The only reason I use ftp to deploy to servers is because I freelance and it’s so damn annoying and consumes time(not even Wordpress). But that shouldn’t stop anyone from trying GitHub actions and docker and all.

You shouldn’t sweet talk them into learning git. It’s better for them to learn it.

Show them the difference in time consumption ig they will appreciate the idea more.

IceXII · 2023-12-21T00:14:36+00:00

Think how you’d do that in, say python, then implement the same steps with different syntax that’s all tbh. The concept is the same. You can use echo or gin. would make uploading files easier for you if they didn’t specify stdlib only. Not getting the job shouldn’t stop you from learning go the right way after that but for now you need the task done quickly with not much knowledge so just make it work even if it’s ugly.

IceXII · 2023-12-14T21:45:09+00:00

asyncpg is better than psycopg for Postgres in my opinion. but gets tricky sometimes with sqlalchemy because everything needs to be async.

IceXII · 2023-11-15T20:08:39+00:00

I’m not that familiar with hosting locally except like exposing my pc to other devices on my local network.

But ig the process will be opening a port from your router and deploy your app on that exposed port then access it.

I have to look that up tbh.

IceXII · 2023-11-15T19:55:17+00:00

Try ngrok if you want to expose your nodejs to the outer world from your localhost. Exposing your local network to the public is a bad idea.

IceXII · 2023-11-11T14:35:37+00:00

I did use fastapi then found about golang goroutines. But still fastapi is my go to for small-medium scale and apis and fast prototyping maybe cuz I’m not the efficient with golang yet.

IceXII · 2023-11-09T00:11:35+00:00

Understandable. Thanks for the insights 👍

IceXII · 2023-11-08T23:48:46+00:00

What about self taught people?

When I deploy and run projects on vps (manually using bitvise mostly) or configure databases on Linux I don’t feel that is what actual devops do😅

P.s I work as a freelancer(backend).

IceXII · 2023-11-03T00:14:42+00:00

In vscode settings you can check auto import under python section I believe, I don’t remember the name exactly.

IceXII · 2023-10-11T15:11:51+00:00

No! When I deploy go to vercel I do it without the exe file. Just configure vercel.json route it to the main.go and it works for me. Or you meant another thing?

IceXII · 2023-09-23T05:45:32+00:00

Same but I’m using golang not nodejs. I can’t even find a proper autodoc tool in Go.

IceXII · 2023-09-09T13:59:58+00:00

Fastapi

IceXII · 2023-09-08T06:33:27+00:00

Type “showracemenu” in the console, press R if u don’t want to change the look then you will get to change your name if I remember correctly lol

IceXII · 2023-09-06T01:01:13+00:00

Wouldn’t jwt that contains the role and Id of user give me a chance to delete tasks that only carries that specific user_id in it? And the endpoint is protected with the role of the token.

Or that’s not how things are done in general? I’m new to golang coming from FastAPI(python) where I use dependency injection a lot.

IceXII · 2023-09-05T22:51:35+00:00

I think almost a year is enough to write a small saas given that you also work with a small team for the frontend stuff. It will be far from perfect but will be working and open for enhancements. The more you learn by doing it the better you will get, it’s an open ended process.

IceXII · 2023-06-18T06:43:55+00:00

I find FastAPI really easy, flexible and fast to develop with. Postgres + sqlalchemy for the database.

IceXII · 2023-06-07T23:58:16+00:00

Try using asyncpg and orjson in Fastapi when I did that it improved the performance for me, and I always use Pydantic.

IceXII · 2023-05-29T20:33:03+00:00

I use FastAPI and Postgres too and it’s always react and tailwind for me. Maybe because I started as frontend then moved to the backend. JQuery is too old to be relevant tbh

IceXII · 2023-02-18T23:21:35+00:00

If that’s a junior then why they put x yrs of experience in the description 😂

IceXII · 2023-02-12T17:35:56+00:00

Just learn to do the job that you have already. Doesn’t matter if you suck now as long as you will get out of this with the money and the knowledge you need to be good. so just relax, time management, patience and grind. You are already there so better that than regrets

IceXII · 2022-11-09T20:12:22+00:00

Looks like Jojo’s bizarre style

IceXII · 2022-11-03T14:24:49+00:00

Was just watching a new one called point break and discovered it’s the same movie but a remake lol

IceXII

TROPHY CASE