Metadata-Version: 2.0
Name: sqlite-bro
Version: 0.8.7.4
Summary: a graphic SQLite Client in 1 Python file
Home-page: https://github.com/stonebig/sqlite_bro
Author: stonebig
Author-email: write_pull_requests_to_stonebig@github.com
License: MIT license
Keywords: sqlite,gui,ttk,sql
Platform: UNKNOWN
Classifier: Development Status :: 5 - Production/Stable
Classifier: Environment :: Console
Classifier: Intended Audience :: Education
Classifier: License :: OSI Approved :: MIT License
Classifier: Operating System :: OS Independent
Classifier: Programming Language :: Python
Classifier: Programming Language :: Python :: 2.7
Classifier: Programming Language :: Python :: 3
Classifier: Programming Language :: Python :: 3.3
Classifier: Programming Language :: Python :: 3.4
Classifier: Topic :: Scientific/Engineering :: Information Analysis

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


