Replacement for MS Access
This document describes kde tools to handle databases. Recently a lot of them have appeared/matured, and that's really disturbing for non-expert, as I am. (see also Database Management)
So I've tried to sum up the differences between them. This document is intended to
- list all of those software
- describe those software, featurewise
- give my opinion about stability/useability
I will only consider free software/open source software.
Contents |
OpenOffice.org
There'e a 'database' component here. Probably not very good, but the most easily available as free software, today.
kexi (other link)
Pretends to be a access competitor. The idea is to store everything in the database : data, form definitions, queries, and so on.
inserting datas, performing queries, processing data, forms.
supports : sqlight 2&3, pgsql, mysql. (Firebird planned) (access planned, in svn)
scripting planned (javascript/python)
TEST 2005-06-26 : from koffice svn as of today. Can create a sqlite file, haven't tested more
Dead ones
knoda
Pretends to be a access competitor
tables, views and queries, forms and reports
scriptable in python
supports : firebird, mysql , pgsql>=7.1, odbc
sqlite2,sqlite3,paradox(read-only),dbase, access(read-only)
2010-03-24: not in gentoo, not on wikipedia, the download page on sf has no file, the webpage mentions compatibility with firefox 1.0. It's dead.
rekall
Pretends to be a access competitor
extract, display and update that data, forms and reports and scripting
scriptable in python
lenghty doc on the web (udpated?)
supports : myusql, pgsql, xbase(xbsql), odbc(mysql,Jet=access)
2005-06-26 TESt : rekall 2.2.3 as from gentoo ebuild : can only create a mysql db. 2010-03-24: not in gentoo, nothing on the mailing list for the last four years. dead.
