ipython-sql/NEWS.rst

News
----

0.1
~~~

*Release date: 21-Mar-2013*

* Initial release

0.1.1
~~~~~

*Release date: 29-Mar-2013*

* Release to PyPI

* Results returned as lists

* print(_) to get table form in text console

* set autolimit and text wrap in configuration


0.1.2
~~~~~

*Release date: 29-Mar-2013*

* Python 3 compatibility

* use prettyprint package

* allow multiple SQL per cell

0.2.0
~~~~~

*Release date: 30-May-2013*

* Accept bind variables (Thanks Mike Wilson!)

0.2.1
~~~~~

*Release date: 15-June-2013*

* Recognize socket connection strings

* Bugfix - issue 4 (remember existing connections by case)

0.2.2
~~~~~

*Release date: 30-July-2013*

Converted from an IPython Plugin to an Extension for 1.0 compatibility

0.2.2.1
~~~~~~~

*Release date: 01-Aug-2013*

Deleted Plugin import left behind in 0.2.2

0.2.3
~~~~~

*Release date: 20-Sep-2013*

* Contributions from Olivier Le Thanh Duong:

  - SQL errors reported without internal IPython error stack

  - Proper handling of configuration

* Added .DataFrame(), .pie(), .plot(), and .bar() methods to
  result sets

0.3.0
~~~~~

*Release date: 13-Oct-2013*

* displaylimit config parameter

* reports number of rows affected by each query

* test suite working again

* dict-style access for result sets by primary key

0.3.1
~~~~~

* Reporting of number of rows affected configurable with ``feedback``

* Local variables usable as SQL bind variables

0.3.2
~~~~~

* ``.csv(filename=None)`` method added to result sets

0.3.3
~~~~~

* Python 3 compatibility restored
* DSN access supported (thanks Berton Earnshaw)

0.3.4
~~~~~

* PERSIST pseudo-SQL command added

0.3.5
~~~~~

* Indentations visible in HTML cells
* COMMIT each SQL statement immediately - prevent locks

0.3.6
~~~~~

* Fixed issue #30, commit failures for sqlite (thanks stonebig, jandot)

0.3.7
~~~~~

* New `column_local_vars` config option submitted by darikg
* Avoid contaminating user namespace from locals (thanks alope107)

0.3.7.1
~~~~~~~

* Avoid "connection busy" error for SQL Server (thanks Andrés Celis)

0.3.8
~~~~~

* Stop warnings for deprecated use of IPython 3 traitlets in IPython 4 (thanks graphaelli; also stonebig, aebrahim, mccahill)
* README update for keeping connection info private, from eshilts

0.3.9
~~~~~

* Fix truth value of DataFrame error (thanks michael-erasmus)
* `<<` operator (thanks xiaochuanyu)
* added README example (thanks tanhuil)
* bugfix in executing column_local_vars (thanks tebeka)
* pgspecial installation optional (thanks jstoebel and arjoe)
* conceal passwords in connection strings (thanks jstoebel)

0.3.9
~~~~~

* Restored Python 2 compatibility (thanks tokenmathguy)

0.4.0
~~~~~

* Changed most non-SQL commands to argparse arguments (thanks pik)
* User can specify a creator for connections (thanks pik)
* Bogus pseudo-SQL command `PERSIST` removed, replaced with `--persist` arg
* Turn off echo of connection information with `displaycon` in config
* Consistent support for {} variables (thanks Lucas)

0.4.1
~~~~~

* Fixed .rst file location in MANIFEST.in 
* Parse SQL comments in first line
* Bugfixes for DSN, `--close`, others

0.5.0 
~~~~~

* Use SQLAlchemy 2.0 
* Drop undocumented support for dict-style access to raw row instances
Skeleton as created by modern-package-template 2013-03-21 00:55:52 +08:00			`News`
cleanup rst docs 2020-05-02 22:07:14 +08:00			`----`
Skeleton as created by modern-package-template 2013-03-21 00:55:52 +08:00
			`0.1`
