pgintcl A free and open source Tcl interface to PostgreSQL
Download

pgintcl Ranking & Summary

pgintcl Tags

interface test PostgreSQL PostgreSQL interface tcl interface PostgreSQL test

pgintcl Description

A free and open source Tcl interface to PostgreSQL pgintcl is an open source Tcl interface to PostgreSQL, which is itself written entirely in Tcl, and does not rely on libpq. pgintcl is highly but not entirely compatible with other Tcl interfaces, although it is slower.pgintcl is tested using a test suite called pgtcltest. This uses the tcltest commands included in Tcl/Tk. pgintcl includes about 200 tests of Pgtcl functions, including timing tests and memory leak tests. The pgtcltest test suite has not been released. Here are some key features of "pgintcl": · Written completely in Tcl · Implements virtually all the standard (bundled) libpgtcl calls · Does large object calls · Supports listen/notify · Supports replacing the notice handler (extension) · Supports the new pg_execute call · Supports PostgreSQL MD5 challenge/response authentication · New pg_result -cmdTuples returns the number of tuples affected by an INSERT, DELETE, or UPDATE (feature in PostgreSQL 7.4 libpgtcl) · Supports distinguishing NULL database values from empty strings (extension) · Implements new pg_result -list, and pg_result -llist (as found Gborg pgtcl) · Implements pg_escape_string (was in beta Gborg pgtcl CVS, but removed), and pg_quote (from Gborg pgtcl) · Execute prepared statements with: pg_exec_prepared, including sending and receiving un-escaped binary data (extension) · Get PostgreSQL parameters with: pg_parameter_status (extension) · Get transaction status with: pg_transaction_status (extension) · Access expanded error message fields with: pg_result -errorField (extension). This was extended to also apply to pg_result -error for compatibility with Gborg pgtcl. · Access extended attribute information with: pg_result -lxAttributes (extension) · Get command status tag with pg_result -cmdStatus (extension) · Separate parse and execute with: pg_exec_params, binary safe · Escape/unescape bytea with: pg_escape_bytea, pg_unescape_bytea Requirements: · PostgreSQL 7.4 or later · Tcl 8.4.4 or later What's New in This Release: · This release adds 4 commands, 2 options to pg_result · supports standard_conforming_strings when escaping strings and bytea data.

pgintcl Related Software