Page Inspect

SQLite Viewer Web App

# SQLite Viewer Web App

SQLite Viewer Web is a free, web-based SQLite Explorer, inspired by *DB Browser for SQLite* and *Airtable*.

Use this web-based SQLite Tool to quickly and easily inspect `.sqlite` files.

Your data stays **private**: Everything is done **client-side** and never leaves your browser.

App renders here. You need to enable JavaScript to run this app.

## Features

- Works everywhere: Fully web-based and platform-independent
- Fast UI with virtualized scrolling, sorting, filtering, etc.
- SQLite-based full text search
- Pin columns, rows for better viewing experience
- Extract and download embedded BLOBs

## Caveats

There are limits to what a web-based SQLite tool can do:

- Cached and Readonly
- Only works for files that fit in system memory
- Requires uncorrupted files, i.e. `-journal` and `-wal` files are ignored

## 🚨 SQLite Viewer 2

Beta test the next version of SQLite Viewer at beta.sqliteviewer.app

New features include:

- Rewritten from the ground up for improved performance and reduced memory usage
- SQLite files no longer loaded in memory! Files are now copied to the site's own file system (Chrome/Safari Technology Preview only)
- Various UI changes and additions
- New detail view when using the app in standalone mode (PWA/Chrome only)

**Note that it is betaware. There will be bugs, missing features and unfinished UI elements.**

## VS Code Extension

Using VS Code? Not a fan of *Ninetees A E S T H E T I C S* ? Install the VSCode Extension instead!

## License

Copyright © 2023 Florian Klampfer \[email protected\] (https://qwtel.com/)

All rights reserved.

This distribution also includes software licensed under the following terms:

`@react-hook/resize-observer` : MIT

> Copyright (c) 2019 Jared Lunde

`@react95/core` : MIT

> Copyright (c) 2018 React95

`@yaireo/relative-time` : MIT

> Copyright 2019 Yair Even-Or

`allotment` : MIT

> Copyright (c) 2021 John Walley
> Copyright (c) 2021 Gobalsky Labs Ltd.
> Copyright (c) 2015 - present Microsoft Corporation

`browser-fs-access` : Apache-2.0

> Copyright 2020 Google Inc.

No changes were made.

`classnames` : MIT

> Copyright (c) 2018 Jed Watson

`core-js-pure` : MIT

> Copyright (c) 2014-2021 Denis Pushkarev

`history` : MIT

> Copyright (c) React Training 2016-2020
> Copyright (c) Remix Software 2020-2021

`kv-storage-polyfill` : Apache-2.0

> Copyright 2019 Google Inc.

No changes were made.

`react` : MIT

> Copyright (c) Facebook, Inc. and its affiliates.

`react-dnd` : MIT

> Copyright (c) 2015 Dan Abramov

`react-dnd-html5-backend` : MIT

> Copyright (c) 2015 Dan Abramov

`react-dom` : MIT

> Copyright (c) Facebook, Inc. and its affiliates.

`react-fast-compare` : MIT

> Copyright (c) 2018 Formidable Labs
> Copyright (c) 2017 Evgeny Poberezkin

`react-hotkeys-hook` : MIT

> Copyright (c) 2018 Johannes Klauss

`react-modal` : MIT

> Copyright (c) 2017 Ryan Florence

`react-router` : MIT

> Copyright (c) React Training

`react-router-dom` : MIT

> Copyright (c) React Training

`react-table` : MIT

> Copyright (c) 2016 Tanner Linsley

`react-virtual` : MIT

> Copyright (c) 2019 Tanner Linsley

`sql.js` : MIT

> Copyright (c) 2017 sql.js authors (see AUTHORS)

> Ophir LOJKINE \[email protected\] (https://github.com/lovasoa)
> @kripken
> @hankinsoft
> @firien
> @dinedal
> @taytay
> @kaizhu256
> @brodybits

`styled-components` : MIT

> Copyright (c) 2016-present Glen Maddern and Maximilian Stoiber

Workbox : MIT

> Copyright 2018 Google LLC

Chinook Database : MIT

> Copyright (c) 2008-2017 Luis Rocha