Knoda is a database frontend for KDE. Besides tables and queries, Knoda lets you create forms and reports, scriptable via Python. With its latest release, Knoda has introduced a driver for MS Access databases (mdb files). Knoda is the first KDE-based database frontend to be able to read MS Access databases natively and is getting closer to its goal to be a full replacement for MS Access.
The mdb driver is based on mdbtools. Another driver has also been added to support read-write access to Dbase (.dbf) files which is based on Xbase.
Also introduced with this version of Knoda is the possibility to import and export to and from different database servers.
Drivers for MySQL, PostgreSQL, SQLite and
ODBC are also available.
Dot Categories:
Comments
Very helpful features!
This will help me to move some legacy databases from MS Access to Linux.
Thanks!
Does this compile on Freebsd yet?
On FreeBSD:
cd /usr/ports/databases/knoda; make install
Don't forget to upgrade your ports tree to the most current version
Ever heard of FreeBSD ports? And if you're going to go all BSD on us, maybe you can learn how to fix source compilation errors while you're at it?
The last 2 versions i tried out of ports failed misreably. Thus why i asked my question.
As far as fixing it myself, i have a day job.. no time for that.
Does this app have the same goals as Kexi?
Which is more complete?
I'm not sure if it has the same high goals as Kexi, but it certainly works more easily and reliably, from what I've seen so far of both.
Give it a try. Knoda is a deceptively powerful little thing, which gets much less press than it deserves :)
No offence, but commit dates for working features compared:
---Kexi: (cvs log from kdenonbeta/keximdb/)
date: 2005/03/06 18:02:24; author: martin; state: Exp; lines: +0 -0
This is keximdb, the MDB file migration driver for Kexi.
MDB files are the native database format of MS Access (and
also some other MS applications). This driver can be used
by Kexi's migration framework to convert simple Access
databases in to native Kexi databases.
Use the keximigratetest program, or use 'Import' - which is
under Kexi's file menu if you follow the instructions at
http://www.kexi-project.org/wiki/wikiview/index.php?AdvancedBuildNotes
- to test.
[...]------------------
(subsequent commits also mentioned in KDE CVS Digest, http://cvs-digest.org/index.php?newissue=mar182005)
---Knoda: (cvs log from cvs.sourceforge.net:/cvsroot/hk-classes/)
date: 2005/03/27 16:33:44; author: knorr; state: Exp;
driver for .mdb files (MS Access) added
-------------------
And BTW, we're importing data and then -opening, not 'opening native' MDB files. Let's avoid vapourware-like statements. :)
"This driver can be used
by Kexi's migration framework to convert simple Access
databases in to native Kexi databases"
Does this mean that complexe Access databases can't be converted? I wonder how advanced are those mdbtools.
Read 4.1 at:
http://www.kexi-project.org/wiki/wikiview/index.php?KexiFAQ#4._Project_&...
The main problem I have with it (using 0.7 on Suse 9.2) is that the interface is very confusing.
Kexi looks fine, but it's hard to find without koffice package, and when I tryied to compile it agains my KDE 3.4, it just didn't worked.
1. For users convenience there are also separate releases outside KOffice, with packages following these quidelines:
http://www.kexi-project.org/wiki/wikiview/index.php?HintsForMakingKexiPa...
2. E.g. Debian, thanks to great cooperation, is well supported for 10 architectures: http://packages.debian.org/unstable/kde/kexi
Regards
why is kexi still labelled 0.1beta? it looks really fullfeatured and last time i checked it was pretty stable.
psst, the jump is planned in a few days or so...
cool :) thanx for the great work, I've tried kexi when it was first posted on the dot before the big framework rewrite and I also tried it last year. I think i'll give a try this time again. I hope Qt4 will make your port to windows easier too.
Yes, I knew there was a separated release, the one that I compiled and didn't worked was this one.
To avoit talking nonsense I'vbe even tryied to compile from CVS, much better, but still can't open a mysql database, and postgres support dosen't compile, even that I have the devel package.
But working with a file database seems ok and works.
It has been over a year since last I looked at what was happening on the Linux Desktop database front. I had foolishly though that nothing had changed and that the best I could hope for was one of the GUI frontends to MySQL. Now I see this!
WOW! There are now three desktop database applications, Kexi, Knoda and Open Office Base and the K programs can read MS Access files. FANTASTIC!
You didn't look very hard a year ago then, or else you should have found Rekall. It has been around since the KDE/Qt2 days. It has seen production use for several years, and it is available as GPL.
It wasn't available under GPL one year ago...
It was, Rekall has been GPL since 17 november 2003. http://dot.kde.org/1069090495/
Rekall is nice but, to my knowledge, it is not able to read MS Access files. Did I miss something?
I think that this app's existence is great. I don't use MS Access myself, but given the desktop popularity of Microsoft Access thanks to its bundling with MS Office Professional, I think it's a terrific thing for more than one client to be able to open Access databases, particularly one that's Free Software.
Kudos to you, and may your application, and any other application that does something similar, be a great success! You already are a success at this point anyway for creating Knoda, as is anyone else who has done similar work.
Thank you, and well done.
--TP
ItÅ just favulous to know that several databse appÅ are now there to read MS Access