laravel-postgresql-fulltext

Add fulltext and inherited table support to postgresql

Installation

PHP 5.6.4+ and Laravel 5.4+ are required.

Next step, you must install amutu/zhparser, and make sure it should work.

Finally, run the following command to install this package via composer

composer require "luozhenyu/laravel-postgresql-fulltext"

After install finished, run the following command to generate config file.

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.

LuoZhenyu\PostgresFullText\PostgresqlSchemaServiceProvider::class

Usage

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

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().

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.

use LuoZhenyu\PostgresFullText\FulltextBuilder;

...

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

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