Join us on a literary world trip!
Add this book to bookshelf
Grey
Write a new comment Default profile 50px
Grey
Subscribe to read the full book or read the first pages for free!
All characters reduced
A Progressive Tutorial To Database Programming With Python Gui And Postgresql - cover

We are sorry! The publisher (or author) gave us the instruction to take down this book from our catalog. But please don't worry, you still have more than 500,000 other books you can enjoy!

A Progressive Tutorial To Database Programming With Python Gui And Postgresql

Vivian Siahaan, Rismon Hasiholan Sianipar

Publisher: SPARTA PUBLISHING

  • 0
  • 0
  • 0

Summary

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. 
In chapter eight, you will create two tables, Police and Investigator. The Police table has six columns: police_id (primary key), province, city, address, telephone, and photo. The Investigator table has eight columns: investigator_id (primary key), investigator_name, rank, birth_date, gender, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for both tables. 
In chapter nine, you will create two tables, Victim and Case_File. The Victim table has nine columns: victim_id (primary key), victim_name, crime_type, birth_date, crime_date, gender, address, telephone, and photo. The Case_File table has seven columns: case_file_id (primary key), suspect_id (foreign key), police_id (foreign key), investigator_id (foreign key), victim_id (foreign key), status, and description. You will create GUI to display, edit, insert, and delete for both tables as well.
Available since: 01/31/2020.

Other books that might interest you

  • Kingpin - How One Hacker Took Over the Billion-Dollar Cybercrime Underground - cover

    Kingpin - How One Hacker Took...

    Kevin Poulsen

    • 0
    • 0
    • 0
    The word spread through the hacking underground like some unstoppable new virus: Someone-some brilliant, audacious crook-had just staged a hostile takeover of an online criminal network that siphoned billions of dollars from the U.S. economy. The FBI rushed to launch an ambitious undercover operation aimed at tracking down this new kingpin. Other agencies around the world deployed dozens of moles and double agents. Together, the cybercops lured numerous unsuspecting hackers into their clutches. Yet at every turn, their main quarry displayed an uncanny ability to sniff out their snitches and see through their plots.The culprit they sought was the most unlikely of criminals: a brilliant programmer with a hippie ethic and a supervillain's double identity. Together with a smooth-talking con artist, he ran a massive real-world crime ring.
    Show book
  • Talking With The Animals - cover

    Talking With The Animals

    Patty Summers

    • 0
    • 0
    • 0
    A skilled animal communicator reveals the inner world of dogs, cats, horses, and other creatures—and how humans can understand them more deeply. 
     
    Animals are talking to us all the time. Patty Summers listens and understands. A renowned animal communicator, Summers can converse directly with a variety of animal species, from cats and dogs to rabbits, horses, and iguanas. In this beautiful and moving book, the animals share their wisdom, their perspective on life, and even how they feel about human beings. 
     
    The animals can teach us many things, and Summers uses her abilities to help humans listen, as well as to aid humans and animals in understanding one another better. She also describes the ways that animals comprehend the world, and explains that they always understand the intent of human communications, if not the words. And she teaches that they share our wants and needs, as they desire the same things that humans do—love, compassion, kindness, and respect—and they do not want to be thought of as pets or as beings to be exploited. 
     
    Summers shares numerous encounters with animals, and each story has a valuable lesson. Each is a gift of spirit from the animals. We have so much to learn from our animal companions, domestic and otherwise. Talking with the Animals provides a rare glimpse inside the minds of the creatures with whom we share our planet.
    Show book
  • Is That a Fact? - Frauds Quacks and the Real Science of Everyday Life - cover

    Is That a Fact? - Frauds Quacks...

    Dr Joe Schwarcz

    • 0
    • 0
    • 0
    Dr. Joe Schwarcz takes on the quacks and doles out the facts in this eye-opening look at the science around us
    		 
    Eat this and live to 100. Don’t, and die. Today, hyperboles dominate the media, which makes parsing science from fiction an arduous task when deciding what to eat, what chemicals to avoid, and what’s best for the environment. In Is That a Fact?, bestselling author Dr. Joe Schwarcz carefully navigates the storm of misinformation to help us separate fact from folly and shrewdness from foolishness. Are GMOs really harmful? Or could they help developing countries? Which “miracle weight loss foods” gained popularity through exuberant data dredging? Is BPA dangerous or just a victim of unforgiving media hype? Is organic better? Dr. Joe questions the reliability and motives of “experts” in this easy-to-understand yet critical look at what’s fact and what’s plain nonsense.
    Show book
  • Homework Helpers: Biology Revised Edition - cover

    Homework Helpers: Biology...

    Matthew Distefano

    • 0
    • 0
    • 0
    Homework Helpers: Biology is a user-friendly review book that will make any student—or those trying to help them—feel like he or she has a private Biology tutor. The book covers all of the topics included in a typical one-year Biology curriculum, including:An approach to the study of biology using the scientific method and the skills and equipment used by most biologists.The concept of the cell as the unit of structure and function of all life.DNA and the chemical processes of inheritance.The evolution of life on this planet and how humans are part of the process.The study of the environments of life and how all life is interconnected on this planet.Each chapter includes detailed questions that allow students to assess how well they’ve mastered each idea. Not only does the author provide the right answers to these self-study questions, but also detailed explanations of why the wrong answers are wrong.
    Show book
  • The Benevolent Bee - Capture the Bounty of the Hive through Science History Home Remedies and Craft - cover

    The Benevolent Bee - Capture the...

    Stephanie Bruneau

    • 0
    • 0
    • 0
    A beekeeper and herbalist shares how you can use six products of the beehive: honey, pollen, propolis, royal jelly, beeswax, and bee venom. Not all new beekeepers realize that a honeybee hive produces a lot more than just honey. While your hard-working ladies will produce delicious honey, the hive as a whole also produces pollen, propolis, royal jelly, beeswax, and bee venom; all very useful things for humans, if we know how to use them.The Benevolent Bee describes how and why the bees make these products, how they’ve been used by humans throughout the ages, and how beekeepers can harvest the products. It also presents simple do-it yourself recipes for using the products in health and wellness, body care, nutrition, and craft. You'll learn how to make salves for burns and a cough syrup from raw honey; how to make a tincture, an infused oil, and a mouthwash from propolis, the anti-bacterial “bee glue” that lines the inside of the hive; and much more. Get crafting now, it’s all already in your hive!
    Show book
  • Gentle Rain and Birds Singing - Nature Sounds for Relaxation - cover

    Gentle Rain and Birds Singing -...

    Greg Cetus

    • 0
    • 0
    • 0
    There's something magical about towering conifers and multiple layers of ferns, shrubs and mosses. And even more so when you hear rain drops gently falling over these green surfaces. And every now and then a few shy birds whistle their melodious tunes. Varied Thrushes are particularly enigmatic in this abundance of peace and quietitude.  This recording will set a perfect background for relaxation, meditation or quiet office work.
    Show book