This Python Library needs to get more attention 🙏
#MySQL #Postgres #Sqlite3
Learn how to Connect your Python applications EASILY to any one of these popular databases.
In this video, I show a basic example of this amazing library to easily connect to databases with your Python code. The video starts by explaining what ORM is, and then we dive into how to create an sqlite3 instance, and also we test the same code with PostgreSQL and MySQL by creating containers and connect our application to these databases.
Timeline of the video:
What is ORM - 00:00 - 01:50
01:51 - 05:08 - Write our First Model with Sqlite3
05:09 - 07:00 - Create Sqlite3 from Python Shell
07:01 - 08:30 - Important commands in peewee (And functions)
08:31 - 10:23 - What to do when managing multiple models ?
10:24 - 18:59 - Postgresql Connection and testing with PgAdmin
19:29 - 19:30 - MySQL Connection and testing
Related tutorials:
🟤 Docker getting started:
• Docker in 40 minutes (Includes Hands-on)
Important links:
🔴 MySQL
MySQL viewer I recommend: https://dev.mysql.com/downloads/workb...
OR
https://www.jetbrains.com/datagrip/do...
🔴 Sqlite3 Viewer:
https://sqlitebrowser.org/
🔴 Postgresql Viewer
PGAdmin: https://www.pgadmin.org/download/
Code Snippets repo for grabbing the code and the commands I ran:
https://github.com/jimdevops19/codesn...