Download the PHP package jakiboy/pducky without Composer
On this page you can find all versions of the php package jakiboy/pducky. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Please rate this library. Is it a good library?
Informations about the package pducky
Pducky
This is a basic PHP DuckDB adapter, that executes SQL queries on large data files (CSV).
Using SQLite database & automated CSV parser.
-Its actualy a "POC" alpha version, Wokring in progress on a built-in PHP API for DuckDB-
Benchmark:
Tested using large CSV of 1M rows 1 Go.
Note: No optimizations applied! The benchmark includes databse creation from CSV & query execution.
CPU | Memory | Disk | OS | Timing |
---|---|---|---|---|
i7 (13K) | 32 Go | SSD NVMe | Windows 10 Pro x64 | 2.19s |
Xeon (E22) | 16 Go | SSD | Linux Debian 11 | 3.58s |
i3 (3) | 8 Go | SSD | Windows 10 Pro x64 | 30.23s |
Requirements:
- PHP exec function
- PHP SQLite3 extension
Install:
Example:
Fetch single value:
Fetch rows:
Create database:
Todo:
- Add support for XML and other structured format
- Add support for PHP FFI extension (Optional)
- Add structured format converter
- Add header parser
Authors:
- Jakiboy (Initial work)
⭐ Support:
Please give it a Star if you like the project.
All versions of pducky with dependencies
PHP Build Version
Package Version
Requires
php Version
>=7.4
The package jakiboy/pducky contains the following files
Loading the files please wait ....