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!
I want to read the book!
All characters reduced
Building Two Desktop Applications Using 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!

Building Two Desktop Applications Using 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.
Available since: 11/20/2019.

Other books that might interest you

  • Counterstrike - The Untold Story of America's Secret Campaign Against Al Qaeda - cover

    Counterstrike - The Untold Story...

    Eric Schmitt, Thom Shanker

    • 0
    • 0
    • 0 
    In the years following the 9/11 attacks, the United States waged a "war on terror" that sought to defeat Al Qaeda through brute force. But it soon became clear that this strategy was not working, and by 2005 the Pentagon began looking for a new way.In Counterstrike, Eric Schmitt and Thom Shanker of the New York Times tell the story of how a group of analysts within the military, at spy agencies, and in law enforcement has fashioned an innovative and effective new strategy to fight terrorism, unbeknownst to most Americans and in sharp contrast to the cowboy slogans that characterized the U.S. government's public posture. Adapting themes from classic Cold War deterrence theory, these strategists have expanded the field of battle in order to disrupt jihadist networks in ever more creative ways.Schmitt and Shanker take listeners deep into this theater of war, as ground troops, intelligence operatives, and top executive branch officials have worked together to redefine and restrict the geography available for Al Qaeda to operate in. They also show how these new counterterrorism strategies, adopted under George W. Bush and expanded under Barack Obama, were successfully employed in planning and carrying out the dramatic May 2011 raid in which Osama bin Laden was killed.Filled with startling revelations about how our national security is being managed, Counterstrike will change the way Americans think about the ongoing struggle with violent radical extremism.
    Show book
  • Everest - Expedition to the Ultimate - cover

    Everest - Expedition to the...

    Reinhold Messner

    • 0
    • 0
    • 0 
    'Everest by fair means - that is the human dimension, and that is what interests me … In reaching for the oxygen cylinder, a climber degrades Everest … a climber who doesn't rely on his own strength and skills, but on apparatus and drugs, deceives himself. In May 1978 Reinhold Messner and Peter Habeler became the first climbers in history to reach the summit of Mount Everest without the use of supplementary oxygen - an event which made international headlines and permanently altered the future of mountaineering. Here Messner tells how the and Habeler accomplished the impossible - and how it felt. He describes the dangers of the Khumbu Icefield, the daunting Lhotse flank, two lonely storm-filled nights at 26,247 feet, and finally the last step to the summit. Everest: Expedition to the Ultimate is a riveting account of the exhaustion, the exhilaration and the despair of climbing into the death zone. The book also includes a history of the mountain, successful ascents and Messner's reflections on recent tragedies on Mount Everest. Reinhold Messner was the first to climb all fourteen peaks higher than 8,000 metres. The author of more than a dozen books on his adventures, he lives in a castle in northern Italy.
    Show book
  • Somewheres East of Suez - cover

    Somewheres East of Suez

    Tristan Jones

    • 0
    • 0
    • 0 
    In 1983 Tristan Jones, well known as one of the finest sailing adventure writers of our time, had his left leg amputated. Refusing to become landbound after a lifetime at sea, he acquired a specially designed, virtually untippable 38-foot trimaran and began to sail around the world. Outward Leg is the tale of his intrepid voyage from San Diego to London. The Improbable Voyage chronicles his heroic journey along an unusual and hazardous route from the North Sea, through the rivers of Central Europe, to the Black Sea. In Somewheres East of Suez, the final installment of this extraordinary saga, Tristan sails eight thousand miles from Istanbul to Thailand. From the tourist- and terrorist-dominated ports of the eastern Mediterranean to African outposts peopled with famine refugees, Tristan maintains the unique perspective of a man who has had minimal contact with society's restraints, using his acerbic wit to spare no fools and offer biting social commentary. After barely escaping with his life in South Yemen, he sets off for the Far East, determined to win out against the difficulties of his disability, whether battling a tropical cyclone or surviving on a dwindling ration of fresh water in the vast windless expanse of the Indian Ocean. 
    Show book
  • Imaginative Communities - Admired cities regions and countries - cover

    Imaginative Communities -...

    Robert Govers

    • 0
    • 0
    • 0 
    Americans are loud. Amsterdam equals sex, drugs, and rock & roll. Mexicans are lazy and Germans are boring, but punctual. Paris is romantic, Wuhan infectious, Ukrainians heroic, and New Zealand untouched.  
This is the way people around the world think about cities, regions and countries and the communities that live there; through cliches and stereotypes. It can be frustrating and hindering trade, diplomacy, investment, tourism, or talent attraction. Many believe that such image problems can be resolved with advertising campaigns, but the classic tourism promotion model is broken and insufficient. This book explains what works and what doesn’t when it comes to improving the reputation of cities, regions, and countries. It does so without the use of jargon and with reference to numerous case-studies. The book primarily aims to inspire readers and offer them a broad overview of an issue in modern society that is of interest and relevance to all of us: the reputation of our communities. 
Tables and figures: download from www.imaginativecommunities.com/tables
    Show book
  • Uncle Wiggily's Travels - cover

    Uncle Wiggily's Travels

    Howard R. Garis

    • 0
    • 0
    • 0 
    This is the second of 79 Uncle Wiggily books published and contains another selection of bedtime stories from those originally published in the Newark Evening News every day except Saturday for over 40 years. Uncle Wiggily Longears is a loveable rabbit who suffers from rheumatism and has many woodland friends and innocent adventures. (Summary by Lynne Thompson)
    Show book
  • Hashtag Secrets: The Guide to Success on Social Media - cover

    Hashtag Secrets: The Guide to...

    Ismail Can Karademir

    • 0
    • 0
    • 0 
    Hashtag Secrets: The Guide to Success on Social Media 
A detailed hashtag-themed guide like this has never been written before. 
With this guide, you will achieve success on social media. 
By applying these strategies, your visibility on platforms such as Instagram, Twitter, Pinterest, and Youtube will reach its maximum level. 
You can even become a phenomenon by increasing your followers. 
Detailed About the Guide 
Are you tired of your posts getting lost in the endless sea of social media? 
Hashtags might look like simple little symbols, but they hold the power to transform your online presence. 
"Hashtag Secrets: The Guide to Success on Social Media" unlocks the potential of those # symbols to get your content seen, shared, and loved. 
Why choose "Hashtag Secrets"? 
From Beginner to Pro 
Whether you're a social media newbie or a seasoned user, this guide has something for you. 
Results-Driven 
We focus on the strategies that actually increase your reach, engagement, and brand awareness. 
Beyond the Basics 
Learn how to craft your own catchy hashtags, launch hashtag campaigns, and adapt your strategy as trends evolve. 
What You'll Walk Away With 
Expert Hashtag Skills 
Understand how to find the perfect hashtags, create killer combinations, and avoid rookie mistakes. 
Engaged Audience 
Connect with the right people, spark conversations, and build a loyal following. 
Boosted Brand 
Increase your visibility, become a recognized voice in your niche, and watch your social media presence grow. 
Ready to level up your social media?
    Show book