Changing the python sqlite3 version to the latest

Changing the python sqlite3 version to the latest

[Jose Isaias Cabrera]

Greetings.

If I install python39 and thus,
$ python
Python 3.9.10 (main, Jan 20 2022, 21:37:52)
[GCC 11.2.0] on cygwin
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlite3
>>> sqlite3.sqlite_version
'3.34.0'
>>>

The SQlite3 version installed is v3.34.0. Right now, the version available is 3.40.1. What I would like to do is to work with the latest SQLite version. I have 3 Cygwin instances, 2 of them are working ok, another one is not. This is what I have done to get python to use 3.41.0:
- downloaded the latest SQlite check-in from the site
- $ tar -xvf SQLite-44200596.tar.gz
- cd to SQLite-44200596
- $ ./configure --prefix=/usr
- $ make install

These steps above have worked on two PCs, but I don't know what is the difference that make the other two work and not this one. I have started a few instances of Cygwin on the PC that is not working, and I have been trying since last night, and I am humbling myself, and asking for help. So, the request is to get python3 to change the SQLite3 library from 3.34.0 to 3.41.0. Any help would be greatly appreciated. Thanks.

josé

Re: Changing the python sqlite3 version to the latest

[Jose Isaias Cabrera]

[-- Attachment #1: Type: text/plain, Size: 1347 bytes --]

On Saturday, February 11, 2023 04:37 PM, Jose Isaias Cabrera expressed:

> Greetings.
>
> If I install python39 and thus,
> $ python
> Python 3.9.10 (main, Jan 20 2022, 21:37:52)
> [GCC 11.2.0] on cygwin
> Type "help", "copyright", "credits" or "license" for more information.
> >>> import sqlite3
> >>> sqlite3.sqlite_version
> '3.34.0'
> >>>
>
> The SQlite3 version installed is v3.34.0. Right now, the version available is
> 3.40.1. What I would like to do is to work with the latest SQLite version. I
> have 3 Cygwin instances, 2 of them are working ok, another one is not. This is
> what I have done to get python to use 3.41.0:
> - downloaded the latest SQlite check-in from the site
> - $ tar -xvf SQLite-44200596.tar.gz
> - cd to SQLite-44200596
> - $ ./configure --prefix=/usr
> - $ make install
>
> These steps above have worked on two PCs, but I don't know what is the
> difference that make the other two work and not this one. I have started a
> few instances of Cygwin on the PC that is not working, and I have been
> trying since last night, and I am humbling myself, and asking for help. So,
> the request is to get python3 to change the SQLite3 library from 3.34.0 to
> 3.41.0. Any help would be greatly appreciated. Thanks.

Any ideas or suggestions where I can get help for this? Thanks.

josé

Re: Changing the python sqlite3 version to the latest

[Marco Atzeri]

On 11.02.2023 22:37, Jose Isaias Cabrera via Cygwin wrote:
> 
> Greetings.
> 
> If I install python39 and thus,
> $ python
> Python 3.9.10 (main, Jan 20 2022, 21:37:52)
> [GCC 11.2.0] on cygwin
> Type "help", "copyright", "credits" or "license" for more information.
>>>> import sqlite3
>>>> sqlite3.sqlite_version
> '3.34.0'


https://cygwin.com/packages/summary/sqlite3.html
Last version packaged for Cygwin is 3.34.0

Until Jan (or someone else) is packaging a more recent version
that is what is available

Regards
Marco

RE: Changing the python sqlite3 version to the latest

[Jose Isaias Cabrera]

On Tuesday, February 14, 2023 5:58 PM, Marco Atzeri expressed:
> 
> On 11.02.2023 22:37, Jose Isaias Cabrera via Cygwin wrote:
> >
> > Greetings.
> >
> > If I install python39 and thus,
> > $ python
> > Python 3.9.10 (main, Jan 20 2022, 21:37:52) [GCC 11.2.0] on cygwin
> > Type "help", "copyright", "credits" or "license" for more information.
> >>>> import sqlite3
> >>>> sqlite3.sqlite_version
> > '3.34.0'
> Last version packaged for Cygwin is 3.34.0
> 
> Until Jan (or someone else) is packaging a more recent version that is what is available
> 
> Regards
> Marco

Yes, but the question is how can I update the SQLite version? I have been able to do it with 2 PCs, but there is one that is not able. Some of the sqlite folks said that is a DLL issue.

RE: Changing the python sqlite3 version to the latest

[Jose Isaias Cabrera]

On February 14, 2023 8:46 PM, Jose Isaias Cabrera expressed:
> 
> 
> On Tuesday, February 14, 2023 5:58 PM, Marco Atzeri expressed:
> >
> > On 11.02.2023 22:37, Jose Isaias Cabrera via Cygwin wrote:
> > >
> > > Greetings.
> > >
> > > If I install python39 and thus,
> > > $ python
> > > Python 3.9.10 (main, Jan 20 2022, 21:37:52) [GCC 11.2.0] on cygwin
> > > Type "help", "copyright", "credits" or "license" for more information.
> > >>>> import sqlite3
> > >>>> sqlite3.sqlite_version
> > > '3.34.0'
> > Last version packaged for Cygwin is 3.34.0
> >
> > Until Jan (or someone else) is packaging a more recent version that is
> > what is available
> >
> > Regards
> > Marco
> 
> Yes, but the question is how can I update the SQLite version? I have been
> able to do it with 2 PCs, but there is one that is not able. Some of the
> sqlite folks said that is a DLL issue.

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

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()

Re: Changing the python sqlite3 version to the latest

[Andrey Repin]

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

Re: Changing the python sqlite3 version to the latest

[Jose Isaias Cabrera]

On Wednesday, February 15, 2023 10:55 AM, Andrey Repin  expressed:

> > -- 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).

