Address Book

A featureful address book app in a single HTML file. All data is persisted to a SQLite file on your local filesystem.

Demo: https://address-book.exe.xyz

Features

• Open, create, and save SQLite database files
• Add, edit, and delete rows and columns
• Column sorting (click header to cycle: ascending → descending → none)
• Global search and per-column filtering
• Drag-and-drop column reordering
• Resizable columns
• Hide/show columns
• Print mailing labels (Avery 5909 format)
• Auto-reconnect to last opened file
• Dark mode support
• Keyboard navigation (arrows, Tab, Enter)

Design

Everything lives in a single index.html file—HTML, CSS, JavaScript, and SVG icons. No build step required. Just open it in a browser or serve it from any static host.

External dependencies (loaded from CDN):

• sql.js - SQLite compiled to WebAssembly
• jsPDF - PDF generation for labels

Usage

1. Open index.html in a modern browser (Chrome, Edge, or other Chromium-based browsers recommended for File System Access API support)
2. Click "New" to create a new address book, or "Open File" to open an existing .sqlite3 file
3. Edit your data in the spreadsheet interface
4. Click "Save" or press Ctrl+S to save changes

Keyboard Shortcuts

Shortcut	Action
Ctrl+S	Save
Ctrl+O	Open file
Ctrl+F	Focus search
Enter	Move to next row
Tab	Move to next cell
Arrow keys	Navigate cells