Skip to content

This Python program creates a relational SQL database hosted on the Snowflake platform, then opens a CRUD GUI to manipulate and view the data. In this application, it is used as a book catalogue. CURRENTLY WIP

License

hazardgoat/Catalogue_CRUD

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

32 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Catalogue CRUD Application

z

--- WORK IN PROGRESS ---

This program creates a relational SQL database hosted on the Snowflake platform, then opens a CRUD GUI to manipulate and view the data. In this application, it is used as a book cataloge.

The requirements and primary catalogue files are located in the Resources folder.

Also required: Snowflake account, Box account, Box Dev App

Features:

  1. Bulk uploads via CSV files to establish the primary catalogue
  2. Individual entries on a given table may be added, updated, and deleted via the GUI interface.
  3. Users may download files hosted in a Box repository via the Box file ID, or both the file name and extention.
  4. Current table is displayed in a tree view to the right of the text fields within the GUI.
  5. Display refreshes with each action taken via the GUI so as to keep displayed info current.

About

This Python program creates a relational SQL database hosted on the Snowflake platform, then opens a CRUD GUI to manipulate and view the data. In this application, it is used as a book catalogue. CURRENTLY WIP

Topics

Resources

License

Stars

Watchers

Forks

Languages