Saving Documents in PG vs File system

[Andrew Stolarz]

Mike,

In our use case, other 3rd party applications need to access the files we
save from our Omnis app, so we don't deal with any restrictions etc.


Andrew



On Wed, Nov 14, 2018 at 11:10 AM Michael Matthews via omnisdev-en <
omnisdev-en at lists.omnis-dev.com> wrote:

> 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
>
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
>