- starting Python-3.13, PEP 667 forces us to use a specific dictionnary pydef_locals instead of locals()
- empty columns names are always replaced per the default 'c_nnn' convention
- 'backup' and 'restore' functions are accessible via menu (for python >=3.7)
- running script and displaying output in temporary files is available via icons
- supports running in an environment with no DISPLAY
- supports '.output' and '.print' functions
- supports '.dump' and '.read' functions
- supports '.open' function
- supports '.backup' and '.restore' functions
- switch to github actions and pytest
- supports '.headers on|off' function
- supports '.separator COL' function
- supports '.cd DIRECTORY' function
- supports command-line scripting (see sqlite_bro -h)
- support functions with no parameters or parameters on several lines
- compatiblity with PyPy
- handle '~' convention for Home directory
- indicate Python Executable and Home directory in Information bubble
- previously, un-named Tabs couldn't be renamed nor moved.
- header columns in a .csv file are de-duplicated to avoid error: 'a', 'a', 'a_1' becomes 'a', 'a_2', 'a_1'
- add a combining of functions example: 'py_func1(1*py_func2)', not 'py_func1(py_func2)'
- fixed a nasty tokenizer issue
- clicking on 'F9' key will run current selected instructions (patch by Yuxiang Wang)
- re-structure sql splitting as a generator instead of a list
- remove too long history from pypi front page
- re-structure as a package for Appveyor Continuous Integration tests
- include a global test
- compatibility fix for python 2.7
- wheel packaging format on pypi.org (no user code change)
- '.once' default encoding is 'utf-8-sig' on windows
- '.import' and '.once' support
- use a transaction when importing a csv file
- tabs can be renamed via double-click
- more OS agnostic
- tabs can be dragged with the mouse
- each tab has its closing button
- Ctrl-Z and Ctrl-Y works on Script Text aera
- 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
- support attachement of several databases with the same name
- recognize date formats in .csv importation
- keep memory of last directory used
- improved publishing on Pypi (was tricky, especially the front page)
- create a github project 'sqlite_bro', from 'sqlite_py_manager' baresql example
- discover how to publish on Pypi (hard)
- works with temporary tables
- imported python functions must be validated
- PEP8 alignement
- the pythonic way to generate tokens is 'Yield'
- export SQL + SQL top result in a file in 1 click
- support COMMIT and ROLLBACK
- character INCREASE icon, so the back of the class can see
- make it work as low as Python 2.7 + SQlite 3.6.21
- the GUI is a Class now
- addition of Tooltips over icons
- addition of the Welcome Demo
- birth : need of a ZERO-requirements SQLite Browser for a Python Class