底層運作原理
Choose an SQLite file or start with a sample. The left panel lists tables with row counts and columns. Click a table to query it, edit the SQL, and press Run or Ctrl+Enter. Results show in a table you can export as CSV. If you change data, download the edited database.
詳細操作步驟
Open a database file.
Pick a table or write SQL.
Run, then export CSV or download the database.
核心功能與效能優勢
- Table and column browser
- SQL editor
- CSV export of results
- Download edited database
- Runs in your browser
運算方法、公式與技術標準
The real SQLite engine, compiled to WebAssembly (sql.js), opens the file in memory. Nothing is written back to your original file.
實作範例與邊界案例
SELECT * FROM orders LIMIT 100
100 rows
Export CSV
使用限制與精準度說明
- • Large databases are held in memory; very big files (hundreds of MB) may not open.
- • Changes live in memory only until you download the database.
- • Only the first 1,000 rows of a result are shown; use LIMIT or a filter for more.
- • Encrypted databases (SQLCipher) are not supported.
瀏覽器本地運算與隱私保障
傳統線上轉換網站會將您的文件、文字片段或影音檔案上傳至遠端伺服器。SQLite 資料庫檔案檢視與 SQL 查詢器 完全在您的瀏覽器分頁內運行:
您的檔案與文字都在裝置本機計算,不會傳送內容至任何後端伺服器。
Microdeck 不會記錄或儲存您在工具內貼上的任何檔案或程式碼。
所有暫存結果僅存在目前分頁記憶體中,重設或關閉分頁後即刻清除。
常見問題 (FAQ)
Will my original file change?
No. The file is copied into memory. Download the edited database to keep changes.
Is anything uploaded?
No. Your database file or diagram text stays in your browser. Only the open-source library itself is downloaded the first time you use the tool.