Toolbox for developers / SQLite online

SQLite browser online

Your database
Table
View
Save and Share
Save this SQLite database (and queries) in order to share it (Max: approximately 2 Mo).
SQL Documentation
SELECT
UPDATE
DELETE
INSERT
CREATE TABLE

This SQLite manager allows you to create, open, query, update, save and share a SQLite database. This SQLite viewer online runs directly in your browser.


  • Browse
  • Structure
  • SQL
  • Insert
  • Open SQLite file
  • Export SQLite file






ColumnTypeNullValue

User guide

This tool is a DB browser for SQLite database. You can show, insert, update and delete tables content without knowing SQL.

  • Load a SQLite database:

    Drag and drop your SQLite file directly into the SQLite editor or click on the button "Open SQLite file" to open your SQLite database.

  • Show and manipulate a table:

    You can select a table in order to display and manipulate its content (1). Click on refresh button (2) in order to update tables list.

    Clicks on "Browse" button (3) to display table content. All the rows of the table are displayed. You have the possibility to sort the results according to any of the columns of the table (4).

    You can delete a row by clicking on the associated cross (5).

    You can also directly update a column value by double clicking it (6). An input will be appear, the row will be updated when the input lose the focus.

    You can export table content into CSV file (7). You can choice separator.

    You can also add new row into table (8). A insert form will be appear.

    Select SQLite table and view

    Click on "structure" tab to display the SQL of the current table.

  • Show a view:

    To show the contents of a view: this is analogous to displaying the contents of a table.

  • Execute queries:

    Click on the SQL tab (1), then enter your SQL query in the editor (2), finally click on the button "Execute query" (3) to execute it. The query result will be displayed below the editor (4).

    You can also run only one query entered in the editor. To do this, simply select it before clicking on the button "Execute query".

    If you want to export the results in csv format, click on the button "Export to CSV" (5).

    Code editor
  • Export your SQLite database:

    Click on the "Export the database" button to export your database into a SQLi file.

  • You can save your SQLite database and queries in order to share it. Your SQLite database will be saved on our server. You can protect your share with a password, so only you can change it.
    See "Save and Share" section to share and save your SQLite database.

    Share SQLite db

  • The sql queries entered in the editor are saved so that you will find them during your next visits.
    Warning, this is a local backup in your browser, it can be deleted at any time.


SQLite DB Browser

This database Browser allows you to open SQLite file online in order to create, query, and edit SQLite database files. It is useful for developers wanting to query a database file, it can help test and debug data from a sqlite database. This can also be useful for non-developers. For example to edit browser bookmarks.

This SQL fiddle tool allows you to make SQL online test, you can SQL practice online. Thanks to sharing mode, you can be several to test an online SQL database.

This small tool is useful and allows not to have to install a fat client for occasional use. For everyday use, a fat client may seem more appropriate.

You do not have to know the SQL commands to use this tool.

Online SQL editor

This tool does not require installation, it is totally online, you can make SQL online. Just have a simple browser to use it! It can help to make tests quickly or when it is not possible to install software on its server.


About SQLite

SQLite is not directly comparable to client/server SQL database engines (PostgreSQL, MySQL, ...). SQLite provides local data storage for applications while client/server SQL database engines implements a shared repository of data.

SQLite is an embedded SQL database engine. Data are contained in a single disk file, SQLite reads and writes directly to disk files. SQLite is cross-platform!

SQLite has a full-featured SQL implementation (Tables, indexes, triggers, SELECT, UPDATE, DELELE, VACUUM ...).

SQLite is public domain, it is the most used database engine in the world!

There are several appropriate uses for SQLite:

  • Low-traffic websites
  • Embedded devices
  • Internal or temporary databases
  • Cache
  • ...

To see more visit https://www.sqlite.org/

About SQLite compiled to javascript (sql.js)

sql.js is a port of SQLite to JavaScript (by compiling the SQLite C code with Emscripten), it is MIT licensed. It can be used like any javascript library. And it can be used both in a browser and in Node.js!

Example
	 <script src="lib/sql.js"> </script>
	 <script>
		// Create a database
		var myDatabase = new SQL.Database();
		// Create a table, and insert one row
		myDatabase.run("CREATE TABLE mytable (mycolumn1, mycolumn2, mycolumn3);");
		myDatabase.run("INSERT INTO mytable VALUES (?,?,?)", [1,2,3]);
		// load data
		this.db.each("SELECT mycolumn1, mycolumn2, mycolumn3 FROM mytable", {}, function(row){ 
			// row is now {mycolumn1:1, mycolumn2:2, mycolumn3:3}
		});	
	 </script>
						

A full documentation is available.





The tools are provided "as is", without warranty of any kind, either express or implied.