With this release Knoda is the first KDE based database frontend reading MS Access databases natively and so it is getting closer to its goal to be a full replacement for MS Access. The main new features are: * A driver for MS Access based on Mdbtools (http://mdbtools.sourceforge.net) Due to technical restrictions of Mdbtools, the mdb driver is read-only. It is strongly recommended to use the latest CVS version of Mdbtools, so hk_classes-0.7.4_alpha1.ebuild now blocks app-office/mdbtools - mdbtools installed in /usr results in conftest for the mdb driver failing. * A driver for dbase compatible databases based on xbase (http://linux.techass.com/projects/xdb/) * A dialog box to exchange your data between the database backends. (See the menu entries 'Export' and 'Import' in the 'File' menu). It is easily possible to copy your data e.g. from Mysql to Postgres and vice versa. This is not yet available if knoda is started with the --classic switch. There is a new ebuild (xbsql-hk_classes) for the xbase driver. This version of the XBSQL package is compatible to other versions, it just has some bugfixes added and support for the boolean field type. The original version was created for Rekall, but was simply too buggy.
Created attachment 57167 [details] hk_classes-0.7.4_alpha1.ebuild
Created attachment 57168 [details, diff] hk_classes-0.7.4_alpha1-amd64.patch
Created attachment 57169 [details] knoda-0.7.4_alpha1.ebuild
Created attachment 57170 [details] xbsql-hk_classes-0.12.ebuild
I had a problem installing the hk_mdbclasses driver because config.h couldn't be found in /usr/include/. After I symlinked /usr/include/linux/config.h here it was OK. The author (Horst Knorr) has been informed.
0.7.4_alpha2 introduces drivers for Firebird, and Paradox (based on pxlib) databases. With this release all open source SQL servers are directly supported. Also some bugs are fixed. The main new features are: ======================= * Firebird driver (http://www.firebirdsql.org) * Paradox driver (http://pxlib.sourceforge.net), due to technical restrictions of pxlib, the paradox driver is read-only. * The sqlite3 driver supports ALTER TABLE ADD COLUMN (you need at least SQLite version 3.2.0 for this) * data aware image field in forms. The image itself is not stored within the database. The (text)-field should only contain the name and optionally its path of the picture. * possibility to store and load connection information, so login can be much easier. * Queries can store their results in tables.
Created attachment 60257 [details] hk_classes-0.7.4_alpha2.ebuild
Created attachment 60258 [details, diff] hk_classes-0.7.4_alpha2-amd64.patch
Created attachment 60259 [details] knoda-0.7_alpha2.ebuild
please note that the latest version are hk_classes-0.7.4-test2a and knoda-0.7.4-test2.
The attachment at Comment #7 acknowledges this and pulls in hk_classes-0.7.4-test2a
0.7.4-test3 released. New features: =========== * buttons may contain icons, * the data-aware image field may store its data in binary columns, is scaleable and can also act as a non-data-aware widget; * a date widget in forms has been added. * the query designer has a new and simpler 'add datasource'-dialog. * users can select whether a single-click or a double-click opens objects (this feature can be set in the preferences menu). * binary column handling to Firebird and SQLite3 added,
Created attachment 61174 [details] hk_classes-0.7.4_alpha3.ebuild
Created attachment 61175 [details] hk_classes-0.7.4_alpha3.ebuild
Created attachment 61176 [details, diff] hk_classes-0.7.4_alpha3-amd64.patch
Created attachment 61177 [details] knoda-0.7.4_alpha3.ebuild
This is a new stable version of hk_classes and knoda. Main new features: ============ * Firebird driver added * mdb driver (MS Access) added * xbase driver (DBase) added * paradox driver (Corel Paradox) added * Forms improved a lot: * new data-aware image field may store its data in external files or in binary columns, is scaleable and can also act as a non-data-aware widget * Buttons may contain icons * date widget has been added * store and load connection information, so login can be much easier * export/import between databases is possible now * many scripting API improvements (e.g. show_directorydialog(), get_pyvisible() etc.). get_pyvisible is a replacement for the former combination of get_visible() and cast_xxx() functions. * the full documentation (tutorials, references etc.) added is available via <F1>-key * The GUI improved in details Also many bugs are fixed
Created attachment 61924 [details] hk_classes-0.7.4.ebuild
Created attachment 61925 [details, diff] hk_classes-0.7.4-amd64.patch
Created attachment 61926 [details] knoda-0.7.4.ebuild
Ignore. Just checking to see if I get email notification
>Ignore. Just checking to see if I get email notification Well, a second one ;) hk_classes/knoda-0.7.4 are in cvs, but for now without pdx, mdb and xbase. Peter, I'm not sure why you're blocking mdbtools in the ebuild. If I see it correctly we just have to wait for some cvs code being released. Regarding xbase I don't see the point maintaining two different ones. Need to contact the Rekall guys anyways. Did you sent the -fPIC patch upstream as well, if not, would you, please!?
Re. Comment #22, carlo said: > Peter, I'm not sure why you're blocking mdbtools in the ebuild. I remember now - knoda can't deal with MSAccess files with Gentoo's current mdbtools-5.0 ("Due to technical restrictions of Mdbtools, the mdb driver is read-only. It is strongly recommended to use the latest CVS version of Mdbtools"). Now if I have mdbtools-5.0 installed in /usr the same time as mdbtools from CSV installed in /usr/local knoda crashes when it tries to open an MSAccess database - that's why I blocked mdbtools. Maybe there's a better way? > If I see it correctly we just have to wait for some cvs code being released. > Regarding xbase I don't see the point maintaining two different ones. Need > to contact the Rekall guys anyways. Here I quote Horst Knorr again: "To use the xbase driver install the original Dbase/Xbase library first, and then the XBSQL library at http://sourceforge.net/project/showfiles.php?group_id=23940&package_id=150739. This version of the XBSQL package is compatible to other versions, I just added some bugfixes and support for the boolean field type. The original version was created for Rekall, but was simply too buggy.". > Did you sent the -fPIC patch upstream as well, if not, would you, please!? No, because I didn't originate the patch (my arch is x86) and I just kept it up-to-date. But I'll sent it upstream now.
> that's why I blocked mdbtools. Maybe there's a better way? I think we just wait for a sufficient upstream release, before supporting mdb in the Portage tree. No need to block it. Regarding xbsql I'm aware of the situation. I intend to try to convince the Rekall guys to use Horst Knorr's lib and to keep an eye on it together, maybe. Of course it doesn't matter right now, but for the future it's better to have one maintained library upstream. >No, because I didn't originate the patch (my arch is x86) and I just kept it up-to-date. But I'll sent it upstream now. Don't know why this didn't happened earlier. Could be the case, that I'm to blame, so it's better not to look up. Thanks you!
Carsten, Update on the -fPIC patch going upstream; I just received this message from Horst Knorr: Am Dienstag, 28. Juni 2005 00:10 schrieben Sie: > Hi Horst, > > To enable hk_classes to compile on the amd64 architecture, Gentoo > has been applying the attached patch to add the -fPIC flag. I have > been asked if you would incorporate this upstream. > > If you agree, please let me know when it is incorporated, so that we > can stop using the patch. Hi Peter, thanks for the patch. It will be enclosed in the next test-version. If I don't get bug reports ( FreeBSD might be a candidate that makes trouble) the patch will remain in the package. In case I have to remove it I will inform you Regards Horst Carsten, do you forsee problems with FreeBSD and -fPIC?
> Carsten, do you forsee problems with FreeBSD and -fPIC? Um, I'm not the multi-os freak and never ran FreeBSD yet, but I don't see why this should be a problem. It's more a question of the architecture and if it doesn't support position independent code, gcc ignores the flag. Apart from the gcc man page, the hardened herd has a neat description
> Carsten, do you forsee problems with FreeBSD and -fPIC? Um, I'm not the multi-os freak and never ran FreeBSD yet, but I don't see why this should be a problem. It's more a question of the architecture and if it doesn't support position independent code, gcc ignores the flag. Apart from the gcc man page, the hardened herd has a neat description¹. [1] http://www.gentoo.org/proj/en/hardened/pic-internals.xml
mdbtools update: for MSAccess support, currently only the cvs version of mdbtools works with hk_classes. I have tried mdbtools 0.6pre1, as has Horst Knorr, and it doesn't work.
I had installed kde-3.3 and knoda-0.7.3. After upgrading to kde-3.4 I have noticed the presence of knoda file into /usr/kde/3.3/*. Is it normal? Isn't /usr/kde/3.x/ tree only for KDE core applications? # equery f knoda [ Searching for packages matching knoda... ] dev-db/knoda-0.7.3 * Contents of dev-db/knoda-0.7.3: /usr /usr/bin /usr/bin/knoda /usr/bin/knoda-rt /usr/kde /usr/kde/3.3 /usr/kde/3.3/include /usr/kde/3.3/include/hk_kdeboolean.h /usr/kde/3.3/include/hk_kdebutton.h /usr/kde/3.3/include/hk_kdecolumn.h /usr/kde/3.3/include/hk_kdecombobox.h /usr/kde/3.3/include/hk_kdecsvexportdialog.h /usr/kde/3.3/include/hk_kdecsvimportdialog.h /usr/kde/3.3/include/hk_kdecsvimportdialogbase.h /usr/kde/3.3/include/hk_kdedatasource.h /usr/kde/3.3/include/hk_kdedbdesignerpart.h /usr/kde/3.3/include/hk_kdedbdesignerpartfactory.h /usr/kde/3.3/include/hk_kdedblistview.h /usr/kde/3.3/include/hk_kdedriverdialog.h /usr/kde/3.3/include/hk_kdefilterdialog.h /usr/kde/3.3/include/hk_kdefilterdialogbase.h /usr/kde/3.3/include/hk_kdefinddialog.h /usr/kde/3.3/include/hk_kdefinddialogbase.h /usr/kde/3.3/include/hk_kdeform.h /usr/kde/3.3/include/hk_kdeformdatasourcedialog.h /usr/kde/3.3/include/hk_kdeformdatasourcedialogbase.h /usr/kde/3.3/include/hk_kdeformfocus.h /usr/kde/3.3/include/hk_kdeformpart.h /usr/kde/3.3/include/hk_kdeformpartfactory.h /usr/kde/3.3/include/hk_kdeformpartwidget.h /usr/kde/3.3/include/hk_kdegrid.h /usr/kde/3.3/include/hk_kdegridcolumndialog.h /usr/kde/3.3/include/hk_kdegridcolumndialogbase.h /usr/kde/3.3/include/hk_kdegridpart.h /usr/kde/3.3/include/hk_kdegridpartfactory.h /usr/kde/3.3/include/hk_kdeindexeditwindow.h /usr/kde/3.3/include/hk_kdeinterpreterdialog.h /usr/kde/3.3/include/hk_kdelabel.h /usr/kde/3.3/include/hk_kdelineedit.h /usr/kde/3.3/include/hk_kdememo.h /usr/kde/3.3/include/hk_kdemessages.h /usr/kde/3.3/include/hk_kdenewpassworddialog.h /usr/kde/3.3/include/hk_kdenewpassworddialogbase.h /usr/kde/3.3/include/hk_kdepassworddialog.h /usr/kde/3.3/include/hk_kdeproperty.h /usr/kde/3.3/include/hk_kdepropertybase.h /usr/kde/3.3/include/hk_kdeqbe.h /usr/kde/3.3/include/hk_kdeqbepart.h /usr/kde/3.3/include/hk_kdeqbepartfactory.h /usr/kde/3.3/include/hk_kdequery.h /usr/kde/3.3/include/hk_kdequerypart.h /usr/kde/3.3/include/hk_kdequerypartfactory.h /usr/kde/3.3/include/hk_kdequerypartwidget.h /usr/kde/3.3/include/hk_kdereport.h /usr/kde/3.3/include/hk_kdereportdata.h /usr/kde/3.3/include/hk_kdereportpart.h /usr/kde/3.3/include/hk_kdereportpartfactory.h /usr/kde/3.3/include/hk_kdereportpartwidget.h /usr/kde/3.3/include/hk_kdereportproperty.h /usr/kde/3.3/include/hk_kdereportpropertybase.h /usr/kde/3.3/include/hk_kdereportsection.h /usr/kde/3.3/include/hk_kdereportsectiondialog.h /usr/kde/3.3/include/hk_kdereportsectiondialogbase.h /usr/kde/3.3/include/hk_kderowselector.h /usr/kde/3.3/include/hk_kdesimpleform.h /usr/kde/3.3/include/hk_kdesimplegrid.h /usr/kde/3.3/include/hk_kdesimplereport.h /usr/kde/3.3/include/hk_kdesubform.h /usr/kde/3.3/include/hk_kdesubreportdialog.h /usr/kde/3.3/include/hk_kdesubreportdialogbase.h /usr/kde/3.3/include/hk_kdetable.h /usr/kde/3.3/include/hk_kdetabledesign.h /usr/kde/3.3/include/hk_kdetablepart.h /usr/kde/3.3/include/hk_kdetablepartfactory.h /usr/kde/3.3/include/hk_kdetablepartwidget.h /usr/kde/3.3/include/hk_kdetoolbar.h /usr/kde/3.3/include/hk_kdexmlexportdialog.h /usr/kde/3.3/include/hk_kdexmlexportdialogbase.h /usr/kde/3.3/lib /usr/kde/3.3/lib/kde3 /usr/kde/3.3/lib/kde3/libhk_kdedbdesignerpart.la /usr/kde/3.3/lib/kde3/libhk_kdedbdesignerpart.so /usr/kde/3.3/lib/kde3/libhk_kdeformpart.la /usr/kde/3.3/lib/kde3/libhk_kdeformpart.so /usr/kde/3.3/lib/kde3/libhk_kdegridpart.la /usr/kde/3.3/lib/kde3/libhk_kdegridpart.so /usr/kde/3.3/lib/kde3/libhk_kdeqbepart.la /usr/kde/3.3/lib/kde3/libhk_kdeqbepart.so /usr/kde/3.3/lib/kde3/libhk_kdequerypart.la /usr/kde/3.3/lib/kde3/libhk_kdequerypart.so /usr/kde/3.3/lib/kde3/libhk_kdereportpart.la /usr/kde/3.3/lib/kde3/libhk_kdereportpart.so /usr/kde/3.3/lib/kde3/libhk_kdetablepart.la /usr/kde/3.3/lib/kde3/libhk_kdetablepart.so /usr/kde/3.3/lib/libhk_kdeclasses.la /usr/kde/3.3/lib/libhk_kdeclasses.so ...
Closing as knoda-0.7.4 was committed some time ago. The problem in comment #28 should be solved now, too.