FTS support in phpPgAdmin. Working notes.

Current status

• FTS tab on schema level
• FTS breadcrumbs support
• Comments on FTS objects support
• List of all FTS configurations/mappings/parsers/dictionaries
• Create/alter/drop configuration (parser, template, with map are supported)
• Create/alter/drop dictionary & dictionary template
• Create/alter/drop mapping
• $PHP_SELF removed from the code accordingly to overall PPA migration to the new style
• FTS icon for a tab
• Migration to the latest PG FTS patch (v. 0.58) finished
• Public PPA installation (http://virtual.sai.msu.ru/~iz/ppa/), UPD 070913: 1 week behind the code
• Initial FTS support in AJAX objects tree

Link to the current patch is at the bottom of this page. Do not forget to do make in the lang/ directory of the CVS HEAD version with patch applied.

TODO

• Create/alter/drop parser (almost finished)
• Alter owner (future)

Not to forget

• FTS icon for breadcrumbs (grep PUT_ICON_HERE in the patch code) -- done for some FTS objects
• Links to FTS documentation (grep PUT_DOC_LINK_HERE in the patch code)
• FTS objects in Find tab and in AJAX object tree on the left -- done partially

Ways for FTS integration into small databases

• Simple FTS without ranking support: SELECT * FROM table WHERE text_field @@ 'text query'

Found problems

• Bug in psql: autocompletion for \dF shows not \dF, \dFd and \dFp options, but \df which is not related to FTS.
• Autocompletion seems to know nothing about FTS syntax:

test=# CREATE 
AGGREGATE   DOMAIN      LANGUAGE    SCHEMA      TEMP        USER
CAST        FUNCTION    OPERATOR    SEQUENCE    TRIGGER     VIEW
CONVERSION  GROUP       ROLE        TABLE       TYPE        
DATABASE    INDEX       RULE        TABLESPACE  UNIQUE      

Comments? Ideas? Other feedback? Please contact iz at sai msu ru