This project took four months to complete, and I’m extremely satisfied with the result. Throughout the process, I gained valuable knowledge in Python and Oracle SQL, and I'm proud to have successfully overcome the challenges faced along the way.
Stockify is a desktop stock control app built in Python using the
Tkinter module, providing a user-friendly interface.
It integrates with an Oracle SQL database, making
it easy to assign users to devices, devices to storages, and track inventory in real-time.
This desktop app is fully designed in Python using
Customtkinter for the GUI, allowing anyone with basic Python knowledge to modify it using
the
provided documentation.
Stockify is adapted to use an Oracle SQL database to make the SELECT, CREATE, INSERT and DELETE queries, but it can also be adapted to PostgreSQL or MySQL, when selected in the installation
learn moreThe project includes documentation of all providing documentation on continuos development and exporting the app from Python (.py) to an executable.
learn moreStockify includes a dashboard section that displays device types available in storage and assigned to users, with filtering applied by location.
learn moreThe app allows bulk data import via CSV, and if discrepancies between CSV data (e.g., user-device or device-storage assignments) and the database arise, a window displays the differences for selecting the most up-to-date information
learn moreThe app is optimized for speed, delivering rapid performance when executing SELECT queries, updating data, bulk importing, and displaying dashboards.
learn more Check out both videos on my YouTube channel
@freddylife01, also shown below:
Stockify Part 1: App Overview and
Presentation
Stockify Part 2: Live App Demonstration"
Showcase project work
Engage audience with videos
Highlight project features
Attract attention with logo
This project took four months to complete, and I’m extremely satisfied with the result. Throughout the process, I gained valuable knowledge in Python and Oracle SQL, and I'm proud to have successfully overcome the challenges faced along the way.
My documentation provides a clear understanding of most of the Python code in this app. For any sections that remain unclear, I encourage you to first attempt to understand them on your own, and if needed, use AI tools for further clarification
You can add as many device types as you need. The app includes an option to select the type when adding a device. Once added, the device type will appear in the selection box, populated from the database. Initially, you will start with zero device types
Yes, they are. My Part 2 video on my YouTube channel showcases each section of the app and provides
guidance on how to use it
➡️ Stockify Part 2: Live
App Demonstration
Yes, it is possible, but the database must have a public domain; otherwise, it can only be accessed from the private network where the database is located. To start using the app, you can download the ➡️ Oracle Instant Client.