perl-modperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thorsten Schöning <tschoen...@am-soft.de>
Subject Re: Storing images in PostgreSQL (was: Streaming files)
Date Tue, 20 Aug 2019 20:24:15 GMT
Guten Tag Randolf Richardson,
am Dienstag, 20. August 2019 um 19:06 schrieben Sie:

>         One of the great things about Perl is that there is more than one
> way to do things, and this flows through to how to handle the storing 
> and retrieving of images.  (Everyone else is welcome to share their 
> perspectives and experiences on this in replies to this message.)

For very similar reasons like you already mentioned we are even
storing user generated files with sometimes hundreds of MiB each in
Postgres currently. Most files are far smaller, though.  Works, but
has cons as well, especially things like too large dumps in the long
term, increased I/O getting things into postgres etc.

Especially properly using RAII-pattern and new file systems like
BTRFS/ZFS in my opinion are the better way to go today/in future. RAII
helps managing things cleanly, snapshots+ACLs can be used to protect
data, both support checksumming for data integrity and replication is
somewhat easily implemented using sending/receiving snapshots as well.
ZFS and ZREP is already used to mirror servers in our setup and works
reliably.

Nevertheless, your mail in my opinion is a good collection of
arguments which I could have written myself as well. :-)

Mit freundlichen Grüßen,

Thorsten Schöning

-- 
Thorsten Schöning       E-Mail: Thorsten.Schoening@AM-SoFT.de
AM-SoFT IT-Systeme      http://www.AM-SoFT.de/

Telefon...........05151-  9468- 55
Fax...............05151-  9468- 88
Mobil..............0178-8 9468- 04

AM-SoFT GmbH IT-Systeme, Brandenburger Str. 7c, 31789 Hameln
AG Hannover HRB 207 694 - Geschäftsführer: Andreas Muchow


Mime
View raw message