coleifer/sqlite-web is tracked by TopGit as a data project, with 4.2k stars on GitHub, written primarily in Python. Web-based SQLite database browser written in Python
Snapshot summary built from the project's own GitHub metadata — there's no written TopGit review yet. The page will update automatically when a full review is published.
WHY NO REVIEW YET
TopGit writes full reviews for the most-starred, most-requested repositories. This page is a snapshot until then — see the READ ME tab for the original README in full.
Or run with the high-performance gevent WSGI server (requires gevent):
$ sqlite_wsgi /path/to/db.db
Then navigate to http://localhost:8080/ to view your database.
Features
Works with your existing SQLite databases, or can be used to create new databases.
Add or drop:
Tables
Columns (with support for older versions of Sqlite)
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 (see --enable-load or --enable-filesystem)
Screenshots
The index page shows some basic information about the database, including the
number of tables and indexes, as well as its size on disk:
The structure tab displays information about the structure of the table,
including columns, indexes, triggers, and foreign keys (if any exist). From
this page you can also create, rename or drop columns and indexes.
Columns are easy to add, drop or rename:
The content tab displays all the table data. Links in the table header can be
used to sort the data, foreign-keys are shown as clickable links, and row-data
can be copied easily:
The query tab allows you to execute queries on a table. The query results are
displayed in a table and can be exported to either JSON or CSV. Multiple
queries can be executed, and results for each will be displayed. Data-modifying
queries report the number of rows changed.
The import tab supports importing CSV and JSON files into a table. There is
an option to automatically create columns for any unrecognized keys in the
import file:
The export tab supports exporting all, or a subset, of columns:
Basic INSERT, UPDATE and DELETE queries are supported:
When configured with --enable-load or --enable-filesystem additional
databases can be loaded or unloaded at run-time:
-b, --browser: open a web-browser when sqlite-web starts.
-x, --no-browser: do not open a web-browser when sqlite-web starts.
-P, --password: prompt for password to access sqlite-web.
Alternatively, the password can be stored in the "SQLITE_WEB_PASSWORD"
environment variable, in which case the application will not prompt for a
password, but will use the value from the environment.
-r, --read-only: open database in read-only mode.
-R, --rows-per-page: set pagination on content page, default 50 rows.
-Q, --query-rows-per-page: set pagination on query page, default 1000 rows.
-T, --no-truncate: disable ellipsis for long text values. If this option
is used, the full text value is always shown.
-B, --base64: BLOB data as base64 (default is hex).
-e, --extension: path or name of loadable extension(s). To load
multiple extensions, specify -e [path] for each extension.
-s, --startup-hook: path to a startup hook used to initialize the
connection before each request, e.g. my.module.some_callable. Should
accept one parameter, the SqliteDatabase instance.
No homepage URL was recorded for coleifer/sqlite-web in TopGit's last sync. The README tab above frequently contains screenshots and demo links, or check the repository description on GitHub.
How active is development on coleifer/sqlite-web?
The most recent commit recorded on coleifer/sqlite-web was 12 days ago, based on the GitHub push timestamp. The repository has 408 forks — one of the better signals of community interest.
How many stars does coleifer/sqlite-web have?
coleifer/sqlite-web has 4.2k GitHub stars — refresh the page for the live number, or check github.com/coleifer/sqlite-web. TopGit mirrors GitHub's count but does not claim minute-by-minute accuracy.
What language is coleifer/sqlite-web written in?
coleifer/sqlite-web is written primarily in Python. GitHub's language field is based on the largest share of bytes in the default branch.
What license does coleifer/sqlite-web use?
coleifer/sqlite-web is released under the MIT license. Always verify the LICENSE file directly on GitHub for the authoritative terms — license strings can be edited out of sync with a project's actual stance.
What topics is coleifer/sqlite-web associated with?
GitHub's repository topics for coleifer/sqlite-web: "database", "flask", "python", "sqlite". TopGit's editorial category is Data.
Where do I read more about coleifer/sqlite-web?
This TopGit page is a snapshot — the READ ME tab shows the project's own README content (links stripped, images preserved). The GitHub repository at github.com/coleifer/sqlite-web is the definitive source.
Read full README in the tab above.
Still deciding about sqlite-web?
One click hands the question to an AI along with this page — see what it says about sqlite-web.