[ANN] PGroonga 1.0.9 - Make PostgreSQL fast full text search platform for all languages

From: Kouhei Sutou <kou(at)clear-code(dot)com>
To: pgsql-announce(at)postgresql(dot)org
Subject: [ANN] PGroonga 1.0.9 - Make PostgreSQL fast full text search platform for all languages
Date: 2016-06-02 03:33:58
Message-ID: 20160602.123358.1602659303214340519.kou@clear-code.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-announce

Hi,

PGroonga 1.0.9 has been released!

http://groonga.org/en/blog/2016/06/02/pgroonga-1.0.9.html

### About PGroonga

http://pgroonga.github.io/

PGroonga is a PostgreSQL extension that makes PostgreSQL
fast full text search platform for all languages!
It's released under PostgreSQL license.

There are some PostgreSQL extensions that improves full text
search feature of PostgreSQL such as pg_trgm(*1).

(*1) http://www.postgresql.org/docs/current/static/pgtrgm.html

pg_trgm doesn't support languages that use non-alphanumerics
characters such as Japanese and Chinese.

PGroonga supports all languages, provides rich full text
search related features and is very fast. Because PGroonga
uses Groonga(*2) that is a full-fledged full text search
engine as backend.

(*2) http://groonga.org/

PGroonga also supports JSON search. You can use each value
for condition. You can also perform full text search against
all texts in JSON. No other extension such as JsQuery(*3)
doesn't provide full text search feature against JSON.

(*3) https://github.com/postgrespro/jsquery

### Changes

Here are changes since 1.0.6:

* Supported PostgreSQL 9.6 beta1.

* Supported Ubuntu Xenial Xerus (16.04 LTS).

* Added pgroonga.highlight_html function that returns
search keyword highlighted HTML.
http://pgroonga.github.io/reference/functions/pgroonga-highlight-html.html

* Added pgroonga.match_positions_byte function that
returns locations of keywords in text.
http://pgroonga.github.io/reference/functions/pgroonga-match-positions-byte.html

* Added pgroonga.query_extract_keywords function that
extract keywords from query.
http://pgroonga.github.io/reference/functions/pgroonga-query-extract-keywords.html

* Added &^> operator that performs prefix search against
text[] type value. If any element is matched, the value
is matched.
http://pgroonga.github.io/reference/operators/prefix-search-contain-v2.html

* Added &^~> operator that performs prefix RK search
against text[] type value. If any element is matched,
the value is matched.
http://pgroonga.github.io/reference/operators/prefix-rk-search-contain-v2.html

### Usage

You can use PGroonga without full text search knowledge. You
just create an index and puts a condition into WHERE:

CREATE INDEX index_name ON table USING pgroonga (column);

SELECT * FROM table WHERE column @@ 'PostgreSQL';

You can also use LIKE to use PGroonga. PGroonga provides a
feature that performs LIKE with index. LIKE with PGroonga
index is faster than LIKE without index. It means that you
can improve performance without changing your application
that uses the following SQL:

SELECT * FROM table WHERE column LIKE '%PostgreSQL%';

Are you interested in PGroonga? Please install(*4) and try
tutorial(*5). You can know all PGroonga features.

(*4) http://pgroonga.github.io/install/
(*5) http://pgroonga.github.io/tutorial/

You can install PGroonga easily. Because PGroonga provides
packages for major platforms. There are binaries for
Windows.

Thanks,
--
kou

Browse pgsql-announce by date

  From Date Subject
Next Message Andreas Seltenreich 2016-06-02 13:55:04 SQLsmith 1.0 is released
Previous Message Jan Wieck 2016-06-01 03:04:27 BenchmarkSQL 5.0 available