Transcript Introducing a New Product

Labview Postgresql Connectivity
By Robert Emin
Data Flow
Sensor ---> 16 Gauge Wire
Data Acquisition Device ---> USB
Windows Computer
Labview
API
TCP/IP ---> Ethernet
Linux Server
Postgresql
Allegro 1301 Hall Effect Sensor
Used to measure the presence of a magnetic field.
Hall Effect sensors are used for proximity switching, positioning, speed detection, and current sensing
applications. They are used for electronic compasses, clamp-on sensor, analog multiplication, current sensing,
position and motion sensing, automotive ignition and fuel injection, wheel rotation sensing, industrial
applications, spacecraft propulsion and as many as there is creativity.
4.5 to 6 V input
Ground
2.5 V output
National Instruments 6211
Voltage Measurement -10V to +10V
Analog Input
Analog Output
Digital Input
Digital Output
Counter
USB
Microsoft Windows 7
Most stable version of Windows operating system. Most supported by National
Instruments. Ideal for running real time applications under the Microsoft line of
products.
National Instruments Labview
Most popular product in engineering for data acquisition and control development. It is
a visual development environment Versions for Mac, Linux and Windows. Its programs
and functions are known as VI's. Has been around since 1983 and dominates the
industry.
On Windows, it is an open architecture allowing to directly interface with dll's, activex,
.net and other Windows products.
Postgresql2Labview
A collection of Labview VI's built from dll's belonging to the
Postgresql library libpq. This allows Labview to directly communicate
with Postgresql. Has speed and reliability advantages over other
products.
Linux
This system uses Debian Linux. Free. Stable. Secure. Can view the
source code. Tools for making true real time systems.
Postgresql
Open source. Free. True RDMS and object orientated. Robust.
Secure. Can see the source code.
Table Structure
CREATE TABLE "public"."work_voltage" (
"voltage" DOUBLE PRECISION NOT NULL,
"date" DATE DEFAULT 'now'::text::date,
"time" TIME WITHOUT TIME ZONE DEFAULT
'now'::text::time without time zone,
"identifier" BIGSERIAL,
CONSTRAINT "work_voltage_pkey" PRIMARY
KEY("identifier")
);
Courtesy of Lloyd Albin
Labview Call Library Function
Interfacing with the dll
Any Questions???