Programmer’s Picnic — SQL in Browser (SQLite)
🌙 Dark
Loading SQLite…
📄 CSV:
Run a SELECT
📁
▶
🕘
❓
SQL Editor
Tip:
PRAGMA table_info(table)
,
EXCEPT
(Oracle MINUS), RIGHT/FULL JOIN are emulated.
Ready when SQLite loads.
EDITOR
Show tables
Describe birthdays
FK status
Employees (FK)
Birthdays
Insert sample row
Update sample row
Delete sample row
🔑 Student (Composite PK)
Describe Student
Try PK violation
🎫 Ticket (PK + UNIQUE)
Describe Ticket
Violate UNIQUE (PNR)
Violate UNIQUE (Composite)
🧾 Publications
Subscribers
Try FK fail
🧩 UNION
UNION ALL
INTERSECT
EXCEPT (MINUS)
Only one game
🔗 INNER JOIN
LEFT JOIN
RIGHT JOIN (emulated)
FULL JOIN (emulated)
📊 Cricket_Scores
MAX
MIN
SUM
AVG
COUNT
GROUP BY
Multi-aggregates
HAVING
Max by MatchType
🚆 Trains
Stops
Find trains: Itarsi → Jalgaon
SELECT * FROM birthdays;
Results:
✅ Works offline once loaded. Query history is saved in localStorage on this device.
QUERY HISTORY
Success
Failed
Ready.
Programmer’s Picnic