OurBigBook logoOurBigBook Docs OurBigBook logoOurBigBook.comSite Source code

News / Web searches find words inside title on PostgreSQL

When searching articles and topics on OurBigBook Web PostgreSQL, which is the case for OurBigBook.com:
  • each searched word can match exactly within any word of article IDs
  • the last word is considered as a prefix, and matches the start of any word of the ID
Previously, searches would only work if they were exactly a prefix of the title ID.
For example, if you search:
calculus fun
then it will match titles such as:
Fundamental theorem of calculus
since it contains both:
  • the full word calculus
  • fundamental which contains the prefix fun
This feature implemented efficiently by using PostgreSQL's built-in full text search module.
Figure 1.
OurBigBook Web search highlighting full text search
. Source.
Announcements:

Ancestors (4)

  1. News
  2. Publicity
  3. Developing OurBigBook
  4. Home

Incoming links (1)