sqlite_bro is a tool to browse SQLite (and optionally DuckDB) databases with any basic python installation.
Features
Tabular browsing of a SQLite or DuckDB database
Optional DuckDB engine : open or create a ‘.duckdb’ file (needs ‘pip install duckdb’)
Import/Export of .csv files with auto-detection
Import/Export of .sql script
Export of database creation .sql script
Support of sql-embedded Python functions
support supports command-line scripting if Python>=3.2 (see sqlite_bro -h), with or without Graphic User Interface
Easy to distribute : 1 Python source file, Python and PyPy3 compatible
Easy to start : just launch sqlite_bro
Easy to learn : Welcome example, minimal interface
Easy to teach : Character size, SQL + SQL result export on a click
Installation
You can install, upgrade, uninstall sqlite_bro.py with these commands:
$ apt-get install python3-tk # apt-get install python-tk if you are using python2 $ pip install sqlite_bro $ pip install --upgrade sqlite_bro $ pip uninstall sqlite_bro
or just launch latest version from IPython with %load https://raw.githubusercontent.com/stonebig/sqlite_bro/master/sqlite_bro/sqlite_bro.py or just copy the file ‘sqlite_bro.py’ to any pc and type ‘python sqlite_bro.py’
Example usage
$ sqlite_bro
$ sqlite_bro -h
Screenshots
Links
1 maintainer
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file sqlite_bro-1.2.0.tar.gz.
File metadata
- Download URL: sqlite_bro-1.2.0.tar.gz
- Upload date:
- Size: 42.7 kB
- Tags: Source
- Uploaded using Trusted Publishing? Yes
- Uploaded via: twine/6.1.0 CPython/3.13.14
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
25202763e1da088aaf009b912de21ad71c1b2aebfe6cc640a3ccc7696506bf34
|
|
| MD5 |
d5885f341df16cb7a36ee9536836a504
|
|
| BLAKE2b-256 |
9abacfb780c1cf97ae2a08b1f17daa0a93bb6c65600a8299aecceb90c813f4da
|
Provenance
The following attestation bundles were made for sqlite_bro-1.2.0.tar.gz:
Publisher:
publish.yml on stonebig/sqlite_bro
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
sqlite_bro-1.2.0.tar.gz -
Subject digest:
25202763e1da088aaf009b912de21ad71c1b2aebfe6cc640a3ccc7696506bf34 - Sigstore transparency entry: 2204810006
- Sigstore integration time:
-
Permalink:
stonebig/sqlite_bro@47f1714c854c0f92daacfb09b0dce42cfcd1090f -
Branch / Tag:
refs/tags/v1.2.0 - Owner: https://github.com/stonebig
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
publish.yml@47f1714c854c0f92daacfb09b0dce42cfcd1090f -
Trigger Event:
push
-
Statement type:
File details
Details for the file sqlite_bro-1.2.0-py3-none-any.whl.
File metadata
- Download URL: sqlite_bro-1.2.0-py3-none-any.whl
- Upload date:
- Size: 46.4 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? Yes
- Uploaded via: twine/6.1.0 CPython/3.13.14
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
0e3fcf6748747f8cb9e89f0cdd8b1c9a571386a73577b19635faa16d43d9ca39
|
|
| MD5 |
05d8aaff56d66da26f9df35ef22c1e7b
|
|
| BLAKE2b-256 |
ddd99f8832c09030fc40513af5980408a5ba35c855279ec9dd259968138c905c
|
Provenance
The following attestation bundles were made for sqlite_bro-1.2.0-py3-none-any.whl:
Publisher:
publish.yml on stonebig/sqlite_bro
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
sqlite_bro-1.2.0-py3-none-any.whl -
Subject digest:
0e3fcf6748747f8cb9e89f0cdd8b1c9a571386a73577b19635faa16d43d9ca39 - Sigstore transparency entry: 2204810009
- Sigstore integration time:
-
Permalink:
stonebig/sqlite_bro@47f1714c854c0f92daacfb09b0dce42cfcd1090f -
Branch / Tag:
refs/tags/v1.2.0 - Owner: https://github.com/stonebig
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
publish.yml@47f1714c854c0f92daacfb09b0dce42cfcd1090f -
Trigger Event:
push
-
Statement type:
