Path: csiph.com!aioe.org!.POSTED.dkD5oAtqrRXVimBjhiNUYQ.user.gioia.aioe.org!not-for-mail From: Pankaj Jangid Newsgroups: comp.databases.postgresql Subject: Re: Application architecture for multi-site manufacturing Date: Sun, 22 Sep 2019 19:09:12 +0530 Organization: Code is Great! Lines: 29 Message-ID: References: <877e69h1jg.fsf@x230.onfire.org> NNTP-Posting-Host: dkD5oAtqrRXVimBjhiNUYQ.user.gioia.aioe.org Mime-Version: 1.0 Content-Type: text/plain X-Complaints-To: abuse@aioe.org User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/26.3 (darwin) Cancel-Lock: sha1:yprB7YGdBaAO48A72Cs7VsLgvw0= X-Notice: Filtered by postfilter v. 0.9.2 Xref: csiph.com comp.databases.postgresql:877 Mladen Gogala 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