Avi Silberschatz

Henry F. Korth

S. Sudarshan

Using sql.js: SQLite running entirely in your browser

This page shows you how to run SQL queries right in your browser. using sql.js, which is basically SQLite C code compiled into Javascript. Your data will not get saved automatically, but you can download your data and upload it again next time you need it.

• We have created a page with the university schema and the small University relations data preloaded; Click here to go to the Web based SQL interface.
• Follow the two steps below only if you have problems with using the above page:
  1. First download the SQLite database file so you have the university database ready in a form that you can load into sql.js:
  2. Now go to: https://sql.js.org/examples/GUI/index.html and and upload the database.
• Now go ahead and run your queries. Save the database at the end if you want to.
• The SQLite syntax mostly matches standard SQL syntax, and most of the queries in the book will run fine on SQLite. We will add any syntax differences here as we find them.