cleanup rst docs 2020-05-02 22:07:14 +08:00			`~~~`
Skeleton as created by modern-package-template 2013-03-21 00:55:52 +08:00
readme prepared 2013-03-21 11:35:19 +08:00			`Release date: 21-Mar-2013`
Skeleton as created by modern-package-template 2013-03-21 00:55:52 +08:00
readme prepared 2013-03-21 11:35:19 +08:00			`* Initial release`
v0.3.4 Added PERSIST pseudo-SQL keyword 2014-08-26 18:35:41 +08:00
Store .sql with query result Additions to docs 2013-03-29 20:49:00 +08:00			`0.1.1`
cleanup rst docs 2020-05-02 22:07:14 +08:00			`~~~~~`
Store .sql with query result Additions to docs 2013-03-29 20:49:00 +08:00
updated NEWS.txt 2013-03-29 22:36:49 +08:00			`Release date: 29-Mar-2013`
Store .sql with query result Additions to docs 2013-03-29 20:49:00 +08:00
			`* Release to PyPI`

			`* Results returned as lists`

			`* print(_) to get table form in text console`

updated NEWS.txt 2013-03-29 22:36:49 +08:00			`* set autolimit and text wrap in configuration`

v0.3.4 Added PERSIST pseudo-SQL keyword 2014-08-26 18:35:41 +08:00
Converted to prettytable 2013-03-30 00:58:16 +08:00			`0.1.2`
cleanup rst docs 2020-05-02 22:07:14 +08:00			`~~~~~`
Converted to prettytable 2013-03-30 00:58:16 +08:00
			`Release date: 29-Mar-2013`

			`* Python 3 compatibility`
Skeleton as created by modern-package-template 2013-03-21 00:55:52 +08:00
Converted to prettytable 2013-03-30 00:58:16 +08:00			`* use prettyprint package`
Allow multiple SQL per cell. Because why not? 2013-03-30 01:33:22 +08:00
			`* allow multiple SQL per cell`
Accept bind variables (thanks Mike Wilson) 2013-05-31 05:03:39 +08:00
			`0.2.0`
cleanup rst docs 2020-05-02 22:07:14 +08:00			`~~~~~`
Accept bind variables (thanks Mike Wilson) 2013-05-31 05:03:39 +08:00
			`Release date: 30-May-2013`

			`* Accept bind variables (Thanks Mike Wilson!)`

Issue 2: permit postgresql socket connections Issue 4: recognize existing connections with case-sensitivity 2013-06-15 22:58:34 +08:00			`0.2.1`
cleanup rst docs 2020-05-02 22:07:14 +08:00			`~~~~~`
Issue 2: permit postgresql socket connections Issue 4: recognize existing connections with case-sensitivity 2013-06-15 22:58:34 +08:00
			`Release date: 15-June-2013`

			`* Recognize socket connection strings`

			`* Bugfix - issue 4 (remember existing connections by case)`
v0.2.2 Changed plugin to extension 2013-07-30 12:40:17 +08:00
			`0.2.2`
cleanup rst docs 2020-05-02 22:07:14 +08:00			`~~~~~`
v0.2.2 Changed plugin to extension 2013-07-30 12:40:17 +08:00
			`Release date: 30-July-2013`

			`Converted from an IPython Plugin to an Extension for 1.0 compatibility`

Corrected mistakenly retained Plugin import 2013-08-02 03:49:07 +08:00			`0.2.2.1`
cleanup rst docs 2020-05-02 22:07:14 +08:00			`~~~~~~~`
Corrected mistakenly retained Plugin import 2013-08-02 03:49:07 +08:00
			`Release date: 01-Aug-2013`

Documentation for v0.2.3 2013-09-21 07:52:11 +08:00			`Deleted Plugin import left behind in 0.2.2`

			`0.2.3`
cleanup rst docs 2020-05-02 22:07:14 +08:00			`~~~~~`
Documentation for v0.2.3 2013-09-21 07:52:11 +08:00
			`Release date: 20-Sep-2013`

