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

Groups > comp.databases.postgresql > #877

Re: Application architecture for multi-site manufacturing

Show all headers | View raw

Mladen Gogala <gogala.mladen@gmail.com> writes:

> You should be aware of the CAP theorem which says that you cannot have
> consistency, availability and partition tolerance at the same time. You 
> can only have 2 of those things. Second, there is no need to re-invent 
> the wheel. There are open source ERP systems in the wild, like Dolibarr 
> or ERPNext. Since they are open source, you can use their data model to 
> build your own system, Business case for ERP  software is usually 
> centralization of resource management and the savings that are the 
> result of central resource management. Your design choice of going 
> distributed seems to contradict the usual wisdom of centralizing the
> ERP systems. I don't say that it cannot work, but it may prove 
> difficult.Last but not least: you should be aware that this is a 
> massive undertaking and that you will need many programmers to complete 
> the task. The only way to keep costs under control is to use Java ORM
> and an application server. Many people know how to use Java and JBoss
> and programmers are relatively easy to come by. All standard ORMs like
> Hibernate, MyBatis and Apache Cayenne support PostgreSQL.

I'll be running the system in a manufacturing scenario. Consistency and
availability are highly desirable in this case. Various sensors will be
setting state in the manufacturing process and every stage of product
must be aware of the correct states all the time.

Finally I decided to create a centralized database. I am using Rust with
Diesel ORM. It runs really fast on Raspberry Pi attached to the sensors.

-- 
Pankaj Jangid

Back to comp.databases.postgresql | Previous | Next — Previous 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