Skip to content

Guide

Windows software with a database: from the warehouse shelf to the web shop

Published Updated Written by Ruslan Bilohash · Bilohash Studio, Drammen

Not everything belongs in a browser. When people scan goods, print labels or log production at a workstation, a Windows program with its own database is often the simplest and most reliable tool. Here is what I build and how we can work together.

A database-driven business system I built: catalogue, stock and invoices on a laptop, tablet and phone

When a Windows program fits

I develop Windows software with databases of any complexity. A desktop program is a good choice when the work happens at a fixed place — a warehouse, a workshop, a production line or a front desk — and when it has to talk to hardware such as barcode and QR scanners or label printers.

It also fits when the work must go on without internet, or when large amounts of data have to be searched quickly on the spot. The online part stays online: the web shop, the website, booking and payments keep running as before, and the Windows program exchanges data with them.

Typical cases

  • Warehouse and stock. Goods receipt by scanning, picking lists, stock counts and storage locations. USB or Bluetooth handheld scanners read EAN, Code 128, QR and other codes, and the program prints labels with your own barcodes or QR codes.
  • Production terminals. Orders, batches and work steps are registered at the workstation, so you can trace what was made, when and from which materials.
  • CRM and ERP connector. A desktop program that sits between your systems and moves customers, orders and products, so nobody has to type the same data twice.
  • Offline-first with a web shop. A counter or warehouse program that works without internet and syncs stock and orders with Shopify, WooCommerce, your own web shop or the cloud when the connection is back.

Database, roles and safety

The database is chosen by the task: SQLite for a program on one PC, SQL Server, PostgreSQL or MySQL when several users work at the same time or the data must be shared over a network. If you already have a database, I start by looking at it.

  • Roles and access rights — each user sees and changes only what belongs to their job.
  • Automatic backups and a clear way to restore them.
  • Installer and automatic updates, so new versions reach every workstation without manual copying.

Integrations

A Windows program does not have to live alone. I connect it to accounting systems, CRM, web shops (Shopify, WooCommerce or your own), booking systems and payments through Stripe or Vipps. The connection goes through a REST API when the system offers one, or through CSV and Excel import and export. Before we agree on the scope, I check what each system actually allows.

How a project goes

  1. You describe the task in free form, in your own words.
  2. I make a short analysis of the work, the data, the hardware and the systems involved.
  3. We agree on a fixed scope and the price — everything by agreement.
  4. I show a prototype early, so you can try it on real tasks.
  5. Delivery: installation on your computers and a walk-through of the main functions.
  6. Support after launch — fixes, new versions and changes when your work changes.

More details, examples and the contact form are on the service page Windows software with a database.

Questions and answers

Do I need to know exactly what I want?

No. Describe the task in your own words; the short analysis turns it into a concrete scope that we agree on.

Can you build on an existing database or program?

Often yes. I look at what you have first and suggest whether to extend it, connect to it or move the data.

What does it cost?

The price is agreed after the analysis, based on the scope. Scope and price are fixed before the work starts.

Ready-made scripts with a live demo

I license each script for a month or a year — try the demo first. Custom work is agreed separately, price by agreement.

All news
You rejected optional cookies. The site works as usual; the contact form still uses reCAPTCHA against spam.