kambo/duckdb

A PHP library for communication with DuckDB

0.7.0-alpha.2 2024-06-14 17:26 UTC

Requires

• php: ^8.1

Requires (Dev)

• kambo/duckdb-php-linux-lib: 0.7.0
• phpunit/phpunit: ^9.5
• slevomat/coding-standard: ^8
• squizlabs/php_codesniffer: 3.*

MIT

• Bohuslav Simek

• kambo
• duckdb

README

An unofficial DuckDB communication library for PHP.

Installation

You can install the package via composer:

composer require kambo/duckdb kambo/duckdb-php-linux-lib

Note: the kambo/duckdb-php-linux-lib package contains a binary library for Linux.

Usage

$database = new Kambo\DuckDB\Database();
$connection = new Kambo\DuckDB\Connection($database);

$connection->query('CREATE TABLE integers(i INTEGER, j INTEGER);');
$connection->query('INSERT INTO integers VALUES (3,4), (5,6), (7, NULL) ');

$result = $connection->query('SELECT * FROM integers;');

var_export($result->toArray());

Current limitations

• This library is in alpha version.
• It currently only works under Linux (work is ongoing for other platforms).
• It has limited support of DuckDB APIs.

Testing

composer test

Changelog

Please see CHANGELOG for more information on what has changed recently.

License

The MIT License (MIT). Please see License File for more information.