Toolbox for developers / SQLite browser online

SQLite browser

This tool is a SQLite manager, it allows you to directly create, open, query, update and save a SQLite database.





User guide

This tool is a DB browser for 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.
  • Enter your SQL query in the editor, then click on the button "Execute query" to execute it.

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

    Code editor

  • You can also select a table in order to display its content.

    Select SQLite table

  • If you want to export the results in csv format, click on the button "Export to CSV".
  • Click on the button "Export the database" to export your SQLite database into a SQLi file.

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 is a tool which allows 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. You must know SQL commands in order 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.




SQL Documentation
SELECT
UPDATE
DELETE
INSERT
CREATE TABLE


You can report a bug or give feedback by adding a comment (below) or by clicking "Contact us" link (at the top right hand corner of the page).

Comments




Anonymous - 2018-09-11 19:49
thaaank You Best web Site :)


Cyril (admin) - 2018-09-13 20:23
Thank you for the encouragement ;)



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