sqlite-bro 0.8.8

a graphic SQLite Client in 1 Python file

sqlite_bro : a graphic SQLite browser in 1 Python file

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:

$ 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

Links

• Fork me on GitHub

Changelog

2015-04-16a : v0.8.8 ‘Continuous Integration !’

• re-structure as a package for Appveyor Continuous Integration tests

• include a global test

2014-09-10b : v0.8.7.4 ‘.Import this !’

• compatibility fix for python 2.7

2014-09-10a : v0.8.7.3 ‘.Import this !’

• wheel packaging format on pypi.org (no user code change)

2014-09-03c : v0.8.7.2 ‘.Import this !’

• ‘.once’ default encoding is ‘utf-8-sig’ on windows

2014-09-03b : v0.8.7.1 ‘.Import this !’

• ‘.import’ and ‘.once’ support

2014-08-09a : v0.8.6 ‘Committed to speed’

• use a transaction when importing a csv file

2014-07-02b : v0.8.5 ‘Rename your tabs !’

• tabs can be renamed via double-click

• more OS agnostic

2014-06-30a : v0.8.4 ‘Move your tabs !’

• tabs can be dragged with the mouse

2014-06-28a : v0.8.3 ‘Cross on tabs !’

• each tab has its closing button

• Ctrl-Z and Ctrl-Y works on Script Text aera

2014-06-26a : v0.8.2 ‘Getting to the point’

• switch to no-autocommit mode by default to allow savepoints

• a ‘legacy autocommit’ Open Database option is added

• add an example of COMMIT and ROLLBACK, and an example of SAVEPOINTS

2014-06-25a : v0.8.1 ‘Attach them all !’

• support attachement of several databases with the same name

2014-06-21a : v0.8.0 ‘Mark the date !’

• recognize date formats in .csv importation

2014-06-19a : v0.7.2 ‘Remember me’

• keep memory of last directory used

2014-06-17a : v0.7.1

• improved publishing on Pypi (was tricky, especially the front page)

2014-06-15b : v0.7.0

• create a github project ‘sqlite_bro’, from ‘sqlite_py_manager’ baresql example

• discover how to publish on Pypi (hard)

2014-06-14c : “It’s a long way to temporary !”

• works with temporary tables

2014-06-10a : ‘Sanitizer of Python (xkcd.com/327)’

• imported python functions must be validated

2014-06-09a : ‘The magic 8th PEP’

• PEP8 alignement

2014-06-07a : ‘Yield me a token’

• the pythonic way to generate tokens is ‘Yield’

2014-06-04a : ‘Log me out !’

• export SQL + SQL top result in a file in 1 click

2014-06-01a ‘Commit and Rollback’

• support COMMIT and ROLLBACK

2014-06-03a : ‘See me now ?’

• character INCREASE icon, so the back of the class can see

2014-05-25a : ‘sql everywhere’

• make it work as low as Python 2.7 + SQlite 3.6.21

2014-05-25a : ‘Assassination of Class Room’

• the GUI is a Class now

2014-05-11

• addition of Tooltips over icons

2014-05-06

• addition of the Welcome Demo

2014-05-01

• birth : need of a ZERO-requirements SQLite Browser for a Python Class