How do I do that? Right now, "it's working ok", from what I can see. Thanks.

Re: Changing the python sqlite3 version to the latest

[Andrey Repin]

Greetings, Jose Isaias Cabrera!

> On Wednesday, February 15, 2023 10:55 AM, Andrey Repin  expressed:

>> > -- 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).

> How do I do that?

    rebase -s /path/to/binary …

The -n switch may be necessary as well.

> Right now, "it's working ok", from what I can see. Thanks.

Merely a coincidence.


-- 
With best regards,
Andrey Repin
Thursday, February 16, 2023 02:44:10

Sorry for my terrible english...

RE: Changing the python sqlite3 version to the latest

[Jose Isaias Cabrera]

On February 16, 2023 1:15 AM, Andrey Repin expressed:

> >> Don't forget to rebase the resulting binary(-es).
> 
> > How do I do that?
> 
> rebase -s /path/to/binary ...
> 
> The -n switch may be necessary as well.

jcabrera@JIC ~
$ rebase -s -n /usr/bin/sqlite3.exe

Nothing different, apparently, has taken place. But, I will take your word for it. :-) Thanks.

Re: Changing the python sqlite3 version to the latest

[Marco Atzeri]

On 16.02.2023 15:25, Jose Isaias Cabrera via Cygwin wrote:
> 
> On February 16, 2023 1:15 AM, Andrey Repin expressed:
> 
>>>> Don't forget to rebase the resulting binary(-es).
>>
>>> How do I do that?
>>
>> rebase -s /path/to/binary ...
>>
>> The -n switch may be necessary as well.
> 
> jcabrera@JIC ~
> $ rebase -s -n /usr/bin/sqlite3.exe

rebase is for DLL so use

   /usr/bin/cygsqlite3-0.dll
or
   /usr/local/bin/cygsqlite3-0.dll

depending where you installed

> Nothing different, apparently, has taken place. But, I will take your word for it. :-) Thanks.

you could see a difference in base address before and after the
   "rebase -s .."

$ rebase -i /usr/bin/cygsqlite3-0.dll
/usr/bin/cygsqlite3-0.dll                 base 0x0003b7370000 size 
0x00147000

Regards
MArco