SQLite
v3.36.0
Loading editor...
Loading terminal...
SQLite
v3.36.0
SQLite is a self-contained, serverless, zero-configuration relational database engine. Created by D. Richard Hipp in 2000 and now developed by the SQLite Consortium, it stores an entire database in a single cross-platform file and runs in-process rather than as a separate server. Its data model is relational: tables, rows, and columns queried with SQL. It is the most widely deployed database in the world, embedded in phones, browsers, and countless applications.
Because it needs no server or setup, SQLite is ideal for embedded systems, mobile apps, desktop software, prototyping, and local data storage. It uses dynamic typing (type affinity) rather than rigid column types. This tool is a free online query editor running SQLite 3.36.0, so you can write and execute SQL in your browser to learn the dialect or test queries without installing anything.
CREATE TABLE users (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
email TEXT UNIQUE
);
INSERT INTO users (name, email) VALUES
('Ada', '[email protected]'),
('Linus', '[email protected]');SELECT id, name
FROM users
WHERE name LIKE 'A%'
ORDER BY name;SELECT u.name, o.total
FROM users u
JOIN orders o ON o.user_id = u.id
WHERE o.total > 100;SELECT user_id, COUNT(*) AS order_count, SUM(total) AS spent
FROM orders
GROUP BY user_id
HAVING SUM(total) > 500;SELECT name
FROM users
WHERE id IN (
SELECT user_id
FROM orders
GROUP BY user_id
HAVING SUM(total) > 1000
);UPDATE users
SET email = '[email protected]'
WHERE name = 'Ada';
DELETE FROM users
WHERE email IS NULL;CREATE INDEX idx_orders_user
ON orders (user_id);
CREATE UNIQUE INDEX idx_users_email
ON users (email);WITH big_spenders AS (
SELECT user_id, SUM(total) AS spent
FROM orders
GROUP BY user_id
HAVING SUM(total) > 500
)
SELECT u.name, b.spent
FROM big_spenders b
JOIN users u ON u.id = b.user_id
ORDER BY b.spent DESC;CREATE TABLE counters (
name TEXT PRIMARY KEY,
hits INTEGER NOT NULL DEFAULT 0
);
INSERT INTO counters (name, hits) VALUES ('home', 1)
ON CONFLICT(name) DO UPDATE SET hits = hits + 1;Yes. This editor runs SQLite entirely in your browser, so you can create tables and run queries without downloading or configuring anything.
It runs SQLite 3.36.0, so syntax and built-in functions match that release.
Yes, the online SQLite editor is completely free to use.
No seed tables are preloaded. You create your own schema with CREATE TABLE, and each run starts fresh, so re-create and re-insert your data in the same script.
SQLite uses dynamic typing with type affinity rather than strict column types, so a column has a preferred type but can hold values of other types unless you add constraints.
