> On Nov 15, 2016, at 5:42 PM, Wayne Stewart <[email protected]> wrote: > > I'm planning at some stage to reimplement external storage but when I > do I'm going to do it my way rather than the automatic way.
Me too. I use Postgres to manage over 500,000 external PDF documents, many over 100 pages. You can setup a simple one table structure in Postgres and then store documents there using a two-phase commit approach that ensures consistency. Other advantages: 1. Automatic compression. 2. Great options for backup and replication. 3. If you need to move or synchronize a subset of the documents somewhere else (e.g. a website), it is a database problem rather than a file management problem. John DeSoi, Ph.D. ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
