Sign Up

PostgreSQL Library by JDP Science - Toolkit for LabVIEW Download

Wrapping of libPQ for PostgreSQL access

D Discussion Watch * 5 ↓2,007
 screenshot
Version0.6.2.48
ReleasedNov 14, 2024
Publisher JDP Science
License BSD
LabVIEW VersionLabVIEW>=19.0
Operating System Windows, Mac, and Linux
Dependencies jdp_science_lib_common_utilities  
Project links Homepage   Repository   Discussion

Description

Connect to PostgreSQL Server databases from LabVIEW.

Easy to start Examples that connect to a public Postgres Server.

Includes libPQ dlls for Windows.
For Linux RT, follow this tutorial to install LibPQ: https://forums.ni.com/t5/NI-Linux-Real-Time-Documents/Tutorial-PostgreSQL-with-LabVIEW/tac-p/4111331
For Mac OSX, install Postgresql and manually supply "Connect.vi" with the the path to the installed libpq.dylib.

See the example "Public Postgres Server, Supported LabVIEW Types" for all data types supported.

May need to run VIPM as admin when installing this package.

Written by James Powell, with improvements by Antoine Chalons and Patrick Irvin.

Release Notes

0.6.2.48 (Nov 14, 2024)

Support Array types (1D and 2D SGL, DBL, I64; 1D Strings)
Add Malleable VIM to do multiple fast INSERTS
0.6.2:
--Allow Mac OSX install (but libPQ.dylib will need to be supplied by path into peinstalled PostgreSQL)
--Support ByteA Binary Data

james-powell was a contributor to this release


Download Package

Versions
All Contributors

  Post an Idea   Post a Resource

Recent Posts

Return Column Headers from SQL results (using PQfname)
The PQfname function returns the associated column headers from SQL commands. Unfortunately, I can…

by Tom McQuillan, 2 years, 2 months ago, 2 , 0
suggestion
Support for scram-sha-256 (/ the latest version of PostgreSQL)
Hi James, I don't know if you're still supporting this library, but it would be great if scram-sha…

by Tom McQuillan, 2 years, 2 months ago, 5 , 0
suggestion
update OS support list for this package
Unless I'm missing something, this package does NOT support macOS and Linux. Can you update the VI…

by Zaphiro Technologies, 3 years, 11 months ago, 1 , 3
suggestion