Re: [Gnumed-devel] billing by GnuMed / TORCH / OSCAR

[Horst Herb]

On Fri, 14 May 2004 03:38, Karsten Hilbert wrote:
> I am fine talking to the SQL Ledger schema directly. After
> all, a schema in an RDBMS *is* an API, and a fairly accessible
> one at that.

Unfortunately not. In gnumed I wanted to make the schema the API through the 
use of trigger functions etc. (business logic on the backend), but it's not 
working out as originally intended. We still need some middleware, hence the 
API would interface the middleware and not the schema directly.

By definition, an API grants you safe intentional access.
Modifying a database via direct record access without more information about 
the structure is likely to cause problems.

Horst