* Changing the python sqlite3 version to the latest
@ 2023-02-11 21:37 Jose Isaias Cabrera
2023-02-13 20:24 ` Jose Isaias Cabrera
2023-02-14 22:58 ` Marco Atzeri
0 siblings, 2 replies; 10+ messages in thread
From: Jose Isaias Cabrera @ 2023-02-11 21:37 UTC (permalink / raw)
To: Jim Garrison via Cygwin
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é
^ permalink raw reply [flat|nested] 10+ messages in thread
* Re: Changing the python sqlite3 version to the latest
2023-02-11 21:37 Changing the python sqlite3 version to the latest Jose Isaias Cabrera
@ 2023-02-13 20:24 ` Jose Isaias Cabrera
2023-02-14 22:58 ` Marco Atzeri
1 sibling, 0 replies; 10+ messages in thread
From: Jose Isaias Cabrera @ 2023-02-13 20:24 UTC (permalink / raw)
To: Jim Garrison via Cygwin
[-- 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é
^ permalink raw reply [flat|nested] 10+ messages in thread
* Re: Changing the python sqlite3 version to the latest
2023-02-11 21:37 Changing the python sqlite3 version to the latest Jose Isaias Cabrera
2023-02-13 20:24 ` Jose Isaias Cabrera
@ 2023-02-14 22:58 ` Marco Atzeri
2023-02-15 1:45 ` Jose Isaias Cabrera
1 sibling, 1 reply; 10+ messages in thread
From: Marco Atzeri @ 2023-02-14 22:58 UTC (permalink / raw)
To: cygwin
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
^ permalink raw reply [flat|nested] 10+ messages in thread
* RE: Changing the python sqlite3 version to the latest
2023-02-14 22:58 ` Marco Atzeri
@ 2023-02-15 1:45 ` Jose Isaias Cabrera
2023-02-15 12:43 ` Jose Isaias Cabrera
0 siblings, 1 reply; 10+ messages in thread
From: Jose Isaias Cabrera @ 2023-02-15 1:45 UTC (permalink / raw)
To: Marco Atzeri, cygwin
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.
^ permalink raw reply [flat|nested] 10+ messages in thread
* RE: Changing the python sqlite3 version to the latest
2023-02-15 1:45 ` Jose Isaias Cabrera
@ 2023-02-15 12:43 ` Jose Isaias Cabrera
2023-02-15 15:55 ` Andrey Repin
0 siblings, 1 reply; 10+ messages in thread
From: Jose Isaias Cabrera @ 2023-02-15 12:43 UTC (permalink / raw)
To: cygwin
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()
^ permalink raw reply [flat|nested] 10+ messages in thread
* Re: Changing the python sqlite3 version to the latest
2023-02-15 12:43 ` Jose Isaias Cabrera
@ 2023-02-15 15:55 ` Andrey Repin
2023-02-15 18:29 ` Jose Isaias Cabrera
0 siblings, 1 reply; 10+ messages in thread
From: Andrey Repin @ 2023-02-15 15:55 UTC (permalink / raw)
To: Jose Isaias Cabrera, cygwin
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...
^ permalink raw reply [flat|nested] 10+ messages in thread
* Re: Changing the python sqlite3 version to the latest
2023-02-15 15:55 ` Andrey Repin
@ 2023-02-15 18:29 ` Jose Isaias Cabrera
2023-02-16 6:14 ` Andrey Repin
0 siblings, 1 reply; 10+ messages in thread
From: Jose Isaias Cabrera @ 2023-02-15 18:29 UTC (permalink / raw)
To: cygwin
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.
^ permalink raw reply [flat|nested] 10+ messages in thread
* Re: Changing the python sqlite3 version to the latest
2023-02-15 18:29 ` Jose Isaias Cabrera
@ 2023-02-16 6:14 ` Andrey Repin
2023-02-16 14:25 ` Jose Isaias Cabrera
0 siblings, 1 reply; 10+ messages in thread
From: Andrey Repin @ 2023-02-16 6:14 UTC (permalink / raw)
To: Jose Isaias Cabrera, cygwin
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...
^ permalink raw reply [flat|nested] 10+ messages in thread
* RE: Changing the python sqlite3 version to the latest
2023-02-16 6:14 ` Andrey Repin
@ 2023-02-16 14:25 ` Jose Isaias Cabrera
2023-02-16 18:40 ` Marco Atzeri
0 siblings, 1 reply; 10+ messages in thread
From: Jose Isaias Cabrera @ 2023-02-16 14:25 UTC (permalink / raw)
To: cygwin
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.
^ permalink raw reply [flat|nested] 10+ messages in thread
* Re: Changing the python sqlite3 version to the latest
2023-02-16 14:25 ` Jose Isaias Cabrera
@ 2023-02-16 18:40 ` Marco Atzeri
0 siblings, 0 replies; 10+ messages in thread
From: Marco Atzeri @ 2023-02-16 18:40 UTC (permalink / raw)
To: cygwin
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
^ permalink raw reply [flat|nested] 10+ messages in thread
end of thread, other threads:[~2023-02-16 18:40 UTC | newest]
Thread overview: 10+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2023-02-11 21:37 Changing the python sqlite3 version to the latest Jose Isaias Cabrera
2023-02-13 20:24 ` Jose Isaias Cabrera
2023-02-14 22:58 ` Marco Atzeri
2023-02-15 1:45 ` Jose Isaias Cabrera
2023-02-15 12:43 ` Jose Isaias Cabrera
2023-02-15 15:55 ` Andrey Repin
2023-02-15 18:29 ` Jose Isaias Cabrera
2023-02-16 6:14 ` Andrey Repin
2023-02-16 14:25 ` Jose Isaias Cabrera
2023-02-16 18:40 ` Marco Atzeri
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).