PHPackages                             ybr-nx/laravel-mariadb - 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. ybr-nx/laravel-mariadb

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

ybr-nx/laravel-mariadb
======================

Add MariaDB JSON select support to Laravel

1.0.20(6y ago)96468.4k↓28.5%8[4 issues](https://github.com/ybr-nx/laravel-mariadb/issues)2EUPL-1.2PHP

Since Aug 17Pushed 6y ago4 watchersCompare

[ Source](https://github.com/ybr-nx/laravel-mariadb)[ Packagist](https://packagist.org/packages/ybr-nx/laravel-mariadb)[ RSS](/packages/ybr-nx-laravel-mariadb/feed)WikiDiscussions master Synced 2d ago

READMEChangelogDependencies (1)Versions (21)Used By (2)

laravel-mariadb
===============

[](#laravel-mariadb)

Add MariaDB JSON support to Laravel. Requires at least MariaDB 10.2.3 (and 10.2.7 to use ->json() migrations)

#### Install

[](#install)

Using composer:

```
$ composer require ybr-nx/laravel-mariadb

```

#### Configure (only Larvel 5.3 and 5.4)

[](#configure-only-larvel-53-and-54)

Include MariaDBServiceProvider in your config/app.php:

```
'providers' => [
    /*
     * Package Service Providers...
     */
    YbrNX\MariaDB\MariaDBServiceProvider::class,
]
```

set **driver** in database configuration to **mariadb**

```
'defaultconnection' => [
    'driver' => 'mariadb',
```

#### Added functionality

[](#added-functionality)

##### Migration

[](#migration)

Adds needed validation to json fields during migrations

```
$table->json('field') //CHECK (JSON_VALID(field))
$table->json('field')->nullable() //CHECK (field IS NULL OR JSON_VALID(field))
```

##### Query builder

[](#query-builder)

Builds json select statements to work with MariaDB

```
$query->where('somejson->something->somethingelse', 2)
DB::table('sometable')->select('sometable.somedata', 'sometable.somejson->somedata as somejsondata')
```

And also JSON\_SET() works in MariaDB as in MySQL 5.7

```
DB::table('sometable')->where('somejson->somedata', $id)->update(['somejson->otherdata' => 'newvalue']);
```

**NB** There is bug in **MariaDB < 10.2.8** JSON\_EXTRACT() behaviour function. It's fixed in MariaDB 10.2.8:

```
//works with string in MySQL & MariaDB 10.2.8
$query->where('somejson->something->somethingelse', 'somedata')

//works with string in MariaDB < 10.2.8
$query->where('somejson->something->somethingelse', '"somedata"')
```

###  Health Score

44

—

FairBetter than 90% of packages

Maintenance19

Infrequent updates — may be unmaintained

Popularity50

Moderate usage in the ecosystem

Community18

Small or concentrated contributor base

Maturity72

Established project with proven stability

 Bus Factor1

Top contributor holds 95.1% 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 ~39 days

Recently: every ~100 days

Total

20

Last Release

2488d ago

### Community

Maintainers

![](https://avatars.githubusercontent.com/u/832778?v=4)[Ingmar](/maintainers/ybr-nx)[@ybr-nx](https://github.com/ybr-nx)

---

Top Contributors

[![ybr-nx](https://avatars.githubusercontent.com/u/832778?v=4)](https://github.com/ybr-nx "ybr-nx (39 commits)")[![timrspratt](https://avatars.githubusercontent.com/u/20431294?v=4)](https://github.com/timrspratt "timrspratt (2 commits)")

---

Tags

jsonlaraveldatabasemariadb

### Embed Badge

![Health badge](/badges/ybr-nx-laravel-mariadb/health.svg)

```
[![Health](https://phpackages.com/badges/ybr-nx-laravel-mariadb/health.svg)](https://phpackages.com/packages/ybr-nx-laravel-mariadb)
```

###  Alternatives

[mongodb/laravel-mongodb

A MongoDB based Eloquent model and Query builder for Laravel

7.1k8.4M96](/packages/mongodb-laravel-mongodb)[yajra/laravel-oci8

Oracle DB driver for Laravel via OCI8

8793.2M25](/packages/yajra-laravel-oci8)[glushkovds/phpclickhouse-laravel

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

2051.5M2](/packages/glushkovds-phpclickhouse-laravel)[aimeos/laravel-nestedset

Nested Set Model for Laravel

3714.4k6](/packages/aimeos-laravel-nestedset)[itpathsolutions/dbstan

Database Standardization and Analysis Tool for Laravel

492.8k](/packages/itpathsolutions-dbstan)[ramadan/easy-model

A Laravel package for enjoyably managing database queries.

111.6k](/packages/ramadan-easy-model)

PHPackages © 2026

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