8月14日的SQLite Client - Browse & Query应用程序分析

🗄️ SQLite Client is a local SQLite database client for Android. Open a database file, create a new one, edit data and schema, run SQL, build queries visually, learn SQL hands-on, import or export data, and save changes back with safeguards designed to protect your files. ✨ KEY FEATURES 📂 File-based SQLite workflow Open .db, .sqlite, .sqlite3, and .db3 files through Android's Storage Access Framework. Create a new empty database, reopen recent files, receive database files from other apps, and share databases when needed. ✏️ Data editing Edit cells inline, add rows, duplicate rows, delete rows, and find and replace values by column. Import or export BLOB data, preview image BLOBs inline, and open audio or video BLOBs in your player. Tables without a safe row identity stay protected from unsafe row edits. ⌨️ SQL editor Run SELECT, INSERT, UPDATE, DELETE, DDL, and multi-statement scripts with syntax highlighting, context-aware completion, query tabs, history, bookmarks, destructive statement confirmation, and single-transaction script execution. 🧩 Visual query builder Build SELECT statements without writing SQL. Pick a table and columns, add WHERE conditions (=, !=, <, >, LIKE, IS NULL, IN and more), set ORDER BY and LIMIT, preview the generated SQL live, then run it or send it to the editor. 🎓 Learn SQL Practice with ten built-in lessons covering SELECT, WHERE, sorting, aggregates, GROUP BY, JOIN, and INSERT/UPDATE/DELETE. Every lesson runs in a safe sandbox on sample data, so your real files stay untouched, and your progress is saved. 🏗️ Schema designer Create and drop tables, add columns, rename columns, drop columns, create or remove indexes, inspect constraints, and preview generated DDL before applying schema changes. 🧰 Database tools Run integrity checks, foreign key checks, VACUUM, ANALYZE, REINDEX, PRAGMA edits such as user_version and journal_mode, and compare schemas between two databases. 🔐 SQLCipher support Open encrypted SQLite databases, set or change a password, remove encryption, and save encrypted files back through the same safe editing flow. 📥 Import and export Import CSV or JSON data with a guided column-mapping wizard: choose the delimiter, header handling, target mode (new table, append, or replace), per-column type, default values, and conflict policy. Export table data or query results as CSV, JSON, SQL, Markdown, or Excel (XLSX), and save reusable export presets with filename templates. 🧭 ERD and data visualization Explore tables, columns, and foreign key relationships in an interactive ERD. Tap a table to jump to its data or schema, review foreign key details, and highlight tables with no relations. Create quick charts from query results when data needs a visual check. 🛡️ SAFE BY DESIGN SQLite Client edits a temporary working copy first. When you save, the app backs up the original file, checkpoints WAL data, runs an integrity check, and only then writes back to the selected file. Before saving, you can preview a summary of schema and row-count changes. Additional safeguards include: • File snapshot undo and redo for data and schema edits • Change preview before writing back • Destructive SQL confirmation • Read-only fallback when the source cannot be written • Save As flow when original write access is unavailable • Offline core database features • No database contents collected or uploaded 🌍 LANGUAGES Available in English and Korean. 📱 MODERN ANDROID EXPERIENCE • Material Design 3 • Light, Dark, and System themes • Recent files and sample databases • Optimized for phones, tablets, and foldables Use SQLite Client to inspect, edit, query, build, learn, and maintain SQLite databases directly on your Android device.