Skip to content

Version 1.1.1 release

Latest
Latest

Choose a tag to compare

View all tags
@ericearl ericearl released this 11 Mar 18:39
· 21 commits to main since this release
v1.1.1
36a475a

SQLite Database Browser

A Python/web-based database browser for querying and visualizing SQLite databases. Built with Plotly Dash, it provides an intuitive interface for loading databases, exploring tables, building advanced search queries, visualizing results with interactive charts, and exporting full filtered results.

Features

  • Database Loading: Load any SQLite database (.sqlite files)
  • Table Browser: View all tables and their metadata (column names, row counts)
  • Advanced Search: Modular filter builder with 11 different operators (equals, contains, comparisons, NULL checks, and more)
  • SQL Query Execution: Write and execute custom SQL queries
  • Results Display: View query results in an interactive HTML table with SQL preview
  • Summary: At-a-glance per-column summary (missingness, unique values, top values, min/max, datatype)
  • Counts Tab: Unique categorical combination counts with configurable aggregation columns, per-column sort controls, plus treemap and sunburst category breakdowns
  • Data Visualization: Built-in histograms, bar charts, and scatter plots with Plotly
  • Statistics: View summary statistics for numeric columns
  • Export: Export filtered query results to TSV (including your SQL query)

Notes

This is the first Zenodo release, and is only a patch release to version 1.1.0 fixing a Counts tab bug.

Assets 2
Loading