v0.3.4 Added PERSIST pseudo-SQL keyword 2014-08-26 18:35:41 +08:00			`* Contributions from Olivier Le Thanh Duong:`

			`- SQL errors reported without internal IPython error stack`
make short_error default to TRUE update docs 2013-09-21 10:38:37 +08:00
v0.3.4 Added PERSIST pseudo-SQL keyword 2014-08-26 18:35:41 +08:00			`- Proper handling of configuration`

			`* Added .DataFrame(), .pie(), .plot(), and .bar() methods to`
Fix ReST formatting issues. 2017-05-30 01:48:22 +08:00			`result sets`
Documentation for v0.2.3 2013-09-21 07:52:11 +08:00
Updated docs for v0.3.0 2013-10-14 10:14:05 +08:00			`0.3.0`
cleanup rst docs 2020-05-02 22:07:14 +08:00			`~~~~~`
Updated docs for v0.3.0 2013-10-14 10:14:05 +08:00
			`Release date: 13-Oct-2013`

			`* displaylimit config parameter`

			`* reports number of rows affected by each query`

			`* test suite working again`

Made feedback a configurable 2013-11-06 07:09:46 +08:00			`* dict-style access for result sets by primary key`

			`0.3.1`
cleanup rst docs 2020-05-02 22:07:14 +08:00			`~~~~~`
Made feedback a configurable 2013-11-06 07:09:46 +08:00
v0.3.4 Added PERSIST pseudo-SQL keyword 2014-08-26 18:35:41 +08:00			* Reporting of number of rows affected configurable with ``feedback``
Use local_ns 2013-11-14 03:18:50 +08:00
			`* Local variables usable as SQL bind variables`

Docs added for .csv 2014-01-15 05:27:11 +08:00			`0.3.2`
cleanup rst docs 2020-05-02 22:07:14 +08:00			`~~~~~`
Docs added for .csv 2014-01-15 05:27:11 +08:00
			* ``.csv(filename=None)`` method added to result sets

v0.3.3 marked 2014-07-28 09:22:07 +08:00			`0.3.3`
cleanup rst docs 2020-05-02 22:07:14 +08:00			`~~~~~`
v0.3.3 marked 2014-07-28 09:22:07 +08:00
			`* Python 3 compatibility restored`
			`* DSN access supported (thanks Berton Earnshaw)`

v0.3.4 Added PERSIST pseudo-SQL keyword 2014-08-26 18:35:41 +08:00			`0.3.4`
cleanup rst docs 2020-05-02 22:07:14 +08:00			`~~~~~`
v0.3.4 Added PERSIST pseudo-SQL keyword 2014-08-26 18:35:41 +08:00
			`* PERSIST pseudo-SQL command added`
Record indentation display improvement in history 2015-01-07 09:33:26 +08:00
			`0.3.5`
cleanup rst docs 2020-05-02 22:07:14 +08:00			`~~~~~`
Record indentation display improvement in history 2015-01-07 09:33:26 +08:00
			`* Indentations visible in HTML cells`
Commit every SQL execution immediately 2015-01-31 03:59:17 +08:00			`* COMMIT each SQL statement immediately - prevent locks`
Record indentation display improvement in history 2015-01-07 09:33:26 +08:00
v0.3.6. Fix issue #30, OperationalError in sqlite. 2015-05-20 09:11:47 +08:00			`0.3.6`
cleanup rst docs 2020-05-02 22:07:14 +08:00			`~~~~~`
v0.3.6. Fix issue #30, OperationalError in sqlite. 2015-05-20 09:11:47 +08:00
			`* Fixed issue #30, commit failures for sqlite (thanks stonebig, jandot)`

Advance version to 0.3.7 2015-07-19 07:03:35 +08:00			`0.3.7`
cleanup rst docs 2020-05-02 22:07:14 +08:00			`~~~~~`
Advance version to 0.3.7 2015-07-19 07:03:35 +08:00
			* New `column_local_vars` config option submitted by darikg
