擅长:python、mysql、java
<p>简单的方法是使用<a href="https://github.com/rogerbinns/apsw/" rel="nofollow noreferrer">^{<cd1>}</a>(另一个pythonsqlite包装器)。它的API与<code>sqlite3</code>只是有点不同,你不能只是pip安装它(除非你对过时的版本没意见),但其余的都很好,你可以拥有SQLite最新的特性。在</p>
<pre><code>wget https://github.com/rogerbinns/apsw/releases/download/3.22.0-r1/apsw-3.22.0-r1.zip
unzip apsw-3.22.0-r1.zip
cd apsw-3.22.0-r1
python setup.py fetch sqlite build enable-all-extensions install
</code></pre>
<p>然后</p>
^{pr2}$
<p>退货:</p>
<pre><code>[('COMPILER=gcc-5.4.0 20160609',),
('ENABLE_API_ARMOR',),
('ENABLE_FTS3',),
('ENABLE_FTS3_PARENTHESIS',),
('ENABLE_FTS4',),
('ENABLE_FTS5',),
('ENABLE_ICU',),
('ENABLE_JSON1',),
('ENABLE_RBU',),
('ENABLE_RTREE',),
('ENABLE_STAT4',),
('THREADSAFE=1',)]
</code></pre>
<p>用Python定制编译是很困难的。更多细节请参见<a href="http://charlesleifer.com/blog/using-the-sqlite-json1-and-fts5-extensions-with-python/" rel="nofollow noreferrer">this article by Charles Leifer</a>。在</p>