Homepage

SQLite Viewer

Easily view any SQLite database with this web application. You can also run SQLite commands within the app.
Logo

Advertisement

About

With the SQLite viewer web application, you can easily open and view any SQLite database in your browser. You can also run custom SQLite commands and execute them with the SQLite engine. This web application uses "sql-js" and "codemirror" javascript libraries.

Description

Please wait for the app to loads completely, then start using it by dropping an SQLite database or writing your SQLite commands. Next, please press on the execute button (green color) to execute your commands. The result will be rendered in the app UI, bottom section. There is also a sample command button to insert a few sample commands in the editor area. Once you see the commands, please press on the - Execute - button. There is also a print button to print the rendered results (i.e. print to pdf).

This addon uses two open-source javascript projects. This first one is sql-js which is the core engine for compiling SQLite commands. It is a C++ project that is imported to Javascript with Emscripten library. For editing SQLite commands, this app uses CodeMirror library. If you want to report the results to a PDF document, please press on the print button, then choose a PDF writer as the printer.

This web app does NOT send or store your SQLite database file(s) to any remote server; everything happens locally on your machine (browser). Therefore, it is safe to use in terms of privacy and security.

This app is also available as a progressive web application. Please load the app in a browser that supports PWA, then follow the instructions to add the PWA to your mobile device. The first time you load the app, it fetches the data from the internet so it might be a little slow in loading. But, the next time you open the app it loads much faster as, all the data are cached in the memory. SQLite Viewer app is also available as a browser extension. As an extension, this app does not need an internet connection and can be used offline in your browser. Download links for three popular browsers are as follows: Chrome, Opera, Edge, Firefox.

Related Blog Posts

  1. How Can Zero-Width Characters Fingerprinting Be Detected: Just about every modern web browser that one uses supports zero-width characters. The characters might be added on to the text of a page without the user even knowing, as, the characters cannot be identified by the naked eye...
  2. Clear Browser Cache: Just about everyone wants to know how to clear browser cache for their browser (Chrome, Firefox and Opera). It is an important diagnostic after all when one is having issues with the website loading or privacy...
Comments and feedback