Skip to main content

sqlite_bro is a tool to browse SQLite databases with any basic python installation.

Features

  • Tabular browsing of a SQLite database

  • 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

  • Easy to distribute : 1 Python source file, 2.7/3.4+ 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 (with python installed)

Example usage

$ sqlite_bro

Screenshot

https://raw.githubusercontent.com/stonebig/sqlite_bro/master/docs/sqlite_bro.GIF

Metadata

Release files for sqlite-bro 0.9.0

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for sqlite-bro 0.9.0
File Size Uploaded
sqlite_bro-0.9.0.tar.gz 26.1 kB Details

Built distribution (wheel)

Table of built distributions (wheels) for sqlite-bro 0.9.0
File Interpreter ABI Platform
sqlite_bro-0.9.0-py2.py3-none-any.whl Python 2, Python 3 none any Details

Total release size: 51.4 kB

Release files / sqlite_bro-0.9.0.tar.gz

Download URL sqlite_bro-0.9.0.tar.gz
Size 26.1 kB
Tags Source
SHA-256 checksum
How to use checksums
45c4375df69b6e15e3e402db3de74ee0e2f9ee1d0dc08c594989dba532d1142e
BLAKE2b-256 checksum
How to use checksums
638c9e30ef8e547fc8df2e1adf923a5d871bb9a1689f4d3c3b1bcf3b3c429f27
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/1.13.0 pkginfo/1.5.0.1 requests/2.21.0 setuptools/41.0.1 requests-toolbelt/0.9.1 tqdm/4.31.1 CPython/3.7.3

Release files / sqlite_bro-0.9.0-py2.py3-none-any.whl

Download URL sqlite_bro-0.9.0-py2.py3-none-any.whl
Size 25.3 kB
Tags Python 2 Python 3
SHA-256 checksum
How to use checksums
91923c331e013a637e4ddee3d84d41e0cf5785517ad8459e796f05b52bf07e4c
BLAKE2b-256 checksum
How to use checksums
e5e1306626ea413134e81bb2a9cf59ce22ef94eff83a3c5a709efc6d21873490
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/1.13.0 pkginfo/1.5.0.1 requests/2.21.0 setuptools/41.0.1 requests-toolbelt/0.9.1 tqdm/4.31.1 CPython/3.7.3

Release history Release notifications | RSS feed

1.3.2

2 release files

1.3.1

2 release files

1.3.0

2 release files

1.2.0

2 release files

1.1.0

2 release files

1.0.0

2 release files

0.14.0

2 release files

0.13.1

2 release files

0.12.1

2 release files

0.9.3

2 release files

0.9.2

2 release files

0.9.1

2 release files

This release

0.9.0 This release

2 release files

0.8.11

1 release file

0.8.10

2 release files

0.8.8

2 release files

0.8.6

1 release file

0.8.5

1 release file

0.8.4

1 release file

0.8.3

1 release file

0.8.2

1 release file

0.8.1

1 release file

0.8.0

1 release file

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page