ankane/tailslide

Median and percentile for Eloquent / Laravel

v0.2.0 2024-07-01 00:44 UTC

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

Build Status

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:

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