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
| System | Port | Version |
|---|---|---|
| OpenBSD | databases/p5-SQL-Statement | 1.414 |
| FreeBSD | databases/p5-SQL-Statement | 1.414 |
| NetBSD | databases/p5-SQL-Statement | 1.414nb6 |
| DragonFly | databases/p5-SQL-Statement | 1.414 |
| MidnightBSD | databases/p5-SQL-Statement | 1.414 |
Install
Binary package:
pkg_add p5-SQL-Statement
From the ports tree:
cd /usr/ports/databases/p5-SQL-Statement && make install