Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.postgresql > #873

Re: Application architecture for multi-site manufacturing

Show all headers | View raw

Hello,

Pankaj Jangid <pankaj.jangid@gmail.com> writes:

> I am designing an application for a manufacturing company. And I have
> decided to go with an open source implementation from top to bottom. And
> obviously, PostgreSQL is one of the choices that I have made due to many
> reasons. Most important being its ability to handle large amounts of
> data, speed, and reliability.

That is not such a bad decision, I guess.

[..]
> I want to get advice from the PostgreSQL community on this. I have not
> done multi-site projects in the past. So before going ahead I want to
> have advice on a reasonably futureproof architecture. Any help is
> appreciated.

I can not comment much on the above because I do not have a lot
of experience with designing de-central, big systems(*).  I would
try to find a simple way of dealing with the existing demands and
improve the existing solution incrementally.  Is a Redis cache
really necessary?  If you have a local copy of the data on each
site, the performance of PostgreSQL may be good enough?  Can you
add performance improvements later?  Can you make it modular and
extendable for future demands etc.

Apart from that, more experienced people might be available on
the mailinglist at https://lists.postgresql.org/.  There is a lot
more conversation going on.

(*) It is more or less a reply to let you know that there is
at least one person who still reads this group.
-- 
Christian Barthel <bch@online.de>

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Application architecture for multi-site manufacturing Pankaj Jangid <pankaj.jangid@gmail.com> - 2019-08-19 17:14 +0530
  Re: Application architecture for multi-site manufacturing Christian Barthel <bch@online.de> - 2019-09-15 20:12 +0200
    Re: Application architecture for multi-site manufacturing Pankaj Jangid <pankaj.jangid@gmail.com> - 2019-09-16 02:02 +0530
      Re: Application architecture for multi-site manufacturing Christian Barthel <bch@online.de> - 2019-09-17 20:32 +0200
      Re: Application architecture for multi-site manufacturing Mladen Gogala <gogala.mladen@gmail.com> - 2019-09-21 15:22 +0000
        Re: Application architecture for multi-site manufacturing Pankaj Jangid <pankaj.jangid@gmail.com> - 2019-09-22 19:09 +0530

csiph-web