sqlite-web

Web-based SQLite database browser written in Python

What is sqlite-web?

Web-based SQLite database browser written in Python

Overview of sqlite-web

What it is

sqlite-web is a web-based SQLite database browser written in Python. It depends on Flask, Peewee, and Pygments. It can work with existing SQLite databases or be used to create new databases.

Key features

  • Works with existing SQLite databases or can create new databases.
  • Add or drop tables, columns (with support for older versions of SQLite), and indexes.
  • Export data as JSON or CSV.
  • Import JSON or CSV files.
  • Browse table data.
  • Insert, update, or delete rows.
  • Load and unload databases at run-time (using --enable-load or --enable-filesystem).

Use cases

sqlite-web is suitable for managing SQLite databases through a web interface. It can be used for quick data browsing, editing, importing and exporting data, and performing basic database administration tasks without needing command-line tools.

Getting started

Install sqlite-web via pip: sh $ pip install sqlite-web Run it with a database file: sh $ sqlite_web /path/to/database.db For multiple databases, list them: sh $ sqlite_web /path/to/db1.db /path/to/db2.db /path/to/db3.db Alternatively, use Docker: sh $ docker run -it --rm -p 8080:8080 -v /path/to/your-data:/data ghcr.io/coleifer/sqlite-web:latest db_filename.db For a high-performance gevent WSGI server, use sqlite_wsgi: console $ sqlite_wsgi /path/to/db.db Then navigate to http://localhost:8080/ to view your database.

License and pricing

sqlite-web is released under the MIT License. It is open source and free to use.

Based on the project's public README and repository metadata.

Add this badge to your README

Featured on YunoDB Badge styles & help

Maintain this project? Show that it is featured on YunoDB.

Markdown[![Featured on YunoDB](https://yunodb.com/badge/coleifersqlite-web.svg)](https://yunodb.com/tools/coleifersqlite-web?utm_source=github&utm_medium=badge)
HTML<a href="https://yunodb.com/tools/coleifersqlite-web?utm_source=github&utm_medium=badge"><img src="https://yunodb.com/badge/coleifersqlite-web.svg" alt="Featured on YunoDB" height="20"></a>