Saving Documents in PG vs File system

Andrew Stolarz stolarz at gmail.com
Wed Nov 14 11:00:49 EST 2018


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
>



More information about the omnisdev-en mailing list