//#if jqterm //#/if

Initializing app...

On a slow internet connection this may take a moment. If this message displays for "a long time", intialization may have failed and the JavaScript console may contain clues as to why.

Downloading...

This is a placeholder for a terminal-like view which is not in the default build.

RunClear Input

-- ================================================== -- Use ctrl-enter or shift-enter to execute sqlite3 -- shell commands and SQL. -- If a subset of the text is currently selected, -- only that part is executed. -- ================================================== .nullvalue NULL .headers on

Clear OutputInterrupt

About SQLite Fiddle close

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.

Options Load DB... Download DB Reset DB About... Side-by-side Swap in/out Auto-scroll output Auto-clear output WASM: ???