A FOSDEM 2020 talk I missed out on. Summarises tokenisation, stemming and stop words. Then goes into how to use FTS in version 12. Check out the websearch_to_tsquery function which can produce a tsquery from a web search.


Other database systems I found interesting.


Is a relational database with Git-like version control features that is optimized for acquiring, distributing, and collaboratively building datasets.

Definition of dolt

noun A stupid person; a dunce.

Saw this mentioned in a mailing list, although I can't take the "GitHub for Databases" too seriously when their website is called DoltHub. However, they do have some nice datasets, ie: github-repos.