The Beginner’s Guide to Learn Python GUI with PostgreSQL and SQLite

Vivian Siahaan, Rismon Hasiholan Sianipar

Summary

This book explains relational theory in practice, and demonstrates through two projects how you can apply it to your use of PostgreSQL and SQLite databases. This book covers the important requirements of teaching databases with a practical and progressive perspective. This book offers the straightforward, practical answers you need to help you do your job. This hands-on tutorial/reference/guide to PostgreSQL and SQLite is not only perfect for students and beginners, but it also works for experienced developers who aren't getting the most from both databases. In designing a GUI and as an IDE, you will make use Qt Designer. 
In the first chapter, you will learn to use several widgets in PyQt5: Display a welcome message; Use the Radio Button widget; Grouping radio buttons; Displays options in the form of a check box; and Display two groups of check boxes. 
In chapter two, you will learn to use the following topics: Using Signal / Slot Editor; Copy and place text from one Line Edit widget to another; Convert data types and make a simple calculator; Use the Spin Box widget; Use scrollbars and sliders; Using the Widget List; Select a number of list items from one Widget List and display them on another Widget List widget; Add items to the Widget List; Perform operations on the Widget List; Use the Combo Box widget; Displays data selected by the user from the Calendar Widget; Creating a hotel reservation application; and Display tabular data using Table Widgets. 
In chapter three, you will learn: How to create the initial three tables project in the School database: Teacher, Class, and Subject tables; How to create database configuration files; How to create a Python GUI for inserting and editing tables; How to create a Python GUI to join and query the three tables. 
In chapter four, you will learn how to: Create a main form to connect all forms; Create a project will add three more tables to the school database: Student, Parent, and Tuition tables; Create a Python GUI for inserting and editing tables; Create a Python GUI to join and query over the three tables. 
In chapter five, you will join the six classes, Teacher, TClass, Subject, Student, Parent, and Tuition and make queries over those tables. 
In chapter six and chapter seven, 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 chapter eight, 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 nine, 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.

Available since: 01/31/2020.

Science & Technology

Other books that might interest you

Airplane Flying Handbook...

Federal Aviation Administration

From the preface: "The Airplane Flying Handbook is designed as a technical manual to introduce basic pilot skills and knowledge that are essential for piloting airplanes. It provides information on transition to other airplanes and the operation of various airplane systems. It is developed by the Flight Standards Service, Airman Testing Standards Branch, in cooperation with various aviation educators and industry. This handbook is developed to assist student pilots learning to fly airplanes. It is also beneficial to pilots who wish to improve their flying proficiency and aeronautical knowledge, those pilots preparing for additional certificates or ratings, and flight instructors engaged in the instruction of both student and certificated pilots. It introduces the future pilot to the realm of flight and provides information and guidance in the performance of procedures and maneuvers required for pilot certification."

Show book

Beekeeping - Honey Guide for...

Alex Warner

Starting as a beekeeper? Then read this first! If you are a beginner at keeping bees, or you are thinking about it, then you need the right knowledge. Without it, you’ll get stung, fail to set it all up, or won’t know what to do with all those swarming, chaotic little creatures. That’s why you can check out this manual. It teaches you, among others: The right equipment to get started. The treatment for bee stings. Raising your own bees and dealing with the queen bee. Where to find colonies and which places are best. Tips about water, smoke, and escape paths. And much more! If you are a beginner, and you are excited about the bee business, then be(e) courageous and get this book as soon as possible. You won’t regret it.

Show book

Coronavirus - Consequences and...

David Rogue

This is a combo of 3 books in 1. Enjoy! The titles concern the following topics:
Book 1 - With the world watching the news each day about the infamous COVID-19 Virus, a version of what is more broadly classified as a "Coronavirus," like SARS, it's hard to ignore the facts and the opinions as many economies are being put on hold, stocks are plummeting, businesses are applying for loans, and everyone is encouraged to stay at home.
Book 2 - Being stuck at home can be annoying. I watched as my in-laws were eager to hug our children but didn't, just because they wanted to abide by the rules the president of the United States and many other international leaders have set. Some people say they lost their jobs. Others report being sick of one another, not of the virus. Fortunately, I live in a nice-enough home, but I can't imagine how hard it is for some people who live in a small apartment, like the ones I've seen in Tokyo.
This book shows you some things you should or should not do during the time of being quarantined because of an epidemic or pandemic.
Book 3 - We don't know everything about the Coronavirus yet (or COVID-19, which is the more accurate name). Many reports have suggested that it may have originated from the bat soup the inhabitants of the Chinese Wuhan province drink or drank on a regular basis, since bats, like rats, are often carriers of numerous diseases. Others refer to some kind of conspiracy with a testing center and selling animals on the market there. Whatever the origin, there are certain things that we know about the health side and certain things that we don't. Stay tuned, because we will dive into the many controversial and informational sources I have acquired right now.

Show book

And Miles to Go Before I Sleep -...

Hugh Cran

After three years working as a young vet in rural Aberdeenshire, Hugh Cran decided that it was time for a change. He got it. He took a post in Kenya and, forty years later, he's still there, still working, still loving every exasperating, challenging, unexpected moment.
This is a page-turning account of working as a vet at the sharp end.
Cattle owned by the Maasai herdsmen or the white settlers might take up most of Hugh's time, but these cattle are assailed by lightning strike, snake bites, disease passed on by zebra and wildebeest. He's up against sun cancer, witch doctors - who knows what to expect next?
Travelling miles on rough roads, Hugh never knows if he will be performing surgery on dirty sacks, besieged by every species of Kenyan insect, by the light of a failing car-headlamp!
But the colourful people who frequent Hugh's Nukuru practice, the sheer vitality of the Kenyan scene and the rewarding nature of the grinding task in hand, keep him answering that persistent phone, day and night, and heading off into the unknown.

Show book

Technology Management

IntroBooks Team

In a world that is completely dependent on technology, how can big businesses, organizations, enterprises and sectors stay behind? The need for technology is increasing day by day and hence there are so many organizations that are focusing on innovation and creation to make their name big in the market. Technology is the key to the success of any organization and hence more and more technologies are being incorporated into many different companies. The need for technology is increasing which is the reason why the need for its management is also increasing. 
Technology management is a concept that is gaining a lot of popularity because it is needed in abundance by various big organizations. It is process and art of handling all the technologies of an organization and making sure that they are in the right use and are absolutely safe. A technology manager has the right and sound knowledge for each and every aspect when it comes to technology and also when it comes to management. Technology management is the trendiest occupation out there and its need will never end till the time we are dependent on technology.

Show book

Negro Ironworkers of Louisiana...

Marcus Christian

Historian and journalist Marcus Christian reveals how African Americans were the true artists behind New Orleans’ classic iron architecture.   When people think of New Orleans, they envision the complex ironwork of balcony railings in the French Quarter or the delicate lacelike gates of the city’s cemeteries. It is the city’s florid ironwork that gives New Orleans its unmatched, memorable beauty. But few people realize that most of this ironwork was created in the antebellum South—the golden age of Southern culture—by black slaves.  Negro Ironworkers of Louisiana, 1718–1900 examines the history of African American ironworkers in Louisiana. It is the first in-depth study of the sophisticated blacksmith skills for which most Negro ironworkers were not appreciated. Marcus Christian examines the development of agricultural and metallurgical technology in Africa, the slaves who brought those technologies to the United States, and the ironworkers’ roles in the making of New Orleans.

Show book