Labview Postgresql Connectivity

1
Labview Postgresql Connectivity

• By Robert Emin

2
Data Flow

• Sensor ---gt 16 Gauge Wire
• Data Acquisition Device ---gt USB
• Windows Computer
• Labview
• API
• TCP/IP ---gt Ethernet
• Linux Server
• Postgresql

3
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

4
National Instruments 6211

• Voltage Measurement -10V to 10V
• Analog Input
• Analog Output
• Digital Input
• Digital Output
• Counter
• USB

5
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.

6
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.

7
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.

8
Linux

• This system uses Debian Linux. Free. Stable.
  Secure. Can view the source code. Tools for
  making true real time systems.

9
Postgresql

• Open source. Free. True RDMS and object
  orientated. Robust. Secure. Can see the source
  code.

10
(No Transcript)
11
(No Transcript)
12
(No Transcript)
13
Table Structure

• CREATE TABLE "public"."work_voltage" (
• "voltage" DOUBLE PRECISION NOT NULL,
• "date" DATE DEFAULT 'now'textdate,
• "time" TIME WITHOUT TIME ZONE DEFAULT
  'now'texttime without time zone,
• "identifier" BIGSERIAL,
• CONSTRAINT "work_voltage_pkey" PRIMARY
  KEY("identifier")
• )
• Courtesy of Lloyd Albin

14
Labview Call Library Function
15
Interfacing with the dll
16
(No Transcript)
17
Any Questions???