Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

Create a Python Application to connect to multiple databases


Creating the application user interface :
Introduction
What is CRUD
What we will create
Application Design Sketch
Install Python on Windows
Install Python3 on Mac
Install Atom Text Editor
Create project directory and Python File
Creating the GUI : Part 1
Creating the GUI : Part 2
Creating the GUI : Part 3
Creating the GUI : Part 4
Creating the GUI : Part 5
Add comments to your code

Setting Up Microsoft SQL Server Database :
Installing SQL Server 2017 Express
The Source Code
Create a new database and table
Create a database configuration file
Create a virtual environment and install pypyodbc
Connect Python File to database
Create a cursor object
Create a class and methods
Add more methods
Create a function for selected rows
Create more functions
Activate button widgets
Interacting with database from Python Application GUI - Part 1
Interacting with database from Python Application GUI - Part 2

Setting Up MySQL Database Server :
Installing MySQL
MySQL Workbench
Create a database and a table
Create a configuration connection file
Install Mysql -Connector in a virtual environment
Modfify Python Application File to connect to Mysql Database
Test connection to MySQL Database from Python App GUI
Interacting with MySQL database from Python Application GUI - Part 1
Interacting with MySQL database from Python Application GUI - Part 2
The Source Code

Setting Up PostgreSQL Database Server :
Installing PostgreSQL
Create a database and a table
Create a sequence for the id column
Create a configuration connection file
Install Pyscopg2 inside a virtual environment
Modfify Python Application File to connect to PostgreSQL Database
Test connection to PostgreSQL Database from Python App GUI
Interacting with PostgreSQL database from Python Application GUI - Part 1
Interacting with PostgreSQL database from Python Application GUI - Part 2
The Source Code

Setting Up Oracle Database Server :
Download and Install Oracle Database 18c Express Edition
What is SQLPLUS
Unlock sample HR Schema Account
Install Oracle SQL Developer
Create a new database table
Connect Oracle developer to Oracle database
Installing Oracle database driver in a virtual environment
Modfify Python Application File to connect to Oracle Database
Interacting with Oracle database from Python Application GUI
The Source Code

Setting Up SQLite3 Database :
Installing SQLite
Modfify Python Application File to connect to SQLite3 Database
Test connection to SQLite3 Database from Python App GUI
Interacting with SQLite3 database from Python Application GUI
SQLiteStudio
DB Browser for SQLite
Viewing SQlite3 Database Records
The Source Code