Forum Archive

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?

Thank you.

import sqlite3 ; print(sqlite3.version)

'2.6.0'

>>>> 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 "3.8.10.2".