PgConf.Russia 2017 talks

Optimized use of PostgreSQL in real world production

Roland Sonnenschein
Hesotech GmbH, CEO

Roland develops solutions to control and document technical processes since more than 25 years. PostgreSQL is the backbone for all these applications. Currently he is working on "Industry 4.0" and on an optical camera based system to detect landslides.

Often it is enforced by the customer or even by law, to document the circumstances of the production of parts or lots. This talk is about the automated generation and storage of the corresponding administrative data and their correlation to measurements. Administrative data are entities like suppliers batch, article, serial number or production date. They are often to be exchanged with ERP systems. The development of such applications can be enormously simplified by using the NoSQL features of PostgreSQL, especially json and jsonb. If the database structure mirrors the logic of the production process, further improvements are given.

Our aproach of this optimations will be discussed by means of a currently implemented project to trace cages, filled up with bulk goods, going through a flow production. Each cage successively passes about 50 places and the facts of each step are to be documented. A live simulation will give more illustrations.