Library Program Prison Project

[lewashby]

I run a small library in a prison and I'm currently having to do everything in an excel spreadsheet which has a lot of limitations and there are a lot of tasks that could be made a lot easier and done a lot faster if I could replace this spreadsheet with a functional program. I don't have great programming skills but I have played around a little in python, bash, C, C++, and most notably php. I need this program to keep an inventory of all of my books, to be able to check books in and out to specific inmates by their numbers, to be able to add and drop books from the inventory, and generate unique IDs for each book in my inventory. I already have a formula in my head for generating the IDs. For a database I plan on using SQLite because I think I would have an easier time convincing our I.T. team to simply install Python than I would trying to get them to install a full fledged database server and a more heavy weight programming environment, and python gets things done quick. Apart from Python and it's built in SQLite support I know I'm going to need a GUI library, which I have little to no experience in. Any suggestions or recommendations on a good GUI module/library for this project. And what am I looking at here, how big of a project is this going to be? I've attached a copy of the XLSX file I have been using, never mind there is no upload file button. Thanks.

If I am successful with my above goals I hope to add the ability to generate Bar or QR codes for each book id that I can print out on my library book card sleeves and add the ability to scan the books in and out.

my code here