cd ..

[ project / 09 ] · Desktop App

VerdadesVivas Sys.

A practical Java desktop tool for a real book-sales operation: CRUD, local SQLite, Excel exports and self-update.

JavaSwingSQLiteApache NetBeans

in action

The interface

Books· Books: list
1 / 10
Books: list
expand

click image to expand fullscreen

about the project

VerdadesVivasSys was built for a real operation: the Verdades Vivas book distribution network needed a practical tool to track clients, books and sales without depending on internet, cloud accounts or any external infrastructure. The result is a standalone desktop application that runs from a double-click on any Windows machine.

The app covers three main screens, each with full CRUD and fast in-screen filtering: books (title, author, price, stock), clients (registration and history) and sales (linking clients to book purchases). Every record is persisted in a local SQLite database that the app creates automatically on first run. No setup, no configuration, no DBA needed. The choice of Java Swing over any browser-based approach was deliberate: the machines this runs on are old and underpowered, and the system needed to start fast and stay responsive on that hardware without fighting a browser engine for resources.

Version 1.0.3 added an Extra tab with practical tools for day-to-day use: a database backup export (full SQLite dump), sales report export to Excel (XML format), and a self-update button. The self-update feature hits the GitHub Releases API, downloads the latest .jar, replaces the running binary and restarts the application, so users always get the newest version without a manual download.

Distribution is intentionally simple: a single .rar containing the executable .jar and a JDK installer for machines that do not have Java. No server, no installer wizard, no account creation. Extract, optionally install Java, double-click the .jar. The whole system runs airgapped if needed.

project.meta

type
Desktop App
stack
Java · Swing · SQLite · Apache NetBeans
source
repo

what it does

Key features

01

Three CRUD screens with fast filtering

Books, clients and sales: each screen lets you create, edit, delete and search records instantly, no page reload.

02

Local SQLite, auto-created

Database is created automatically in the same folder as the .jar. No setup, no connection string, no external server.

03

Excel export for sales reports

Exports sales data to Excel (XML format) directly from the Extra tab. Clients and book lists exportable too.

04

Self-update mechanism

Checks GitHub Releases, downloads the latest .jar, replaces itself and restarts. Users update with one click.

05

Offline-first, zero dependencies at runtime

Works without internet. Distributed as a .jar with a bundled JDK installer so it runs on any Windows machine out of the box.