skip to navigation
skip to content

Not Logged In

sqlite_bro 0.7.0

a graphic SQLite Client in 1 Python file

Latest Version: 0.8.7.4

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
----------

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

Links
-----

* `Fork me on GitHub <http: github.com="" stonebig="" sqlite_bro="">`_

Changelog
=========


2014-06-15 :
------------

* 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  
File Type Py Version Uploaded on Size
sqlite_bro-0.7.0.zip (md5) Source 2014-06-15 128KB
  • Downloads (All Versions):
  • 3 downloads in the last day
  • 214 downloads in the last week
  • 458 downloads in the last month