ankane / tailslide
Median and percentile for Eloquent / Laravel
v0.2.0
2024-07-01 00:44 UTC
Requires
- php: >= 8.1
- illuminate/database: >= 10
Requires (Dev)
- illuminate/database: >= 10
- illuminate/events: >= 10
- phpunit/phpunit: ^9
This package is not auto-updated.
Last update: 2024-11-04 02:23:36 UTC
README
Median and percentile for Eloquent / Laravel
Supports:
- PostgreSQL
- MariaDB
- MySQL (with an extension)
- SQL Server
🔥 Uses native functions when possible for blazing performance
Installation
Run:
composer require ankane/tailslide
For MySQL, also follow these instructions.
Getting Started
Median
Item::median('price');
Percentile
Request::percentile('response_time', 0.95);
Additional Instructions
MySQL
MySQL requires the PERCENTILE_CONT
function from udf_infusion. To install it, do:
git clone https://github.com/infusion/udf_infusion.git cd udf_infusion ./configure --enable-functions="percentile_cont" make sudo make install mysql <options> < load.sql
History
View the changelog
Contributing
Everyone is encouraged to help improve this project. Here are a few ways you can help:
- Report bugs
- Fix bugs and submit pull requests
- Write, clarify, or fix documentation
- Suggest or add new features
To get started with development:
git clone https://github.com/ankane/tailslide-php.git
cd tailslide-php
composer install
To run the tests:
# Postgres createdb tailslide_php_test ADAPTER=pgsql composer test # MariaDB mysqladmin create tailslide_php_test ADAPTER=mariadb composer test # MySQL (install the extension first) mysqladmin create tailslide_php_test ADAPTER=mysql composer test # SQL Server docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=YourStrong!Passw0rd' -p 1433:1433 -d mcr.microsoft.com/mssql/server:2019-latest docker exec -it <container-id> /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P YourStrong\!Passw0rd -Q "CREATE DATABASE tailslide_php_test" ADAPTER=sqlsrv composer test