Re: Changing the python sqlite3 version to the latest

[Andrey Repin <anrdaemon@yandex.ru>]

Greetings, Jose Isaias Cabrera!

> In case anyone needs the answer, These steps worked for me:

> -- Downloaded the Pre-release Snapshots
> $ wget https://sqlite.org/snapshot/sqlite-snapshot-202302131932.tar.gz

> -- untared the snapshot
> $ tar xvf sqlite-snapshot-202302131932.tar.gz

> -- cd to the untared directory
> $ cd sqlite-snapshot-202302131932

> $ ./configure --prefix=/usr

> $ make install

Don't forget to rebase the resulting binary(-es).

> And this process has set the python SQLite version to the sqlite-snapshot
> version. After that, you can download the trunk and follow the same
> procedure, and the version of the trunk will be changed also.

> $ ./SQLiteVersion.py
> 3.41.0
> ['/usr/lib/python3.9/sqlite3']
> 3.41.0
> 2023-02-13 19:32:40
> ecdeef43b27412b0b0b09e09a62ad3a03836a3fc80f2070268090e7ca8f02712

> I hope this helps.
> [JIC] 
> This script may be useful...

> $ cat SQLiteVersion.py
> #!/usr/bin/python3

> import sqlite3

> def ConnectToSharedDB(sdb):
>     return sqlite3.connect(sdb)

> print(sqlite3.sqlite_version)
> print(sqlite3.__path__)
> SharedDB = ":memory:"
> con = ConnectToSharedDB(SharedDB)
> cur = con.cursor()
> cur.execute("SELECT sqlite_version(),sqlite_source_id();")
> for row in cur:
>     print(row[0] + '\r\n' + row[1])

> con.close()



-- 
With best regards,
Andrey Repin
Wednesday, February 15, 2023 18:54:24

Sorry for my terrible english...