Knobjex under python
Knobjex (under python) is now hosted at Google Code:
On that website the main activities concerning the project will be placed.
On this website Testground I will describe:
- information that can not or difficult be placed on Google Code like:
* screenshots.
* static download-link to the latest software-version.
* static link to a pad-file
- legacy-information concerning Knobjex.
- tools and choices that I have made in programming KnobjexSpecial downloads
Current version: 2.70
Latest automatic setup of Knobjex :setup_knobjex_latest.exe
Latest manual install of Knobjex: Knobjex_install_latest.zip
Pad-file: knobjex_pad_file.xml
Single screenshot: knobjex_mainscreen.jpg
More screenshots: knobjex_screenshots.zip
Knobjex logo/icon: knobjex_icon_large.jpg
Legacy-info
Earlier I developed a MS-Access database named Knobjex. This was a database on itself (tables and queries) plus a program (forms and programming-code in VBA). However the limitations of programming in MS-Access were too big and also I wanted to move to an open-source solution. After some thought I chose Python as programming-language.
The intention has been firstly to build a graphical user-interface in Python around the the Access-database, so that the Access-code would be replaced. This has been done. The second phase was be to replace the Access-db with a Sqlite-database (see comment below). This second phase is also completed. So now a fully open-source solution is be available, and it will also be portable to other non-windows OS's (which can be considered a third phase). However ports to other OS's still have to be made.
Some old screenshots of the python gui can be found here (newer ones can be found in the manual at google code).
Legacy technical details will be found here
pyKnobjex earlier used an Access-database
You will find the legacy-database here
Tools and choices
Which open-source-database (oso-db) do I choose?
I have evaluated below three db's until I choose Sqlite. It's a pity Firebird's open-source gui-admin-tools are hardly updated and limited in functionality. Postgres seems ok but for now I will use Sqlite to able to easily handle, move and exchange db's .
Firebird Postgresql Sqlite single file a plethora of files
(good for stability but bad for exchanging db's)
single file gui oso-admin tools old and poorly maintained main admin-tool (pg-admin?) ok a number of light, freshly developed admin-tools, which, when used together, can do the trick conservatism in db-changes;
can not alter table if it has dependent views
?? yes we can alter table,
but only with some admin-tools (sqlitestudio and sqliteadmin) which probably do some behind-scenes deleting and creating.
server-linked
full multi-user
server-linked
full multi-user
file-linked
partial multi-user
relational relational non-relational (but probably in future and for now do it with triggers)
documentation below-average documentation above average documentation on average Below I describe some features of the various admin-tools; always make a backup before you make an important change. Back you database up regularly anyway. Some of the below tools are less stable in specific situations.
Table with some free Sqlite-admin-tools (still to be completed)
- no shown score: means not yet assessed for presence or effectiveness.
- N: means feature is not present.
- Y means: feature present but not assessed for effectiveness
-following scores: --, - , 0 , + , ++ mean respectively: Bad, weak, mediocre, adequat, good.
> Sqlite = *
V Features
* Admini-strator
0.8.3.2* Studio
1.1.2Tk* wx * plus * Man * Spy * 2008 pro Data-entry + ++ Text-based query-design + ++
(but query-creation gives only small letters!)Visual query-designer +
(views just addable, not editable).Empty table + Show pragma-settings + Import table-data + + --
(overwrites current table-structure without prior notice)Can alter table
(alter anything)++
(can also reorder fields)++
(but can not reorder fields)++ Can alter view ++ 0
(sometimes current view is not read)Stability + + - Vacuum Y Integrity check Y .
