Hello,
I failed to find a basic but correct Graphic User Interface program for
Sqlite in pure Python 3, with a liberal licence.
==> Did anyone know of something I may have missed ?
As I don't have great goals, I started to build a small one.
I'm posting it there in hope :
- it can be of interest for some Python and Sqlite users,
- some of you can help to improve it more quickly :
. remaining tcl/tk glitches solving,
. better looking icons,
. missing basic functions.
Teaser :
https://github.com/stonebig/baresql/blob/master/examples/sqlite_py_manager.GIF?raw=true
Source : (not very clean source, )
https://github.com/stonebig/baresql/blob/master/examples/sqlite_py_manager.py
Status :
- works on any python 3.3 PC : ONE .py file, only default modules.
- allows to create embedded functions in ... Python,
- GUI to import CSV tables,
- GUI to attach other Sqlite databases,
- multi-Tab, multiple SQL requests and results per 'Tab'
- New query 'Tab' opening via :
. double-clicking on a table '(Definition') field,
. or double-clicking on a table normal field,
To Do :
- cleaning-up the code,
- CSV export,
- CSV import character-set handling (auto-detection of utf-8 utf-16),
- information bubble on the icon bar,
- (what basic function do you think is missing ?)
Headaches :
- the not perfect layout adjustements of 'Frames' inside a 'Tab' Window.
- the refresh of the left-database is closing the tree.
Regards
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
