🗄️ Keyper v1.1.1 — SQLite Local Database Support
Release Date: March 12, 2026
This release adds a fully local, zero-config SQLite database option alongside the existing Supabase backend. We've also beefed up the credential detail experience, added two new credential types (document and misc), and hammered out several security and layout fixes.
🗄️ SQLite Local Database — Zero Config, Fully Offline
Keyper can now run entirely without a Supabase account or internet connection using a built-in SQLite engine backed by sql.js and IndexedDB.
No account or server required: Just select SQLite in settings and you're running in seconds.
Hybrid Support: Works in browser/PWA (IndexedDB) and Electron desktop.
Auto-Seeding: Schema and default categories (Development, Personal, Work, Social Media, Finance, Cloud Services, Security) are created automatically on first launch.
Transparent Routing: A provider router means existing Supabase call-sites work unchanged—zero code-path differences at runtime.
Guided Recovery: Provider-specific passphrase reset instructions added to Settings.
🐛 SQLite Bug Fixes
We caught and killed two critical bugs during integration testing:
Vault Creation Silent Failure: Fixed SqliteQueryBuilder.select() overwriting in-flight mutations. Write operations no longer accidentally turn into reads.
Empty Categories Dropdown: Fixed an issue where ensureSqliteSchema created the table but forgot to seed it. Fresh installs now correctly show the 7 default categories.
✨ Credential Detail UX Improvements
Quick Reveal: Encrypted secrets can now be revealed and copied directly from the detail view (no more jumping into edit mode just to see a password).
Lock States: Added clear visual guidance when the vault is locked.
Responsive Layout: Improved modal width and overflow handling; long keys and certificates now wrap beautifully instead of clipping like shit.
🆕 New Credential Types
| Type | Description |
|---|---|
| document | Upload/encrypt files (PDF, DOCX, TXT, MD). Stored as encrypted base64. |
| misc | Large multiline secure text field for scripts, commands, and random secrets. |
Secure Downloads: Added download actions for document credentials.
Inline Preview: Toggle previews for text-based formats (.txt, .md).
Parity: certificate type now has full file upload parity in the edit flow.
🔐 Security Fixes
Type-Scoped Encryption: Add/edit flows now only encrypt fields relevant to the selected credential_type. No more data bleeding from unrelated types into the payload.
Conditional Rendering: The detail view now renders sensitive blocks strictly by type, keeping the UI clean and relevant.
🗄️ Database & Migration
Schema Update: supabase-setup.sql now includes document and misc in the credential_type CHECK constraint.
Migration Script: New migration-add-document-misc-types.sql safely updates existing installations without data loss.
Dev UX: The in-app Settings SQL tab now surfaces both the full setup and migration scripts with one-click copy buttons.
📦 Full Changelog
See CHANGELOG.md for the complete entry.
Made with 💖 by Pink Pixel