Groups | Search | Server Info | Keyboard shortcuts | Login | Register

Groups > comp.databases.postgresql > #875

Re: Application architecture for multi-site manufacturing

Show all headers | View raw

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

> This is a really practicle advice. Thanks. Given the timeline of this
> project I wanted some suggestion to deal with the complexity. And this
> is really a breather. I can certainly apply incremental improvement.

One further thing I noticed during the last few months on a
personal project: if you have time left, you may also think about
how and where to add debugging and logging code.

Making state transition explicit and visible can help
tremendously when something does not operate "as intended". 
I develop some code in PL/pgSQL (triggers and database
functions) and added small if/else branches with RAISE NOTICE
messages.  I can turn on and off such messages with a
configuration table in the database and see how various functions
operate along the way.

>> (*) It is more or less a reply to let you know that there is
>> at least one person who still reads this group.
>
> I really appreciate your reply. Felt so lonely after posting my
> query. Your reply is a hope.

Sure!  If you are further interested in reporting about the
progress, your decisions or tools, please feel free to report
it here.   Your project sounds interesting and maybe, others have
some further hints or tips when reading more about your project.

-- 
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