Awesome Open Source
Awesome Open Source

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 based on the result sets
  • import a CSV file into a SQLite database and visualize imported data
  • manage queries and chart settings and run them against different databases
  • import/export queries and chart settings to/from a JSON file
  • export a modified SQLite database
  • use it offline from your OS application menu like any other desktop app

https://user-images.githubusercontent.com/24638357/117355518-fa332680-aeb2-11eb-8a69-fbcea4f7aeb0.mp4

Quickstart

The latest release of sqliteviz is deployed on GitHub Pages at lana-k.github.io/sqliteviz.

Wiki

For user documentation, check out sqliteviz Wiki.

Motivation

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

Components

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


Get A Weekly Email With Trending Projects For These Topics
No Spam. Unsubscribe easily at any time.
javascript (70,847
visualization (841
sql (733
sqlite (320
data-analysis (289
csv (279
plotting (94
plotly (69
charting (27