A few things worth knowing.
Small, practical guides for working with SQLite and the files already on your computer.
How to Open a .db File in Your Browser
Identify a SQLite .db file, open a local browser copy, explore tables, and export changes safely.
Read guideSQLite JOINs: Query Related Tables
Learn INNER JOIN and LEFT JOIN with runnable SQLite examples using the sample shop database.
Read guideCSV Data Types: Preserve IDs and Clean Numbers
Choose TEXT, INTEGER, and REAL when importing CSV to SQLite without losing leading zeros or large identifiers.
Read guideSQLite Foreign Keys and ER Diagrams
Understand declared foreign keys, composite references, and what an automatically generated SQLite ER diagram can tell you.
Read guideSQLite Show Tables: List Tables, Views and Columns
List SQLite tables with sqlite_schema and inspect columns with table_info. Try the queries on a sample database in your browser.
Read guideSQLite ORDER BY: Ascending, Descending and Stable Results
Learn SQLite ORDER BY ASC and DESC with examples, tie breakers, LIMIT and NULL ordering.
Read guideExport SQLite to CSV, JSON or SQL Without Preview Truncation
Choose between preview downloads, complete CSV/JSON exports, SQL dumps and SQLite database backups, with browser limits explained.
Read guideSQLite vs SQLite3: What Is the Difference?
Understand SQLite, the sqlite3 command, Python sqlite3, and common .sqlite and .sqlite3 file extensions.
Read guidePython sqlite3: Create a Database and Inspect It Online
Create a small SQLite database with Python sqlite3, use parameter bindings, and inspect the resulting file in the browser viewer.
Read guideSQLite Database Is Locked: Diagnose the Cause
Distinguish SQLite file-lock errors from browser storage ownership and recover without deleting your database.
Read guideSQLite ALTER TABLE: Add, Rename and Drop Columns
Try SQLite ALTER TABLE examples, understand dependency errors and review schema changes before applying them.
Read guideSQLite CREATE INDEX: Choose and Check an Index
Create a SQLite index, inspect a query plan and understand composite indexes, covering indexes and write costs.
Read guideFix SQLite CSV Import Errors: Types, Quotes and Columns
Troubleshoot CSV delimiter, row-width and numeric conversion errors while preserving exact identifiers and atomic imports.
Read guideSQLite Date Functions: Dates, Months and Unix Timestamps
Use date, datetime and strftime with deterministic SQLite examples and avoid timezone and month-boundary mistakes.
Read guideSQLite JSON Functions: Extract, Validate and Expand Arrays
Query JSON in SQLite with json_valid, json_extract and json_each, with runnable examples and scalar type explanations.
Read guide