luozhenyu/laravel-postgresql-fulltext

Add fulltext and inherited table support to postgresql

laravel-postgresql-fulltext

, _(*1)

Add fulltext and inherited table support to postgresql, _(*2)

Installation

PHP 5.6.4+ and Laravel 5.4+ are required., _(*3)

Next step, you must install amutu/zhparser, and make sure it should work., _(*4)

Finally, run the following command to install this package via composer, _(*5)

composer require "luozhenyu/laravel-postgresql-fulltext"

After install finished, run the following command to generate config file., _(*6)

php artisan vendor:publish --provider="LuoZhenyu\PostgresFullText\PostgresqlSchemaServiceProvider"

If you are using laravel 5.4, then you need to register the service provider. Open config/app.php and add the following to the providers array., _(*7)

LuoZhenyu\PostgresFullText\PostgresqlSchemaServiceProvider::class

Usage

When using a postgresql database, you can use the method inherits():, _(*8)

Schema::create('users', function(Blueprint $table) {
  $table->increments('id');
  $table->string('name');
  $table->integer('age');
});

Schema::create('admins', function(Blueprint $table) {
    $table->string('permission');

    $table->inherits('users');//table admins inherit table users
});

Also you can use the method fulltext() and dropFulltext()., _(*9)

Schema::create('articles', function(Blueprint $table) {
  $table->increments('id');
  $table->string('title');
  $table->text('content');

  $table->fulltext(['title', 'content']);

  $table->dropFulltext('articles_title_content_fulltext');
});

And a simple query method is also given in Eloquent ORM using fulltext index., _(*10)

use LuoZhenyu\PostgresFullText\FulltextBuilder;

...

$fulltext = new FulltextBuilder(['title', 'content']);

$articles = Article::where($fulltext->search('any keyword'))->get();