Dental Clinic Management System With SQLite Database

The Problem

Lijauco Dental Clinic was running its day on paper, where patient records, treatment histories, and billing were slow to dig through and easy to misplace. They wanted something that lived on the clinic's own PC, worked with no internet, and kept everything in one place. That way, staff could pull up a patient's history and see exactly what they owed in seconds.

What We Built

We built the clinic a desktop application that keeps patient records, treatment histories, and billing together in one simple system. Staff log treatments against each patient and see the full history at a glance. Billing works itself out automatically: the outstanding balance is calculated for them instead of tallied by hand. Because the data lives locally and self-contained, it stays fast, private, and easy to back up, with nothing depending on an internet connection. The clinic used it to bring decades of paper charts into one place, and the records in the delivered system run years past the handover. It gives a small practice the order of real software without the cost or complexity of running a server.

Results

• Works offline

  runs on the clinic PC with no internet needed

• Balances auto-calculated

  outstanding amounts computed from charges and payments

• One window

  records, treatments, and billing in a single app

• Years past handover

  the clinic kept working in it long after delivery, with historical paper charts back-entered alongside new ones

Techstack