Saving Documents in PG vs File system

[Michael Matthews]

How do you stop people rummaging through files & folders?  If at all of course.

Mike

          <http://www.lineal.co.uk/>         

 <https://twitter.com/linealsoftware>  <https://www.facebook.com/linealsoftware?fref=ts&ref=br_tf>  <https://plus.google.com/112982815000763473226/about>  <https://www.linkedin.com/company/1859834?trk=tyah&trkInfo=clickedVertical%3Acompany%2Cidx%3A1-1-1%2CtarId%3A1437729256906%2Ctas%3Alineal%20s>		
Mike Matthews
omnis at lineal.co.uk <mailto:omnis at lineal.co.uk>
Lineal Software Solutions 
01271 375999 
Commercial House, The Strand
Barnstaple, Devon, EX31 1EU 
www.lineal.co.uk <http://www.lineal.co.uk/>

 <http://www.lineal.co.uk/windows-support/>  <http://www.lineal.co.uk/microsoft-office-365/>  <http://www.lineal.co.uk/wifi-networks/>  <http://www.lineal.co.uk/wifi-networks/>  <http://www.lineal.co.uk/it-systems/>  <http://www.lineal.co.uk/gamma-horizon-voip/>  <http://www.lineal.co.uk/kerio/>  <http://www.lineal.co.uk/apple-upgrades-repairs/>  <http://www.lineal.co.uk/eset-security-software/>  <http://www.lineal.co.uk/shoretel/>




> On 14 Nov 2018, at 16:00, Andrew Stolarz <stolarz at gmail.com> wrote:
> 
> Hi Mike,
> 
> With our cloud based app, all files are on Amazon S3. It's a beautiful
> thing.
> 
> With our Omnis thick client app which is deployed to clients sites,
> majority of the files are stored on the file system and not in a database
> due to reasons you already mentioned.
> 
> We are slowly trying to get away from this concept of storing things on
> clients servers etc and are looking to storing files on Amazon S3 directly
> from the think client. Adobe and many others are already using this type of
> approach, it makes the whole user experience better. It will also allow us
> to access the files for other web based things we do outside the thick
> client.
> 
> 
> I believe you can create a tigger in PG that will also do what you are
> after but it might be faster to get it directly from disk in Omnis.
> 
> 
> 
> Andrew
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> On Wed, Nov 14, 2018 at 10:26 AM Michael Matthews via omnisdev-en <
> omnisdev-en at lists.omnis-dev.com> wrote:
> 
>> Hello All,
>> 
>> A question for those of you who store documents in your Omnis system.  We
>> currently do, and we have a separate DB for the storage, and keep the
>> metadata in the main database.
>> 
>> However, in certain cases, the PG database size is now over 100gb when
>> exported.  And 99% of that data is static, so a waste of time in backing it
>> up etc every day.
>> 
>> 1       I could split the database into 2 parts as well, 1 for new items,
>> which will periodically move items to the 2nd archive database.
>> 
>> 2       But I want to explore storing the files in the file system, and
>> passing them to the user when asked for.  Can PostGres save files locally,
>> and then read team and send them back to a user within a SQL call?
>> 
>> 3       I also remember Marten Verhoven showing how he uses Symbolic links
>> to files that would normally be hidden AND inaccessible unless given.
>> 
>> So what do others do at this point with numbers of docs exceeding 100Gb
>> now?
>> 
>> Thank you
>> 
>> Mike
>> 
>>          <http://www.lineal.co.uk/>
>> 
>> <https://twitter.com/linealsoftware>  <
>> https://www.facebook.com/linealsoftware?fref=ts&ref=br_tf>  <
>> https://plus.google.com/112982815000763473226/about>  <
>> https://www.linkedin.com/company/1859834?trk=tyah&trkInfo=clickedVertical%3Acompany%2Cidx%3A1-1-1%2CtarId%3A1437729256906%2Ctas%3Alineal%20s>
>> 
>> Mike Matthews
>> omnis at lineal.co.uk <mailto:omnis at lineal.co.uk>
>> Lineal Software Solutions
>> 01271 375999
>> Commercial House, The Strand
>> Barnstaple, Devon, EX31 1EU
>> www.lineal.co.uk <http://www.lineal.co.uk/>
>> 
>> <http://www.lineal.co.uk/windows-support/>  <
>> http://www.lineal.co.uk/microsoft-office-365/>  <
>> http://www.lineal.co.uk/wifi-networks/>  <
>> http://www.lineal.co.uk/wifi-networks/>  <
>> http://www.lineal.co.uk/it-systems/>  <
>> http://www.lineal.co.uk/gamma-horizon-voip/>  <
>> http://www.lineal.co.uk/kerio/>  <
>> http://www.lineal.co.uk/apple-upgrades-repairs/>  <
>> http://www.lineal.co.uk/eset-security-software/>  <
>> http://www.lineal.co.uk/shoretel/>
>> 
>> 
>> 
>> _____________________________________________________________
>> Manage your list subscriptions at http://lists.omnis-dev.com
>> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
>> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com