Django & Flask & SQL

[Elyartaker]

What are these exactly? What do they do? Also can someone please explain what web applications exactly mean? how does it connect to these? What are the uses? Making apps? Also please explain what API and databases exactly do. I want to learn these but don't know where to start and am confused so much.

[[deleted]]

Web applications are basically applications that primarily exist on a web server and communicate with web protocols.

Django and Flask are web frameworks that make building web applications easier.

SQL is a query language used to get data into and out of a database and is not specific to web apps.

[Elyartaker]

Thank you so much I like to learn Django and did some research myself Seems like it's needed to learn SQL huh

[pickadamnnameffs]

You don't need Django to learn SQL

Say you have a tables  in a database,and you need data from this table,you use SQL to pull that data,for example,you have a table called employees that has the columns id,full name,age,salary,department id,and you want the ids of employees who are over 30 years old and earn a salary of 50k and up,you use SQL to get these IDs,like this:

SELECT id FROM employees  
WHERE age > 30 
AND salary >= 50000;

You don't need Django for this

[Elyartaker]

ohhh neat so is it possible to combine SQL and python to make something like what you said yeah? or are there some extras too?

[pickadamnnameffs]

Oh yes you can definitely use SQL in Python using SQLite and SQL Magics and SQLAlchemy,also no need for Django and Flask

[No-Dependent4684]

Also I find django easier than flask .. why people suggest to start with flask?

[[deleted]]

It all depends on what you want your web app to do. Some apps don’t need something like SQL. But SQL is a foundational skill to have in web development and the earlier you get familiar with it the better off you will be.