Database Management

Wheeler uses SQLite databases for data storage, providing you with complete control over your financial data:

Database Storage & Location

• Database Files - All databases are stored as .db files in the ./data/ directory
• SQLite Format - Industry-standard SQLite database format, compatible with any SQLite browser
• Current Database - The active database is tracked in ./data/currentdb file
• Portable Files - Database files can be copied, moved, or shared like any other file

Database Operations

• Create Database - Creates a new empty database with Wheeler's schema
• Switch Database - Change which database Wheeler is currently using
• Delete Database - Permanently remove a database (current database is protected)
• Create Backup - Creates a timestamped copy in the ./data/backups/ directory

Backup Strategy

• Easy File Backups - Since databases are SQLite files, backing up is as simple as copying the .db file
• Manual Backups - You can manually copy database files to any location (cloud storage, USB drive, etc.)
• Automated Backups - Use the built-in backup feature for timestamped copies
• Version Control - Database files can even be stored in Git repositories if desired
• Your Choice - Wheeler doesn't dictate your backup strategy - use what works best for you

Advanced Usage

• External Tools - Use any SQLite browser (DB Browser for SQLite, DBeaver, etc.) to examine your data
• Multiple Environments - Create separate databases for testing, production, or different portfolios
• Data Migration - Easily move between systems by copying database files
• Custom Scripts - Write your own scripts to query or modify the SQLite database