Repository navigation
Expand file tree
/
Copy pathllms.txt
More file actions
87 lines (70 loc) · 5.43 KB
/
Copy pathllms.txt
File metadata and controls
87 lines (70 loc) · 5.43 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
# SQLiteViewer
Canonical repository: https://github.com/file-bricks/SQLiteViewer
Version: 2.1.0
Stand: 2026-11-04
Organization: file-bricks
Umbrella: open-bricks
Microsoft Store: SQLite Viewer Pro (Store ID: 9P6H501XB8JT, Identity: Geiger.SQLiteViewerPro)
SQLiteViewer is a local-first Python/Tkinter desktop application for opening, browsing, searching, querying, and exporting SQLite database files. It operates with zero network egress, requires no external runtime dependencies, runs in unprivileged user space (RunAsInvoker), and includes full internationalization across 6 tier-2 languages (German, English, Spanish, Simplified Chinese, Japanese, Russian).
## Primary Use Cases
- Inspect `.db`, `.sqlite`, and `.sqlite3` files locally via double-click or CLI.
- Browse tables and schema with syntax-highlighted DDL statements.
- Run custom SQL queries in an interactive desktop UI with paging.
- Export active table rows or SQL query results to CSV or `sqliteviewer-export-v1.json`.
- Offline inspection of exported JSON datasets in a local browser via `web_companion/` with integrated 6-language switcher.
- Package and deploy clean Windows Store (AppX/MSIX) applications from source.
## Key Files & Architecture
- `SQLiteViewer.py`: main desktop application entrypoint with separated table and SQL result export state, i18n support, and keyboard shortcuts.
- `translator.py`: runtime internationalization engine supporting dynamic language switching.
- `locales/translations.json`: localized UI strings across 6 languages (`de`, `en`, `es`, `zh`, `ja`, `ru`) with 100% parity across all 86 keys.
- `NOTICE`: formal open-source attribution, copyright notice, § 521 BGB statutory liability disclaimer, and third-party license notices.
- `CONTRIBUTING.md`: bilateral developer guidelines with Plan D workflow, 10 system invariants, § 521 BGB disclaimer, and 48h SLA.
- `README.md`: primary English landing page with 16-point quick navigation, Section 3 Visual 4-View Topology, architecture diagrams, personas, and comparative matrix.
- `README_de.md`: reciprocal German user guide with full parity.
- `README_es.md`: reciprocal Spanish user guide with full section parity.
- `THIRD_PARTY_LICENSES.md`: license compliance audit certifying zero runtime external dependencies (Python standard library only) and zero-copyleft guarantees.
- `THIRD_PARTY_LICENSES.txt`: Level 1 SBOM Plain-Text Companion with 5-field schema.
- `MARKETING-LOG.txt`: discoverability log, 4 target personas, high-intent SEO queries, and comparative analysis.
- `EXPORTFORMAT.md`: JSON companion export contract (`sqliteviewer-export-v1.json`).
- `CHANGELOG.md`: versioned release history and bug fixes.
- `store_package.json`: Windows Store metadata and package identity.
- `pyproject.toml`: PEP 621 packaging metadata and test configuration.
- `tests/`: test suite covering SQL execution, i18n contracts, Store screenshots, CLI arguments, and metadata integrity.
## Target Personas
- `[PERSONA-01]` Python & Desktop App Developers: lightweight, zero-dependency SQLite inspection for local apps and test fixtures.
- `[PERSONA-02]` Privacy-Conscious Data Analysts & Researchers: air-gapped, zero-egress exploration of confidential datasets.
- `[PERSONA-03]` DevOps, System Administrators & IT Support: portable, unprivileged (`RunAsInvoker`) database inspection on customer machines.
- `[PERSONA-04]` Microsoft Store End-Users: one-click installation and double-click file associations for `.db` files on Windows 10/11.
## Comparative Matrix vs. Alternatives
SQLiteViewer enforces 10 core invariants (`INV-LOCAL-01` to `INV-LOCAL-10`):
1. Zero Network Egress: 100% offline, zero telemetry.
2. Unprivileged Execution: standard user permissions (`RunAsInvoker`).
3. Zero External Dependencies: Python standard library (`sqlite3`) and Tkinter only.
4. Non-Destructive Default: safe read-only browsing without accidental mutation.
5. Dual Export: fast CSV and structured JSON envelope with source metadata.
6. Offline Web Companion: client-side inspection in `web_companion/`.
7. Microsoft Store Integration: official AppX package (ID `9P6H501XB8JT`).
8. Permissive Open Source: 100% MIT License with zero copyleft contagion.
9. Multilingual Parity: complete documentation and UI across supported languages (Tier-2 standard: DE, EN, ES, ZH, JA, RU).
10. Security SLA: documented 48-hour response SLA.
## Search Phrases
```
file-bricks SQLiteViewer
file-bricks/SQLiteViewer
local-first SQLite viewer Python Tkinter
portable SQLite database browser CSV JSON export
offline SQLite browser Windows Python desktop
SQLite table browser SQL editor Tkinter
lightweight SQLite desktop viewer no install
local SQLite file browser export tool
Python Tkinter SQLite GUI browser
SQLite Viewer Pro Microsoft Store
```
## Boundaries
- SQLiteViewer is not DB Browser for SQLite, DBeaver, an Android SQLite viewer, an iOS debug library, a hosted SQL dashboard, or a web database admin panel.
- It is strictly local-first and does not upload database content or metadata to the cloud.
- CSV/JSON export follows the active UI context: Data tab exports table rows, SQL tab exports query results.
- It is a lightweight desktop utility for exploration, triage, and export, not a distributed DBMS.
## License
MIT License.
## Last-checked: 2026-11-08 (High-End Refactoring & Architecture Hardening: Atomic Settings, Streaming CSV, Precomputed Export Keys, SQL Highlighting Debounce & Cell Guard; 162 Pytest + 46 Node companion tests passed | 100% green, Level 1 SBOM companion verified)