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

  • 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

[edit] kugar

       Reports. All about reports, but seems quite powerful about that, provides
       a kpart (embedding in other applications) and, as part of koffice, is
       perfectly integrated in both kde and koffice
       It doesn't look like a standalone application. You can't even start it with
       an empty document. Provided exemples look good though.

[edit] 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)

[edit] 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)
       TEST 2005-06-26 : rekall 2.2.3 as from gentoo ebuild : can only create a mysql db.

[edit] kexi (also)

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
Personal tools