Replacement for MS Access

From Freehackers
Jump to: navigation, search

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

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.

Personal tools
Namespaces
Variants
Actions
fh network
Freehackers
Navigation
Toolbox