Books Database

SQL Project for University, written in python3 using:

• sqlite3
• PySimpleGUI
• Tkinter

Features

• Insert new books
• Filter the books by author, title, or content
• Filter all the word appearances using many parameters
• Define word groups for cherry-picked filtering
• Define and search phrases in text
• General statistics about the words and books
• Save and load the database from disk
• Import and export the database to XML

Screenshots

Filter words

Insert and filter books

Search phrases

Statistics

Schemes

Entity relationship diagram

XML format