PostgreSQL full text search example
Switch branches/tags
Nothing to show
Clone or download
Pull request Compare This branch is even with za-arthur:master.
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
modules
scripts
static
templates
.gitignore
LICENSE
README.md
apod.py
reguirements.txt

README.md

Postgres Professional

apod_fts

PostgreSQL full text search example. Site tsdemo.postgrespro.ru.

Modules

  • ts_json provides functions to full text search with json and jsonb.
  • ts_parser is the modified default text search parser from PostgreSQL 9.6.

Installing

apod_fts is a web-application written in Python using flask web-framework. To run this application you need to install Flask and psycopg2 Python packages.

It is necessary that PostgreSQL binaries are in PATH environment. To install all text search dictionaries and RUM index you can use scripts in script directory. Use the following commands

=> cd apod_fts
=> createdb apod
=> psql apod < scripts/apod.dump
=> chmod +x scripts/01-create-configuration.sh
=> scripts/01-create-configuration.sh
=> chmod +x scripts/02-create-rum.sh
=> scripts/02-create-rum.sh
=> chmod +x scripts/03-fuzzy-hints.sh
=> scripts/03-fuzzy-hints.sh