Download the PHP package betoalien/pardox-php without Composer
On this page you can find all versions of the php package betoalien/pardox-php. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Informations about the package pardox-php
PardoX for PHP — High-Performance DataFrame Engine
The Speed of Rust. The Simplicity of PHP.
PardoX is a high-performance DataFrame engine for PHP. A single Rust core handles all computation — CSV parsing, arithmetic, database I/O, sorting, GroupBy, Window functions, and more — exposed to PHP through the native FFI extension. No Python. No Node. No middleware.
v0.3.2 is now available. PRDX streaming to PostgreSQL (150M rows validated), GroupBy, String & Date ops, Window functions, Lazy pipeline, SQL over DataFrames, Encryption, Data Contracts, Time Travel, Arrow Flight, Linear Algebra, REST Connector, and 29 total gap features — all from PHP.
⚡ Why PardoX for PHP?
| Capability | How |
|---|---|
| Zero-copy ingestion | Multi-threaded Rust CSV parser — no PHP string processing |
| SIMD arithmetic | AVX2 / NEON — 5x–20x faster than PHP loops |
| Native database I/O | Rust drivers for PostgreSQL, MySQL, SQL Server, MongoDB — no PHP extensions needed |
| PRDX Streaming | Stream 150M-row files to PostgreSQL at ~145k rows/s with O(block) RAM |
| GPU sort | WebGPU Bitonic sort with transparent CPU fallback |
| GroupBy + Window | Aggregations, rolling, rank, lag/lead — pure Rust |
| No dependencies | Only requires PHP's built-in ext-ffi and ext-json |
| Cross-platform | Linux x64 · Windows x64 · macOS Intel · macOS Apple Silicon |
📦 Installation
Requirements:
- PHP 8.1 or higher
ext-ffienabled inphp.iniext-json(standard, usually enabled by default)
Enable the FFI extension:
🚀 Quick Start
🗄️ What's New in v0.3.2
PRDX Streaming to PostgreSQL
Stream a .prdx file directly to PostgreSQL — without loading the file into RAM. O(block) memory regardless of file size.
| Approach | RAM used |
|---|---|
read_prdx() then to_sql() |
Entire file (3.8 GB for 150M rows) |
IO::write_sql_prdx() |
O(one block) — typically < 200 MB |
GroupBy Aggregation
String & Date Operations
Window Functions
Lazy Pipeline
SQL over DataFrames
Encryption
Data Contracts
🗄️ Database I/O
1. Relational Conqueror — PostgreSQL, MySQL, SQL Server, MongoDB
Write modes:
| Database | append |
replace |
upsert |
|---|---|---|---|
| PostgreSQL | INSERT (COPY for >10k rows) | — | ON CONFLICT DO UPDATE |
| MySQL | INSERT 1k/stmt (LOAD DATA for >10k) | REPLACE INTO | ON DUPLICATE KEY UPDATE |
| SQL Server | INSERT 500/stmt | INSERT 500/stmt | MERGE INTO |
| MongoDB | insert_many 10k/batch | drop + insert_many | — |
Note on SQL Server passwords: A known issue in the tiberius v0.12 Rust driver causes authentication failure when
!is present in the password. Use only[A-Za-z0-9_\-@#$]. Fix planned for v0.4.0.
📋 Full API Overview
DataFrame — Factory Methods
DataFrame — Properties
DataFrame — Inspection
DataFrame — Arithmetic & Transform
DataFrame — GroupBy & Aggregation
DataFrame — Window Functions
DataFrame — String Operations
DataFrame — Series Operators
Series — Aggregations
Observer
Write
IO — Static Helpers
📊 Benchmarks
| Operation | PHP PDO / loops | PardoX v0.3.2 | Speedup |
|---|---|---|---|
| Read CSV (1 GB) | ~12s | ~0.8s | ~15x |
| Column multiply (1M rows) | ~0.8s | ~0.02s | ~40x |
| PostgreSQL write 50k rows | ~20s (PDO execute) | ~0.6s (COPY) | ~33x |
| MySQL write 50k rows | ~25s (PDO execute) | ~3s (batch INSERT) | ~8x |
| PRDX → PostgreSQL 150M rows | N/A | ~1,032s | 145k rows/s |
🗺️ Roadmap
| Version | Status | Highlights |
|---|---|---|
| v0.1 | ✅ Released | CSV, arithmetic, aggregations, .prdx format |
| v0.3.1 | ✅ Released | Databases (PG/MySQL/MSSQL/MongoDB), Observer, Math, GPU sort |
| v0.3.2 | ✅ Released | PRDX Streaming, GroupBy, Window, String/Date, Lazy, Encryption, Data Contracts, Time Travel, Arrow Flight, Linear Algebra, REST Connector — 29 features |
| v0.4.0 | 🔜 Planned | SQL Server ! password fix, structured error codes, Apache Parquet, Kafka, S3 |
🌐 Platform Support
| OS | Architecture | Status |
|---|---|---|
| Linux | x86_64 | ✅ Stable |
| Windows | x86_64 | ✅ Stable |
| macOS | ARM64 (M1/M2/M3) | ✅ Stable |
| macOS | x86_64 (Intel) | ✅ Stable |
📘 Documentation
📄 License
MIT License — free for commercial and personal use.
by Alberto Cardenas
www.albertocardenas.com · www.pardox.io
All versions of pardox-php with dependencies
ext-ffi Version *