Offline / SQLite Mode
Desktop App only
Offline / SQLite mode is only available in the DPD Label Print desktop application.
DPD Label Print can operate in SQLite mode — using a local file-based database instead of PostgreSQL. This is suitable for standalone workstations, locations with unreliable internet, or environments where a database server is not available.
SQLite vs PostgreSQL mode
| SQLite (Offline) | PostgreSQL | |
|---|---|---|
| Database | Local file (labelprint.db) | Shared database server |
| Internet | Not required for day-to-day use | Required |
| Multi-user | ❌ Single user only | ✅ |
| Performance at scale | Up to ~10,000 shipments/month | Unlimited |
| Setup complexity | None (zero config) | Requires PostgreSQL server |
| Best for | Standalone workstation, low volume | High volume, teams |
Enabling SQLite mode
- Open Settings → Database
- Select SQLite (Offline)
- Choose or confirm the database file location (default:
C:\ProgramData\DPD Label Print\labelprint.db) - Click Save and Restart
The application restarts and uses the local SQLite database.
Working offline
In SQLite mode, the application works fully offline for:
- Creating shipments and printing labels (labels are generated locally)
- Storing shipment history
When an internet connection is available, the application automatically:
- Synchronizes pending shipments to DPD
- Downloads updated routing data and configuration
Switching from SQLite to PostgreSQL
If your volume grows and you need to move to PostgreSQL:
- Export your shipment history: Reports → Export → All Shipments (CSV)
- Set up PostgreSQL (see Server Installation)
- Switch the database mode in Settings → Database
Historical data from SQLite is not automatically migrated — only new shipments will be stored in PostgreSQL.