[kplato] RDBMS for Kplato

[Jyry Kuukkanen]

On Tue, 19 Jun 2001, Tomas V.V.Cox wrote:

> Hi people,
>=20
> Another idea about this topic and to bypass the tired task of writing
> the same stuff twice (one for the X and other for the Web), the system
> could be built over some kind of open intercommunication platform like
> Corba or XML-RPC.
>=20
> Just some ideas. Regards,
>=20
> Tomas V.V.Cox


Hello


There has been discussion on which dbase to used and of which type.
Tomas's point is more that important for more than one reason.


Let me coin in couple of thoughts.

Wouldn't it make more sense to break this project into three sections:

1) User interface related (web/Local GUI/...)
2) Application functions (create project, allocate resourses etc.)
3) Database connectivity

This propably requires little bit of explaining.

1) UI: This should be pretty clear: the app should not be limited to KDE
only as it would=A0be more than handy to access, say, project status page
through the Web.

2) APP: The reason for separating app functions is that this way we get
more flexible connectivity to both db and UI direction.
At the app level there are objects (task, resource, res.alloc) that
perform tasks (create, delete, allocate something).
As these objects has functions, thay can be accessed from UI (remote or
local) and they can access data in any db (local dBase-III file or
remote SQL server).

3) DB: This is separated from APP because this may be located in
completely different machine. It talks to APP using data objects that are
really data entities. DB side turns them into SQL or dBase codes and
commands and what is returned back to APP is just another data object
gathered from all sorts of data tables.


I think, that enabling to connect these three modules to each other with
*both* local API and SOAP (RPC_XLM) makes a lot more sense than getting
stuck with one UI only.


I'm building currently an all purpose database access tool that uses this
approach and it's coming up nicely.
The prototype is done using PHP and the project is set up at
http://dataz.neutech.fi, but it's at the moment only available in Finnish.
There is, however, a link to solib.tar.gz and dataz.tar.gz that are
licensed under GPL and can be downloaded for further investigation.

I'd be more that happy to answer any questions regarding then things in
this mail :)

--Jyry
C:-(    C:-/    C=3D=3D=3D=3D=3D=3D=3D=3D8-O    C8-/    C:-(