Python's standard library module sqlite3 support loading sqlite extensions, also the fulltext search one. The ORM Peewee also includes support. (Both support FTS3/FTS4 and Peewee also explicitly supports FTS5.
How would I best integrate sqlite3's fulltext search, be it FTS3/FTS4 or FTS5, in a Pony ORM application?
I suppose that in principle, I can connect to the database with the sqlite3 module or even Peewee and use their functionality. However, I do not know whether there are any gotcha's regarding concurrent access to the database file. Also perhaps it is possible to integrate the fulltext search better, so that, e.g., fulltext searches can be done using comprehension syntax.