Generating test data for full text search tests

ID: updates/generating-test-data-for-full-text-search-tests

Updates / Generating test data for full text search tests by Ciro Santilli 36 Updated +Created
I've been thinking lightly about adding full text search to OurBigBook.
For example, at docs.ourbigbook.com/news/article-and-topic-id-prefix-search article search was added, but it only finds if you search something that appears right at the start of a title, e.g. for:
Fundamental theorem of calculus
you'd get a hit for:
fundamental
but not for
calculus
To do this efficiently, we need full text search, which PostgreSQL implements.
But finding a clean way to generate test data for testing out the speedup was not so easy and exploration into this led me to publishing a few new slightly improved methods where Googlers can now find them:

New to topics? Read the docs here!