sqlite_bro is a simple graphical and tabular SQlite database browser in a single Python script. It comes with administrative functions such as import/export of CSV and SQL data, and provides SQL-embedded Python functions.
Homepage
Download
Recent Releases
0.12.1bis20 Aug 2021 03:15
minor feature:
'backup' and 'restore' functions are accessible via menu (for python =3.7).
.
Running script and displaying output in temporary files is available via icons.
.
Supports running in an environment with no DISPLAY.
.
'backup' and 'restore' features require Python =3.7.
Command-line feature require Python = 3.2.
For Python 3.2, because not handlong well https, you may have to :
Manualy download from pypi (or here) the sqlite_bro-0.12.1.tar.gz into a local "C: toto" directory
do pip install C: toto sqlite_bro-0.12.1.tar.gz
.
Manualy download from pypi (or here) the sqlite_bro-0.12.1.tar.gz into a local "C: toto" directory.
do pip install C: toto sqlite_bro-0.12.1.tar.gz.
it may still work on Python-2.7.
0.12.116 Aug 2021 07:05
minor feature:
'backup' and 'restore' functions are accessible via menu (for python =3.7).
.
Running script and displaying output in temporary files is available via icons.
.
Supports running in an environment with no DISPLAY.
.
'backup' and 'restore' features require Python =3.7.
Command-line feature require Python = 3.2.
For Python 3.2, because not handlong well https, you may have to :
Manualy download from pypi (or here) the sqlite_bro-0.12.1.tar.gz into a local "C: toto" directory
do pip install C: toto sqlite_bro-0.12.1.tar.gz
.
Manualy download from pypi (or here) the sqlite_bro-0.12.1.tar.gz into a local "C: toto" directory.
do pip install C: toto sqlite_bro-0.12.1.tar.gz.
it may still work on Python-2.7.
0.11.110 Aug 2021 20:45
minor feature:
More scripting functions of Sqlite.exe:
'.output', '.print' (output next sql orders or print to a file).
'.dump', '.read' (database exported or imported as SQL orders).
'.open' (database).
'.backup, '.restore' (database exported or imported as database).
.
'.output', '.print' (output next sql orders or print to a file).
'.dump', '.read' (database exported or imported as SQL orders).
'.open' (database).
'.backup, '.restore' (database exported or imported as database).
Infrastructure:
Reformat with 'black -py33' the code
Switch to github actions and pytest
.
Reformat with 'black -py33' the code.
Switch to github actions and pytest.
0.9.223 Apr 2021 03:16
minor feature:
Compatiblity with PyPy:
PyPy doesn't behave the same when executing an empty query (answers 42, very fun but annoying)
PyPy handles well writing to files only via 'with io.open" style of code (implicit closing), but that one is a long known detail of PyPy
.
PyPy doesn't behave the same when executing an empty query (answers 42, very fun but annoying).
PyPy handles well writing to files only via 'with io.open" style of code (implicit closing), but that one is a long known detail of PyPy.
Handle ' ' convention for Home directory.
Indicate Python Executable and Home directory in the Information bubble:
Ease a lot for deing
.
Ease a lot for deing.
0.8.7.204 Sep 2014 01:19
major feature:
Support for .import and .once, and a late fix for .once to default to utf-8-sig encoding on Windows.