BSD Ports

databases/p5-SQL-Statement 1.414 OpenBSD

SQL parsing and processing engine

System
OpenBSD
Repository
OpenBSD ports
Maintainer
Andrew Hewus Fresh <[email protected]>
Categories
databases, perl5

Description

The SQL::Statement module implements a pure Perl SQL parsing and execution engine. While it by no means implements full ANSI standard, it does support many features including column and table aliases, built-in and user-defined functions, implicit and explicit joins, complex nested search conditions, and other features.

SQL::Statement is a small embeddable Database Management System (DBMS). This means that it provides all of the services of a simple DBMS except that instead of a persistent storage mechanism, it has two things: 1) an in-memory storage mechanism that allows you to prepare, execute, and fetch from SQL statements using temporary tables and 2) a set of software sockets where any author can plug in any storage mechanism.

There are three main uses for SQL::Statement. One or another (hopefully not all) may be irrelevant for your needs: 1) to access and manipulate data in CSV, XML, and other formats 2) to build your own DBD for a new data source 3) to parse and examine the structure of SQL statements.

In the other systems

SystemPortVersion
OpenBSDdatabases/p5-SQL-Statement1.414
FreeBSDdatabases/p5-SQL-Statement1.414
NetBSDdatabases/p5-SQL-Statement1.414nb6
DragonFlydatabases/p5-SQL-Statement1.414
MidnightBSDdatabases/p5-SQL-Statement1.414

Install

Binary package:

pkg_add p5-SQL-Statement

From the ports tree:

cd /usr/ports/databases/p5-SQL-Statement && make install

Dependencies

Run dependencies 4