Sqlite Viewer Free Courses › Most Popular Law Newest at www.easy-online-courses.com Courses. Posted: (1 week ago) Use Free Sqlite Reader to View Sqlite Database Files › Discover The Best Online Courses www.sqliteviewer.com Courses.Posted: (3 days ago) Sqlite is the frontend database manager, deployed in various OS, applications and Browsers such as. Get Schema Table Returns a System.Data.DataTable that describes the column metadata of the System.Data.Common.DbDataReader. Get Stream (Int32) Retrieves data as a Stream. If the reader includes rowid (or any of its aliases), a SqliteBlob is returned. Otherwise, the all of the data is read into memory and a MemoryStream is returned.
This SQLite browser allows you to create, open, query, update, export SQL to CSV, save and share a SQLite database. This SQLite viewer online runs directly in your browser.
It is Open source :), you can download the source code here (the repository is not up to date, as soon as I have time, I will update it!). Feel free to improve this tool :) It is still quite new, I hope to improve it over time.
Sqlite Database Browser
User guide
This db browser for SQLite allows you to run SQLite online. 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 'Database file > Open DB 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' 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 (up and down triangles).
You can delete a row by clicking on the associated cross.
You can also directly update a column value by double clicking it. An input will be appear, the row will be updated when the input lose the focus.
You can export table content into CSV file by clicking on 'Export CSV file'. You can choice separator.
You can also add new row into table by clicking on 'Insert a row'. A insert form will be appear.
Click on 'structure' tab to display the SQL of the current table.
Import a CSV file into SQLite table:
Click on 'Import CSV file' to import your CSV / TSV file into a SQLite table.
Show a view:
To show the contents of a view: this is analogous to displaying the contents of a table.
Execute queries:
Enter your SQL query in the editor, finally click on 'Run' to execute it. The query result will be displayed below the editor .
You can also run only one query entered in the editor. To do this, simply select it before clicking on 'Run'.
If you want to export the results in csv format, click on 'Export'.
Export your SQLite database:
Click on 'Database file > Save DB file' 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' menu to share and save your SQLite database.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.Create a SQLite database:
This tool allows you to easily create a SQLite database, there is nothing to do! You can directly execute SQL queries in the editor to manipulate your database.
Autocomplete:
Ctrl-space for autocomplete.