Que fait SQLite Workspace ?
SQLite Workspace permet de inspecter des données dans le navigateur et présente clairement le résultat et ses limites. Fonctions vérifiées : Local database import and creation, Table and view schema browser, SQL queries and in-memory edits, Database and query JSON export.
When should you use this tool?
Use this workspace to inspect and make small changes to local SQLite files without a server. Use SQL Formatter for formatting alone and a desktop SQLite client for large files, encrypted databases, transactions, exact 64-bit integer workflows or durable storage.
Comment l’utiliser ?
- Open a database up to 25 MiB, or choose New database / Sample database. Replacing it discards unexported changes.
- Enter one statement up to 64 KiB and select Run. Inspect the table or JSON preview; use LIMIT for large queries.
- Export the database to save edits. Download JSON for the current preview; closing the tab or stopping the Worker discards in-memory changes.
Exemple réel d’entrée et de sortie
Query adult users in the sample
Entrée
SELECT name, age FROM people WHERE age >= 18 ORDER BY age;Sortie
name | age
Ada | 32
Grace | 40The sample database contains Ada (32), Linus (17) and Grace (40). This query selects two adult rows. INSERT, UPDATE and DELETE change only the in-memory database until you export it.
Erreurs fréquentes et corrections
| Symptôme | Cause probable | Correction |
|---|---|---|
| The database cannot be opened. | It is encrypted, not a SQLite file, corrupt or larger than 25 MiB. | Choose an unencrypted SQLite database. A server connection URL or a SQL dump is not a database file; no remote connection is attempted. |
| A query fails or results are truncated. | SQL syntax, unsupported control statements or preview limits prevent a full result. | Run one ordinary statement, reduce selected columns and add LIMIT. The preview is capped at 500 rows, 64 columns and about 2 MiB; exported databases retain the full data. |
Supported behavior and limitations
Limite propre à cet outil : Data lives only in this tab, without automatic saving. Open/create/sample replaces the current database. Stop or the 15-second timeout closes it and discards unexported changes. Input files: 25 MiB; database growth is limited to about 64 MiB. One SQL statement per run, no file attachments, transaction-control commands, VACUUM or general PRAGMA (table/index/foreign-key introspection is supported). BLOB previews show 32 bytes, text cells 4096 characters; long cells are marked. Integers use JavaScript number precision. Large operations may still exceed browser memory; work on copies.
Normes et références d’implémentation
- sql.js official repository (opens in a new tab)MIT JavaScript wrapper with public-domain SQLite, supporting browser import and export. The WASM engine is served locally.
- SQLite SELECT documentation (opens in a new tab)Authoritative query syntax; the tool applies its own single-statement and preview limits.
SQLite Workspace — FAQ
Is my input uploaded?
No. Processing happens in a browser Worker. Engine files load from this website; tool input, output, and filenames are not sent to a processing API.
Do I need an account or API key?
No account, API key, or backend processing service is needed.
How do I save a result?
Review the result, then use the Copy or Download control available for that output. Modifying input clears stale results.
What are the limits?
Data lives only in this tab, without automatic saving. Open/create/sample replaces the current database. Stop or the 15-second timeout closes it and discards unexported changes. Input files: 25 MiB; database growth is limited to about 64 MiB. One SQL statement per run, no file attachments, transaction-control commands, VACUUM or general PRAGMA (table/index/foreign-key introspection is supported). BLOB previews show 32 bytes, text cells 4096 characters; long cells are marked. Integers use JavaScript number precision. Large operations may still exceed browser memory; work on copies.
Quelles modifications ?
Mise à jour substantielle : SQLite Workspace: Added local processing, explicit size limits, cancellation, worked examples, error explanations, and downloadable results.