2017 © Pedro Peláez
 

library laravel-mariadb

Add MariaDB JSON select support to Laravel

image

ybr-nx/laravel-mariadb

Add MariaDB JSON select support to Laravel

  • Tuesday, February 27, 2018
  • by ybr-nx
  • Repository
  • 6 Watchers
  • 19 Stars
  • 14,391 Installations
  • PHP
  • 0 Dependents
  • 0 Suggesters
  • 3 Forks
  • 4 Open issues
  • 15 Versions
  • 33 % Grown

The README.md

laravel-mariadb

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

Install

Using composer:, (*2)

$ composer require ybr-nx/laravel-mariadb

Configure (only Larvel 5.3 and 5.4)

Include MariaDBServiceProvider in your config/app.php:, (*3)

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

set driver in database configuration to mariadb, (*4)

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

Added functionality

Migration

Adds needed validation to json fields during migrations, (*5)

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

Builds json select statements to work with MariaDB, (*6)

$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, (*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: https://jira.mariadb.org/browse/MDEV-12604, (*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"')

The Versions

27/02 2018

dev-master

9999999-dev

Add MariaDB JSON select support to Laravel

  Sources   Download

EUPL EUPL-1.2

The Requires

 

by Ingmar Aasoja

database laravel json mariadb

27/02 2018

1.0.14

1.0.14.0

Add MariaDB JSON select support to Laravel

  Sources   Download

EUPL-1.2

The Requires

 

by Ingmar Aasoja

database laravel json mariadb

27/02 2018

1.0.13

1.0.13.0

Add MariaDB JSON select support to Laravel

  Sources   Download

EUPL

The Requires

 

by Ingmar Aasoja

database laravel json mariadb

23/09 2017

1.0.12

1.0.12.0

Add MariaDB JSON select support to Laravel

  Sources   Download

EUPL

The Requires

 

by Ingmar Aasoja

database laravel json mariadb

18/08 2017

1.0.10

1.0.10.0

Add MariaDB JSON select support to Laravel

  Sources   Download

EUPL

The Requires

 

by Ingmar Aasoja

database laravel json mariadb

18/08 2017

1.0.9

1.0.9.0

Add MariaDB JSON select support to Laravel

  Sources   Download

EUPL

The Requires

 

by Ingmar Aasoja

database laravel json mariadb

18/08 2017

1.0.8

1.0.8.0

Add MariaDB JSON select support to Laravel

  Sources   Download

EUPL

The Requires

 

by Ingmar Aasoja

database laravel json mariadb

18/08 2017

1.0.7

1.0.7.0

Add MariaDB JSON select support to Laravel

  Sources   Download

EUPL

The Requires

 

by Ingmar Aasoja

database laravel json mariadb

17/08 2017

1.0.6

1.0.6.0

Add MariaDB JSON select support to Laravel

  Sources   Download

EUPL

The Requires

 

by Ingmar Aasoja

database laravel json mariadb

17/08 2017

1.0.5

1.0.5.0

Add MariaDB JSON select support to Laravel

  Sources   Download

EUPL

by Ingmar Aasoja

database laravel json mariadb

17/08 2017

1.0.4

1.0.4.0

Add MariaDB JSON select support to Laravel

  Sources   Download

EUPL

The Requires

 

by Ingmar Aasoja

database laravel json mariadb

17/08 2017

1.0.3

1.0.3.0

Add MariaDB JSON select support to Laravel

  Sources   Download

EUPL

by Ingmar Aasoja

database laravel json mariadb

17/08 2017

1.0.2

1.0.2.0

Add MariaDB JSON select support to Laravel

  Sources   Download

EUPL

The Requires

 

by Ingmar Aasoja

database laravel json mariadb

17/08 2017

1.0.1

1.0.1.0

Add MariaDB JSON select support to Laravel

  Sources   Download

EUPL

The Requires

 

by Ingmar Aasoja

database laravel json mariadb

17/08 2017

1.0.0

1.0.0.0

Add MariaDB JSON select support to Laravel

  Sources   Download

EUPL

The Requires

 

by Ingmar Aasoja