About SQLite Fiddle

Fiddle is a JavaScript application wrapping a WebAssembly build of the SQLite CLI shell, slightly modified to account for browser-based user input. Aside from the different layout, it works just like the CLI shell. This copy was built with SQLite version .

This app is provided in the hope that it may prove interesting or useful but it is not an officially-supported deliverable of the SQLite project. It is subject to any number of changes or outright removal at any time. That said, for as long as it's online we do respond to support requests in the SQLite forum.

This app runs on your device. After loading, it does not interact with the remote server at all. Similarly, this app does not use any HTTP cookies.

Fiddle databases are transient in-memory databases unless they specifically use a persistent storage option (if available, help text in the SQL result output area will indicate how to use persistent storage when this app starts up).

Usage Summary

• In "terminal mode" it accepts input just like the CLI shell does.
• In split-view mode:
  • Input can be executed with either the Run button or tapping one of Ctrl-enter or Shift-enter from within the text input field. If a portion of the input field is selected, only that portion will be run.
  • The various toggle checkboxes can be used to tweak the layout and behaviors. Those toggles are persistent if the JS environment allows it.
• "Terminal mode" is not available in this deployment.
• Databases can be imported and exported using the buttons in the Options toolbar. No specific limit for imported database sizes is imposed, but large databases may cause it to fail with an out-of-memory error.