Credit to alope107 for pull request 2015-07-19 11:01:12 +08:00			`* Avoid contaminating user namespace from locals (thanks alope107)`
Mark version 0.3.7.1 2015-09-11 07:47:07 +08:00
			`0.3.7.1`
cleanup rst docs 2020-05-02 22:07:14 +08:00			`~~~~~~~`
Mark version 0.3.7.1 2015-09-11 07:47:07 +08:00
			`* Avoid "connection busy" error for SQL Server (thanks Andrés Celis)`
Credit multiple submitters of IPython 4 compatibility warnings 2016-03-04 13:51:22 +08:00
			`0.3.8`
cleanup rst docs 2020-05-02 22:07:14 +08:00			`~~~~~`
Credit multiple submitters of IPython 4 compatibility warnings 2016-03-04 13:51:22 +08:00
Begin v 0.3.9, add test for autopandas 2016-10-11 05:22:28 +08:00			`* Stop warnings for deprecated use of IPython 3 traitlets in IPython 4 (thanks graphaelli; also stonebig, aebrahim, mccahill)`
Update NEWS.txt 2016-03-04 14:05:27 +08:00			`* README update for keeping connection info private, from eshilts`

Begin v 0.3.9, add test for autopandas 2016-10-11 05:22:28 +08:00			`0.3.9`
cleanup rst docs 2020-05-02 22:07:14 +08:00			`~~~~~`
Begin v 0.3.9, add test for autopandas 2016-10-11 05:22:28 +08:00
			`* Fix truth value of DataFrame error (thanks michael-erasmus)`
Documented `<<` operator 2017-03-04 22:09:22 +08:00			* `<<` operator (thanks xiaochuanyu)
			`* added README example (thanks tanhuil)`
			`* bugfix in executing column_local_vars (thanks tebeka)`
Clarify README on pgspecial commands 2018-02-18 12:45:55 +08:00			`* pgspecial installation optional (thanks jstoebel and arjoe)`
Selection of existing connection works with concealed password 2018-04-06 10:14:12 +08:00			`* conceal passwords in connection strings (thanks jstoebel)`
Fixed Python 2 setup. Closes #117. 2018-09-03 09:56:06 +08:00
			`0.3.9`
cleanup rst docs 2020-05-02 22:07:14 +08:00			`~~~~~`
Fixed Python 2 setup. Closes #117. 2018-09-03 09:56:06 +08:00
Merge branch 'meta-commands' of git://github.com/pik/ipython-sql into pik-meta-commands 2020-01-19 16:31:52 +08:00			`* Restored Python 2 compatibility (thanks tokenmathguy)`

			`0.4.0`
cleanup rst docs 2020-05-02 22:07:14 +08:00			`~~~~~`
Merge branch 'meta-commands' of git://github.com/pik/ipython-sql into pik-meta-commands 2020-01-19 16:31:52 +08:00
			`* Changed most non-SQL commands to argparse arguments (thanks pik)`
			`* User can specify a creator for connections (thanks pik)`
credit for displaycon in NEWS 2020-01-20 23:06:38 +08:00			* Bogus pseudo-SQL command `PERSIST` removed, replaced with `--persist` arg
cleanup rst docs 2020-05-02 22:07:14 +08:00			* Turn off echo of connection information with `displaycon` in config
			`* Consistent support for {} variables (thanks Lucas)`
Parse SQL comments in first line 2020-05-11 04:58:03 +08:00
			`0.4.1`
			`~~~~~`

			`* Fixed .rst file location in MANIFEST.in`
update NEWS for release 2022-06-12 12:13:21 +08:00			`* Parse SQL comments in first line`
Explicitly require SQLAlchemy 2.0 2023-02-26 12:57:18 +08:00			* Bugfixes for DSN, `--close`, others

			`0.5.0`
			`~~~~~`

			`* Use SQLAlchemy 2.0`
			`* Drop undocumented support for dict-style access to raw row instances`