Skip to content

lana-k/sqliteviz

master
Switch branches/tags

Name already in use

A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?
Code

Latest commit

 

Git stats

Files

Permalink
Failed to load latest commit information.

sqliteviz

Sqliteviz is a single-page offline-first PWA for fully client-side visualisation of SQLite databases or CSV files.

With sqliteviz you can:

  • run SQL queries against a SQLite database and create Plotly charts and pivot tables based on the result sets
  • import a CSV file into a SQLite database and visualize imported data
  • export result set to CSV file
  • manage inquiries and run them against different databases
  • import/export inquiries from/to a JSON file
  • export a modified SQLite database
  • use it offline from your OS application menu like any other desktop app
sqliteviz_demo.mp4

Quickstart

The latest release of sqliteviz is deployed on sqliteviz.com/app.

Wiki

For user documentation, check out sqliteviz documentation.

Motivation

It's a kind of middleground between Plotly Falcon and Redash.

Components

It is built on top of react-chart-editor, PivotTable.js, sql.js and Vue-Codemirror in Vue.js. CSV parsing is performed with Papa Parse.