Building Two Desktop Applications Using Python Gui And Postg…

Building Two Desktop Applications Using Python Gui And Postg...

In this book, you will create two desktop applications using Python GUI and PostgreSQL. This book is a Python/PostgreSQL version of the Python/MySQL book which was written by the author. What underlies the writing of this book is the growing popularity of the PostgreSQL database server lately and more and more programmers migrating from MySQL to PostgreSQL. In this book, you will learn to build a school database project, step by step. A number of widgets from PyQt will be used for the user interface.

In the first and second chapter, you will get introduction of postgresql. And then, you will learn querying data from the postgresql using Python including establishing a database connection, creating a statement object, executing the query, processing the resultset object, querying data using a statement that returns multiple rows, querying data using a statement that has parameters, inserting data into a table using Python, updating data in postgresql database using Python, calling postgresql stored function using Python, deleting data from a postgresql table using Python, and postgresql Python transaction.

In the fourth chapter, you will study: Creating the initial three table in the School database project: Teacher table, Class table, and Subject table; Creating database configuration files; Creating a Python GUI for viewing and navigating the contents of each table. Creating a Python GUI for inserting and editing tables; and Creating a Python GUI to merge and query the three tables.

In chapter five, you will learn: Creating the main form to connect all forms; Creating a project that will add three more tables to the school database: the Student table, the Parent table, and the Tuition table; Creating a Python GUI to view and navigate the contents of each table; Creating a Python GUI for editing, inserting, and deleting records in each table; Create a Python GUI to merge and query the three tables and all six tables.

In chapter six, you will create dan configure PotgreSQL database. In this chapter, you will create Suspect table in crime database. This table has eleven columns: suspect_id (primary key), suspect_name, birth_date, case_date, report_date, suspect_ status, arrest_date, mother_name, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for this table.

In chapter seven, you will create a table with the name Feature_Extraction, which has eight columns: feature_id (primary key), suspect_id (foreign key), feature1, feature2, feature3, feature4, feature5, and feature6. The six fields (except keys) will have a VARCHAR data type (200). You will also create GUI to display, edit, insert, and delete for this table.

Download Now Read Online


Here is Download Link

Building Two Desktop Applications Using Python Gui And Postgresql


Building Two Desktop Applications Using Python Gui And Postgresql Download Now Read Online

Author by : Vivian Siahaan
Languange Used : en
Release Date : 2019-11-07
Publisher by : SPARTA PUBLISHING






Building Two Desktop Applications Using Python Gui And Mariadb


Building Two Desktop Applications Using Python Gui And Mariadb Download Now Read Online

Author by : Vivian Siahaan
Languange Used : en
Release Date : 2019-11-06
Publisher by : SPARTA PUBLISHING






Building Three Desktop Applications Using Java Gui And Postgresql


Building Three Desktop Applications Using Java Gui And Postgresql Download Now Read Online

Author by : Vivian Siahaan
Languange Used : en
Release Date : 2019-11-08
Publisher by : SPARTA PUBLISHING






Building Three Desktop Applications Using Java Gui And Mysql


Building Three Desktop Applications Using Java Gui And Mysql Download Now Read Online

Author by : Vivian Siahaan
Languange Used : en
Release Date : 2019-11-07
Publisher by : SPARTA PUBLISHING






Building Three Java Gui Applications Using Mysql Mariadb And Postgresql


Building Three Java Gui Applications Using Mysql Mariadb And Postgresql Download Now Read Online

Author by : Vivian Siahaan
Languange Used : en
Release Date : 2019-11-09
Publisher by : SPARTA PUBLISHING






Java Gui With Postgresql A Practical Approach To Build Database Project For Students And Programmers


Java Gui With Postgresql A Practical Approach To Build Database Project For Students And Programmers Download Now Read Online

Author by : Vivian Siahaan
Languange Used : en
Release Date : 2019-08-21
Publisher by : SPARTA PUBLISHING






Mariadb And Postgresql Crash Course


Mariadb And Postgresql Crash Course Download Now Read Online

Author by : Vivian Siahaan
Languange Used : en
Release Date : 2019-11-13
Publisher by : SPARTA PUBLISHING






Learn Jdbc The Hard Way A Hands On Guide To Postgresql And Sql Server Driven Programming


Learn Jdbc The Hard Way A Hands On Guide To Postgresql And Sql Server Driven Programming Download Now Read Online

Author by : Vivian Siahaan
Languange Used : en
Release Date : 2019-11-23
Publisher by : SPARTA PUBLISHING






Building Android Apps In Python Using Kivy With Android Studio


Building Android Apps In Python Using Kivy With Android Studio Download Now Read Online

Author by : Ahmed Fawzy Mohamed Gad
Languange Used : en
Release Date : 2019-10-14
Publisher by : Apress






Python Gui With Mysql A Step By Step Guide To Database Programming


Python Gui With Mysql A Step By Step Guide To Database Programming Download Now Read Online

Author by : Vivian Siahaan
Languange Used : en
Release Date : 2019-08-13
Publisher by : SPARTA PUBLISHING






Leave a Reply

Your email address will not be published. Required fields are marked *