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-loador--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.