Re: orthanc-postgresql

[Karsten Hilbert <Karsten.Hilbert@gmx.net>]

On Mon, Mar 02, 2015 at 12:16:06PM +0100, Sébastien Jodogne wrote:

> I have just created and committed a Debian package for the
> official plugin that replaces the default SQLite database of
> Orthanc, by a PostgreSQL back-end [1].

Delightedly I have noted that PG can be used to store both of
index _and_ the actual DICOM instances (?).

If so, I'd be interested to know which way you chose to store
DICOM instances inside PG -- by means of BYTEA columns or as
large objects ?

	http://www.postgresql.org/docs/9.4/static/datatype-binary.html

	http://www.postgresql.org/docs/9.4/static/largeobjects.html

(that'll influence recommendations regarding
backup/restore/failover)

For what it is worth, GNUmed uses BYTEA (while being aware of
both its benefits and limitations).

Karsten
-- 
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346