擅长:python、mysql、java
<p><strong>/这是之前编辑的专栏文章,但我把它移到了这里以保持问题的清晰</strong></p>
<p>所以这感觉好像可以用,在问题<a href="https://stackoverflow.com/questions/30060010/using-sqlites-fts3-4-with-python-3/30063441">here</a>中找到了</p>
<pre><code>import sqlite3
con = sqlite3.connect(':memory:')
cur = con.cursor()
cur.execute('pragma compile_options;')
available_pragmas = cur.fetchall()
con.close()
print(available_pragmas)
if ('ENABLE_FTS5',) in available_pragmas:
print('YES')
else:
print('NO')
</code></pre>
<p>但奇怪的是,我在几个虚拟机上运行它,没有一个虚拟机启用了fts4,但我却乐此不疲地使用它。。。也许它的fts3/fts4相当相同,或者可能就是完全错了。在</p>
<p><strong>/编辑</strong><br/>
从文档中</p>
<blockquote>
<p>Note that enabling FTS3 also makes FTS4 available. There is not a separate SQLITE_ENABLE_FTS4 compile-time option. A build of SQLite either supports both FTS3 and FTS4 or it supports neither. </p>
</blockquote>