a graphic SQLite Client in 1 Python file
Project description
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.3+ 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 it from IPython with %load https://raw.githubusercontent.com/stonebig/sqlite_bro/master/sqlite_bro.py
or just copy the file ‘sqlite_bro.py’ to any pc (with python installed)
Example usage
$ sqlite_bro
Screenshot
Links
Changelog
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
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.