DLUG February 2024 Meeting

Описание: Dayton LINUX Users Group
https://linux.dma1.org/

February 2024 Meeting: Food Storage Inventory w/ Open Source

Presentations/Topics: Ben Kendrick will demonstrate his inventory program that his family uses to manage food storage in their basement.

“I built it on open source software. We use it to keep track of what is in our storage room so that when we run out of things there is a handy report to use when going to the grocery store or ordering on line.

“We use bar code scanners to scan the UPC of items that go into basement when we do shopping trips and then a permanent station in the basement running Linux with a bar code scanner to scan things out of inventory. The center of the system is a database that runs on MariaDB (a MySQL fork). The processes are primarily written in PHP and run on a Linux virtual machine accessible only within the house. The reporting is done either in PHP, Jasper Reports, or LibreOffice Base. The system features multiple locations, audio response to input, inventory checking and correction, and bulk inventory expansion.

“The fact that the technologies used are open source allowed me to set up and deploy all of this with no cost beyond the hardware. The light footprint of Linux also allows for the permanent stations to be very old surplus netbooks.”