SQL Editor

iwantcoding.com ships an in-browser SQL editor — a real SQLite engine compiled to WebAssembly, with a sample shop database preloaded. Type SQL on the left, press Run », see the result on the right.

What you can do

• Run any SELECT against the preloaded sample database.
• Run INSERT, UPDATE, DELETE — they affect the in-memory DB until you click Reset DB.
• Run CREATE TABLE, CREATE VIEW, DROP, ALTER — every DDL statement SQLite supports.
• Stack multiple statements separated by ; — each result is shown in turn.
• Pick from 16 ready-made Sample queries in the toolbar dropdown.

The sample shop database

Foreign keys are declared and customers like Ada Lovelace, Grace Hopper, and Linus Torvalds are in the data — so you'll see meaningful names in your joins, not customer_1.

Sample query — try this one

SELECT c.name, SUM(o.total) AS revenue
FROM customers c
JOIN orders    o ON o.customer_id = c.id
WHERE o.status = 'paid'
GROUP BY c.id, c.name
ORDER BY revenue DESC;

Keyboard shortcuts

What engine is it really running?

The editor uses sql.js 1.10 — a build of SQLite 3 compiled to WebAssembly. Everything happens inside your browser tab; no SQL leaves your machine. The same engine ships in iOS apps, Android apps, and embedded inside Laravel test runs.

Example

-- iwantcoding.com SQL editor — type SQL on the left,
-- click Run to see the result table.
SELECT 1 AS hello;

Exercise

Test yourself