#FASTAPI #CURD #SQLite #ORM #SQLALCHEMY #REST #API #PYTHON #AmTechLearner

In this video, you will learn how to implement CRUD(Create, Read, Update, Delete) Operation using FAST API. I have used SQLite database with ORM(Object Relation Mapper) SQLAlchemy.
----------------------------------------------------------------------------------
check_same_thread:
it means whether you want to run it on a single thread or multi-thread. By default, check_same_thread is True and only the creating thread may use the connection. If set False, the returned connection may be shared across multiple threads

---------------------------------------------------------------------------------
model vs schema:
A data model in a database should be relational which means it is described by tables. The data describes how the data is stored and organized. A data model may belong to one or more schemas, usually, it just belongs to one schema

A schema is a collection of database objects that are logically grouped together. These can be anything, tables, views, stored procedure etc. Schemas are typically used to logically group objects in a database.
-------------------------------------------------------------------------------

[hackwithharsha]

Thank You Mate, I am waiting for this one.. I will get back to you in case of any doubts..

[jnana]

Thanks for uploading this video..Can you please let if I want to insert records into an exisisting table in Postgres what changes should I make from your code?

[hackwithharsha]

Thank You a lot for creating FastAPI content, If you have time please clarify following three questions..

1. 00:03:13 - what is that check_same_thread as false argument to create_engine function and autoFlush=False for SessionMaker class ?
2. 00:08:07 - Please make a separate video on ORM mode. thank you !!
3. What is the difference between models.py and schema.py file ?
4. Sorry if it's Dumb question, will my tables recreated whenever I restart application ? or ORM will take care of creating or updating them only if there is some modifications to ORM base model ?

00:17:18 - Just a recommendation, 404 would be right status code if the record doesn't exist.