GitHub - Sieep-Coding/spark: GUI to manage essential business data with python + tkinter + SQLite backend.

2 min read Original article ↗

spark - System for Progressive and Active Relationship Keeping ✨

Spark Logo

spark is a GUI to manage essential business data. It is a lightweight, fast, local-only application designed for my personal use-case but applicable to small businesses or individuals who need an efficient tool for organizing contacts, tracking leads, exporting data to excel, viewing table relationships, running reports, and managing tasks/projects without relying on costly cloud services or heavy enterprise solutions. Built with a reliable but fast stack: python, tkinter, and SQLite. To improve the development experience, I have developed a boring makefile to manage build scripts and some spicy hot reloading with watchdog. Tested on Linux Ubuntu, WSL, and Linux Mint.

License: MIT Version: 3.13.7 Version: 3.45.3 Version: 4.3 WSL Passing Ubuntu Passing Mint Passing

Warning

Not ready for a production environment (yet). Use at your own risk.

Core Features

I want this to run as fast as possible, with the goal of keeping the executable under a few hundred MB.

Some other features include:

  • Adding, managing, removing data through forms.
  • No server!
    • Relies on a single .db file locally.
  • Exporting to common file-types.
  • Viewing data, reports, table relationships easily.
  • Simple, Fast AF, SQLite backend. 🏃‍➡️
  • Hot reloading with watchdog for insane productivity.

Manage Your Contacts and Leads

Run Reports and View Insights

Navigation

Quickstart

Tip

Some Operating Systems (i.e. Arch based) may require you to download dependencies through a virtual environment

Clone:

git clone https://github.com/Sieep-Coding/spark.git
Command Action
make install Installs dependencies
make Run Local
make dev Run Dev Environment
make backup Backup database/flat data files.

Dependencies

Important

Only tested on Linux so far!

But why?

"In the same way a woodworker invests the time in a jig, a programmer can build a code generator. Once built, it can be used throughout the life of the project at virtually no cost." -- Andrew Hunt