BLOG START

This is the first Blog Post for my consulting website. The purpose to roadmap my progress through various projects I am working on.

Project: Dashboard

Purpose: to provide a central (offline) location for me to see my daily tasks and itinerary, and apply updates to them in a singular location.

I am currently using python script with pyside6.QTWidget, and SQL tools. The work flow is to have my outside files get filtered into a SQL Database, which serves as the reference point for the dashboard ui. I will then be able to ‘modify’ certain fields within the ui, which will reflect back into the database, and into the source file.

Excel → Python Import → SQLite Database → PySide6 Dashboard → User Interaction → SQLite → Excel

I made the choice of utilizing SQLite earlier on in development, due to its ability to pull upon information quicker, a centralized reference point. And the ability to facilitate multiple interactions without interruptions. Example, if Excel file is open, no program can touch it without closing first.

Currently I have a frontend dashboard ui functioning. I am able to see my itinerary, task list, and hardware performance within a single, tabbed, display.

Now I am implementing a controller.py to recognize my input and react accordingly. This will allow the dashboard ui to ‘react’ to my interaction and update my database, and source file respectively.

FUTURE

               I plan to develop a series of modules that I can use to assist me on my every day life. Be a inventory tracker for hardware, or methods to keep track of my work hours to improve efficiency. This foundation will support all those future operations.