IMod New Function: PSQL Event

Online, September 18, 2012 (Newswire.com) - iMod - new function: PSQL Event

A new function has been introduced in the iMod telemetric module - the capability of writing Postgre SQL data to a local or external database using a Message channel.

PostgreSQL is a free system for managing relationship databases. Databases of this type are characterized by an unlimited maximum base size and the possibility for management by means of an internet browser. In addition, it introduces the possibility of using different programming languages and features high stability and efficiency.

The iMod allows for writing of any amount of data from sensors and devices connected to it.* Thanks to a message channel, this data is sent to a PostgreSQL database depending on the type of event that will call it up, or cyclically, every so often. In the first case, it is sufficient to add the appropriate event to a parameter definition (for a change in value, after exceeding the threshold value or for a lack of change in further readings).

The protocol has been defined as SQL, driver - PostgreSQL. The channel port is defined as the IP address of the external database, the access port to it, and the name of the database. In the next lines, the writing method, user name, and access password are given. In the future, the number of possible methods for communication will be increased.

The next step is to define the content of the sent message. According to the syntax of the SQL language

The final step is to force an entry to the PostgreSQL database, depending on the event.

An undoubted advantage of such a function is the capability of writing data onto external disks, which practically allows for the writing of an unlimited amount of information.