Why You SHOULDN'T Be Writing Raw SQL In 2023
SQL is great, but it's been around FOREVER, and just as database technology has come a long way, so have a lot of our options for interacting with it.
In this video, we explore the pros and cons of writing raw SQL, using a SQL query builder, or using an ORM.
Check out the code:
https://github.com/isaacharrisholt/yo...
Resources:
SQLite3: https://docs.python.org/3/library/sql...
PyPika: https://pypika.readthedocs.io/en/latest/
SQLAlchemy: https://www.sqlalchemy.org/
SQLModel: https://sqlmodel.tiangolo.com/
__________________________________________
Check out my other socials!
🐦 Twitter ▶ / isaacharrisholt
🖥️ Portfolio ▶ https://ihh.dev
📝 Blog ▶ https://isaacharrisholt.com
__________________________________________
Timestamps:
00:00 - Introduction and explanation
00:28 - Raw SQL
02:24 - Query builders
03:45 - ORMs
06:32 - Wrapping up
#python #softwareengineer #sql #database