Re: [Gnumed-devel] Introducing myself and questions on billing/accounting

[Karsten Hilbert]

> >> >             bill.billable_item
> >> >
> >> > might better live in LSMB
> >>
> >> No. It would live in the GNUmed database. It would
> >> periodically/on request reload from LSMB.
> >>
> >> A script can do that. That script (whether periodically or
> >> on-demand matters not) will, indeed, need accounts with LSMB
> >> and with GNUmed. But said accounts can be *very* restricted.
> >
> Why not put it in the db using something like dblink?  (DBILink I
> think requires PL/Perl, not sure if that works on Windows have heard
> it does not work on AIX, but dblink should work).

Sure, that would work, technically. Or else SQL/MED FDWs. Whichever way.

However, it would also make the "select item to bill" functionality
within GNUmed depend on the link to work properly.

The LSMB database may not be installed on the same server as the
GNUmed database. Sure, that's also possible with FDWs/dbi-link but
it is, again, more fragile.

Karsten

-- 
Empfehlen Sie GMX DSL Ihren Freunden und Bekannten und wir
belohnen Sie mit bis zu 50,- Euro! https://freundschaftswerbung.gmx.de