PHPackages                             appel/sqlite-functions - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. appel/sqlite-functions

ActiveLibrary[Database & ORM](/categories/database)

appel/sqlite-functions
======================

A polyfill for various SQL functions that SQLite doesn't natively support.

v0.1.2(5y ago)3301MITPHPPHP >=7.1

Since Jul 10Pushed 5y ago1 watchersCompare

[ Source](https://github.com/avrahamappel/sqlite-functions)[ Packagist](https://packagist.org/packages/appel/sqlite-functions)[ RSS](/packages/appel-sqlite-functions/feed)WikiDiscussions master Synced 4d ago

READMEChangelog (3)Dependencies (2)Versions (5)Used By (0)

SQLite Functions
================

[](#sqlite-functions)

This is a little PHP package that adds common SQL functions to SQLite. Useful when you're using MySQL or Postgres as your main database connection, but you want to use SQLite for testing, and keep getting those annoying "No such function" errors for stuff like `DATE_FORMAT`.

It still needs a lot of work, so all PRs are welcome.

Installation
============

[](#installation)

```
composer require --dev appel/sqlite-functions
```

If you're using Laravel, the service provider and function macros will be registered automatically for you.

###  Health Score

24

—

LowBetter than 31% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity11

Limited adoption so far

Community10

Small or concentrated contributor base

Maturity47

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 95.7% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~255 days

Total

3

Last Release

1974d ago

PHP version history (2 changes)v0.1.0PHP >=7

v0.1.1PHP >=7.1

### Community

Maintainers

![](https://www.gravatar.com/avatar/c5380728b99919e632776bbe389056c34beb2ae339e4f8f2a66285345549b48f?d=identicon)[avrahamappel](/maintainers/avrahamappel)

---

Top Contributors

[![avrahamappel](https://avatars.githubusercontent.com/u/33736292?v=4)](https://github.com/avrahamappel "avrahamappel (22 commits)")[![bomshteyn](https://avatars.githubusercontent.com/u/4259699?v=4)](https://github.com/bomshteyn "bomshteyn (1 commits)")

---

Tags

laravelmysqlphpsql-functionssqlite

### Embed Badge

![Health badge](/badges/appel-sqlite-functions/health.svg)

```
[![Health](https://phpackages.com/badges/appel-sqlite-functions/health.svg)](https://phpackages.com/packages/appel-sqlite-functions)
```

###  Alternatives

[spatie/laravel-medialibrary

Associate files with Eloquent models

6.1k43.2M624](/packages/spatie-laravel-medialibrary)[mongodb/laravel-mongodb

A MongoDB based Eloquent model and Query builder for Laravel

7.1k8.4M94](/packages/mongodb-laravel-mongodb)[psalm/plugin-laravel

Psalm plugin for Laravel

3355.3M346](/packages/psalm-plugin-laravel)[yajra/laravel-oci8

Oracle DB driver for Laravel via OCI8

8793.2M25](/packages/yajra-laravel-oci8)[kirschbaum-development/eloquent-power-joins

The Laravel magic applied to joins.

1.6k32.6M45](/packages/kirschbaum-development-eloquent-power-joins)[glushkovds/phpclickhouse-laravel

Adapter of the most popular library https://github.com/smi2/phpClickHouse to Laravel

2051.5M2](/packages/glushkovds-phpclickhouse-laravel)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)