[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Bug#749275: ITP: libpgobject-util-pseudocsv-perl -- PostgreSQL text representations parser



Package: wnpp
Owner: Robert James Clay <jame@rocasa.us>
Severity: wishlist
X-Debbugs-CC: debian-devel@lists.debian.org,debian-perl@lists.debian.org

* Package name    : libpgobject-util-pseudocsv-perl
  Version         : 1.0.2
  Upstream Author : Chris Travers <chris.travers@gmail.com>
  License         : BSD
  Description     : PGObject::Util::PseudoCSV - parser and constructor for
                    PostgreSQL text representations of tuples and arrays.

PostgreSQL can represent tuples and arrays in a text format that is almost like CSV. Unfortunately this format has a number of gotchas which render existing
CSV-parsers useless.  This module provides basic parsing functions to other
programs for db interface purposes.  With this module you can both parse
pseudocsv representations of tuples and arrays and you can create them from a
list.

The API's here assume you send one (and only one) pseudo-csv record to the API at once. These may be nested, so a single tuple can contain arrays of tuples which can contain arrays of tuples ad infinitum but the parsing only goes one layer deep tuple-wise so that handling classes have an opportunity to re-parse with appropriate type information. Naturally this has performance implications,
so depth in SQL structures passed should be reasonably limited.


Reply to: