I’m a big fan of Marten, the document database on top of PostgreSQL.
With the Marten 3.4 release last week, we finally got full text search support (together with some other bug fixes and some performance improvements).
PostgreSQL has built in full text search, with this release this functionality finally becomes available in Marten. Using it is as easy as writing the following LINQ statement:
More information here: http://jasperfx.github.io/marten/documentation/documents/querying/linq/#sec24
Remark: To use this feature, you will need to use PostgreSQL version 10.0 or above, as this is the first version that support text search function on jsonb column - this is also the data type that Marten use to store it's data.