SQLite Viewer A lightweight tabular SQLite viewer and editor
Support Development
PayPal ● 
Bitcoin Address: 1sM2BrTH8BRgt3quiASK8TmYSafutNvDo
 ● 
Dogecoin Address: DFdSGpGMZ2EZVkjyqNrYCEysK92DFPonx4
Advertisement
Screenshot
The "SQLite Viewer" extension is a simple-to-use SQLite viewer and editor. It can browse local database files or server-side database links. The user can also ask the extension to create a new empty database inside your browser memory. There is also a sample database inside the extension for test purposes. In oppose to the other similar applications, this extension loads the database inside the browser memory and only displays the rows that fit into the viewport. By scrolling down, the extension loads more results on demand. By using this method, the user should not worry that the SQLite statement might result in many rows that it might take some time or the application to render the user interface. Upon opening a database, the extension analyses the database to find existing tables then displays the list of tables to the user to select a table that should be browsed. To open another table, simply use the "Manager" tab and open a new tab for an existing database. Each tab also has a command section that can be accessed by Ctrl + E or Command + E. You can execute custom SQLite statements and see the results in the active tab. You can also download the databases later if the modified database is needed.

Features

  1. What is the "SQLite Viewer" add-on and how can I use it?

    SQLite is a fast and reliable database format, but it is a bit of pain when you what to browse a database. This extension is meant to ease the database access without the need to install a native application. This extension works offline. You can browse SQLite databases with a single click. To ease the opening process, the extension offers opening a table on the database by displaying the list of all available tables to the user and preselecting the first available table. Of course, the user can run a custom SQLite query on each tab and see the results by pressing the Enter key. This extension supports a keyboard shortcut for each action that it supports. The user can have multiple tabs for a single database to for instance display different tables on different tabs. You can use Ctrl/Command plus a number key to switch between tabs. To switch to the manager tab simply press Ctrl/Command + Digit1 keys. When running a custom SQLite command, the user should not be worried about the size of the resulting table since this extension only fetches the result that is viewable to the user. Once the end of the table is about to reach, the extension fetches the new results. This way you can open even large tables with a simple command like "SELECT * from TABLE_NAME".

  2. recommended "Gmail™ Notifier (Developer Edition)" extension for Chrome, Firefox, and Edge browsers

    A browser extension to get notified (desktop notification and sound alarm) of unread emails on one or more search queries. This extension supports multiple accounts and does not require credentials to operate. Read more here.

  3. What's new in this version?

    Please check the Logs section.

  4. What is the list of supported keyboard shortcuts?

    Manager
    Open Local DatabaseCtrl + O or Command + O
    Create Empty DatabaseCtrl + D or Command + D
    Open Remote DatabaseCtrl + L or Command + L
    Open Sample DatabaseCtrl + B or Command + B
    New Tab for Active DatabaseCtrl + E or Command + E
    Save Active DatabaseCtrl + S or Command + S
    Table View
    Edit QueryCtrl + E or Cmmand + E
    Focus TableEscape

  5. Does this extension use remote servers to parse the SQLite databases?

    No this extension does not rely on any external resource at all. There is no remote service involved with the opening of databases. This extension uses the Emscripten compiled sql.js library to open SQLite databases in your bbrowser's memory using WebAssembly. When an SQLite Viewer tab is closed, the database is removed from your browser memory and there is no fingerprint after closing the tab. Also, there is no hidden script (aka background script) related to this extension. All the operations occur inside the browser tab to prevent any sort of memory leakage.

  6. Can I use this extension to plot a table?

    No, this extension is meant to display a SQLite query in a table format with auto fetch results on scroll. If you need more advance tool to play with the database, use "SQLite Manager" extension for Chrome or Firefox

Matched Content

Reviews

Please keep reviews clean, avoid the use of improper language and do not post any personal information.
  • <a> Defines an anchor.

    Example: <a href="http://add0n.com">a sample link</a>

  • <pre><code> Syntax Highlighting (Supported languages: Bash, JSON, HTML, JavaScript, and CSS).

    Example: <pre><code class="javascript">var foo = 'bar';</code></pre>

  • <strong> Defines bold text
  • <blockquote> Defines a long quotation
  • <caption> Defines a table caption
  • <cite> Defines a citation
  • <em> Defines italic text
  • <p> Defines a paragraph
  • <span> Defines a section in a document
  • <s> Defines strikethrough text
  • <strike> Defines strikethrough text
  • <u> Defines underlined text
  • <br> Defines a single line break; can be used alone and don't need an ending tag

What's new in this version

Version--
Published--/--/--
Change Logs:
    Last 10 commits on GitHub
    Hover over a node to see more details

    Need help?

    If you have questions about the extension, or ideas on how to improve it, please post them on the  support site. Don't forget to search through the bug reports first as most likely your question/bug report has already been reported or there is a workaround posted for it.

    Open IssuesIssuesForks

    Permissions are explained

    PermissionDescription
    storageto save internal preferences and user settings

    Recent Blog Posts on add0n.com