Updated version of SQLite in pythonista?
The latest version of SQLite is 3.8 something. It supports recursive CTEs.
The SQLite in pythonista is 3.7. Is it possible to update it?
import sqlite3 ; print(sqlite3.version)
>>>> import sqllite3 >>>> sqllite3.sqllite_version '3.8.5'
I'm just linking against the system's version of sqlite, so your output depends on the version of iOS you have installed. On the iOS 9 beta, I get "126.96.36.199".