Skip to main content

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

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

Changelog

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


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

sqlite_bro-0.8.2.zip (133.0 kB view hashes)

Uploaded Source

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page