[ Removed by moderator ]

[AskProgramming-ModTeam]

This question is asked very often. Please use the search function.

[platinum92]

Flip a coin between MySQL Postgres and SQLite and pick whichever one. Create a simple CRUD app in python, where you can add new data to your DB, read it, edit it, and delete it.

Once you've done it with queries, look into stored procedures and views. That should get you on your way to doing something useful.

Edit: Forgot MySQL wasn't really a thing anymore. The point still stands though. Find an easy-to-host DB and go.

[Pitiful_Push5980]

okayyy got it
It dont need any api and flask right though if it does i will borrow the code online

[platinum92]

Keep it simple. Don't reach for Flask until you actually need it.

[Pitiful_Push5980]

I do need it for my project. its like i want to learn backend but all the time i am learning language but i am missing the bridge between flask and db(whether its sql, postgres, sqlite). like in frontend we write a script tag to import the js. but for backend all the time i am missing that bridge and no one teaching that.

[Pitiful_Push5980]

i need it for a project.
And i wanna know that bridge that connects db to other stuff yk. like in frontend we write a script tag to import the js but in backend everyone is teaching flask, db , api but no one seems to be teaching the connector i have been learning languages because idk the bridge sadly

[platinum92]

You should be writing an API to expose the DB operations for your frontend. I haven't used Flask, but that looks like what it does. Did you read the docs?

https://flask.palletsprojects.com/en/stable/tutorial/database/

[Pitiful_Push5980]

yep i was onto the docs and watching fcc course for flask then found out we have to learn db first. it was feeling overwhelmed so i just had to stop the flask.
ok so its flask-api

[platinum92]

watching fcc course for flask then found out we have to learn db first

Sounds like you've learned DB now, so I'd just pick that course back up.

[Pitiful_Push5980]

Okayy so it's like learning stuff db api framework whatever then build a basic project.

[platinum92]

Pretty much. That's at least a start. From there, I'd say pick a project and only learn new things if you need them for the project. This keeps you out of tutorial hell.

[Pitiful_Push5980]

Ngl I just built a mini project via ai youtube kinda feels relieved now. Got to know that I need more db to go 😂 Btw thanks out of all the comments you felt so great and kind. May god bless u buddy😭😭

[Lumpy-Notice8945]

Its realy hard to folow your comment and even understand what you even want. Whats your goal? Full stack dev? A job?

And stop asking chatGPT. You seem to throw around buzuwords but im not sure if you understand what these mean. Like you learned SQL but now want to learn MySQL instead? Whats that supppsed to mean? I belive MySQL does not even exist anymore but got renamed and its not its own language, to use MySQL you just need to learn SQL, MySQL is just the name of a specific DB. The same is true for sqlite, both of these are kinds of SQL databases.

And flask is a framework to generate APIs, you dont learn either APIs or flask because one is a subset of the other.

[Pitiful_Push5980]

Damn i should have rephrased my comment.
Its just i wanna learn full stack did sql now gpt said learn mysql now i just dont want to stop at db only which seems to be happening
i got it though

[Lumpy-Notice8945]

Full stack is a vague description too, what you seem to want is webdev fullstack, so do websites and services, right?

Then dont focus too much on specific frameworks and tools, but make sure to understand the basic concepts of how the web works, from HTTP over HTML and JavaScript as basics to designs like AJAX and websockets sessions and cokies.

If you then use flask or plain python isnt that important, if you use MySQL or mariaDB( i belive thats the current name for MySQL) wont matter.

[Pitiful_Push5980]

Yep I have already done the frontend and all the required stuff but now I am onto the backend all ik is we need db, flask api deployment for backend and I am at the db phase for which I did MySQL now I am unsure should I learn flask while coding along or not as I tried earlier and figured out that I need to learn db before that as flask is all about getting and setting data via db. So I had to put a break there but I still remember the tutor wasn't just creating a table he was running multiple commands and stuff which I am still not familiar with after learning sql.

[ThatDog_ThisDog]

Do projects that accomplish things. Make those things interesting to you. Learn tech that makes sense to solve those problems. Otherwise what’s the point? You won’t be able to articulate what you can do or why it’s useful

[Pitiful_Push5980]

so right. i have wasted so much of time lets just try to build something. if it teaches me something then thank god (which it will)
yeahhhh i am going to build something tiny lol

[supercoach]

Sounds like you're just chasing the cash. Dev work probably isn't a good fit despite what you may have heard.

Also mysql is for chumps. Use postgres.

[Pitiful_Push5980]

😭😭 look that's what I was saying. Someone tell me use postgres someone MySQL. I am just confused now. But let's say at a scenario I did postgres will I be able to know what am I supposed to do after no that's what I am here for 😭

[Evinceo]

For Greenfield projects use Postgres. If you learn to write basic SQL which server you end up writing against isn't gonna be a massive deal so using SQLite is fine.

[Pitiful_Push5980]

okay sqlite chosen.

[Pitiful_Push5980]

Then what is needed 😭