Rocksolid Light

Welcome to novaBBS (click a section below)

mail  files  register  newsreader  groups  login

Message-ID:  

If you're not part of the solution, you're part of the precipitate.


devel / comp.lang.python / Re: Changing the original SQLite version to the latest

SubjectAuthor
o Re: Changing the original SQLite version to the latestThomas Passin

1
Re: Changing the original SQLite version to the latest

<mailman.1825.1676426102.20444.python-list@python.org>

  copy mid

https://www.novabbs.com/devel/article-flat.php?id=21695&group=comp.lang.python#21695

  copy link   Newsgroups: comp.lang.python
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!newsreader4.netcologne.de!news.netcologne.de!fu-berlin.de!uni-berlin.de!not-for-mail
From: lis...@tompassin.net (Thomas Passin)
Newsgroups: comp.lang.python
Subject: Re: Changing the original SQLite version to the latest
Date: Tue, 14 Feb 2023 17:27:15 -0500
Lines: 49
Message-ID: <mailman.1825.1676426102.20444.python-list@python.org>
References: <CAO+295tdAifRpq6PSSix=feZFAfO-=ERxkn=aL5eB25BDU=ghw@mail.gmail.com>
<a17405db-784f-4cfe-766c-10dd8272130d@tompassin.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Trace: news.uni-berlin.de i4WCKQXB0nUScLPPc+clCgs890/HJPvssmdSwLh0pP5Q==
Return-Path: <list1@tompassin.net>
X-Original-To: python-list@python.org
Delivered-To: python-list@mail.python.org
Authentication-Results: mail.python.org; dkim=pass
reason="2048-bit key; unprotected key"
header.d=tompassin.net header.i=@tompassin.net header.b=jRux/9yq;
dkim-adsp=pass; dkim-atps=neutral
X-Spam-Status: OK 0.005
X-Spam-Evidence: '*H*': 0.99; '*S*': 0.00; 'check-in': 0.09;
'instances': 0.09; 'ok,': 0.09; 'pulled': 0.09;
'received:23.83.212': 0.09; 'received:elm.relay.mailchannels.net':
0.09; 'subject:version': 0.09; 'support,': 0.09; 'steps': 0.11;
'downloaded': 0.13; 'import': 0.15; '2022,': 0.16; '>>>>': 0.16;
'dll': 0.16; 'installed.': 0.16; 'instances,': 0.16; 'pcs,': 0.16;
'python3': 0.16; 'received:10.0.0': 0.16; 'received:64.90': 0.16;
'received:64.90.62': 0.16; 'received:64.90.62.162': 0.16;
'received:dreamhost.com': 0.16; 'reference,': 0.16; 'wrote:':
0.16; 'problem': 0.16; 'python': 0.16; 'instead': 0.17;
'probably': 0.17; 'pm,': 0.19; 'to:addr:python-list': 0.20;
"i've": 0.22; 'version': 0.23; 'install': 0.23; 'installed': 0.23;
'skip:- 10': 0.25; 'help.': 0.25; 'python,': 0.25; 'anyone': 0.25;
'tried': 0.26; 'library': 0.26; 'solution.': 0.26; 'bit': 0.27;
'done': 0.28; 'greatly': 0.28; 'version.': 0.28; 'ideas': 0.28;
'suggestions': 0.28; 'header:User-Agent:1': 0.30; 'before.': 0.31;
'dec': 0.31; 'received:10.0': 0.32; 'received:mailchannels.net':
0.32; 'received:relay.mailchannels.net': 0.32; 'but': 0.32;
'windows': 0.34; 'appreciated.': 0.34; 'work.': 0.34; 'header:In-
Reply-To:1': 0.34; 'trying': 0.35; 'request': 0.35; 'fix': 0.36;
'work,': 0.36; 'thanks,': 0.36; 'change': 0.36; "it's": 0.37;
'thanks': 0.38; 'two': 0.39; 'use': 0.39; 'both': 0.40; 'try':
0.40; 'provide': 0.60; '10,': 0.61; 'above': 0.62; 'box': 0.65;
'tool': 0.65; 'now,': 0.67; 'worked': 0.67; 'header:Received:6':
0.67; 'received:64': 0.67; 'right': 0.68; 'days,': 0.69;
'working,': 0.69; 'site': 0.70; 'them,': 0.70; 'little': 0.73;
'see,': 0.76; 'dealt': 0.84; 'sqlite': 0.84; 'subject:latest':
0.84; 'subject:original': 0.84; 'tar': 0.84; 'thus,': 0.84
X-Sender-Id: dreamhost|x-authsender|tpassin@tompassin.net
ARC-Seal: i=1; s=arc-2022; d=mailchannels.net; t=1676413637; a=rsa-sha256;
cv=none;
b=XBkaWZrKE8R19UVj5cLP+TA31bv/790/w/KyaaqRZjrf0MkC4UvCA+4dI3YBGQzz2gmsGm
Do0QQCYTkkxv/3rBjVXO+u5UC/IAP1kTHkDFoxWoD5ltNzC1QvvM/E8JcgscQs0QhrkzhA
Os3GyaFs68cwEoWdRVowNAcpONVPJ1CbIVt7CDoSHFlyCly2EWGfKM3jmYKDv2kJFPVlLl
Ysa7L30yL61KrOavlLb+anKVZIc+3UoqXajbNySV54sJ1XgrKlEEwnwKvfLGI5sIVnGUkr
WFVdBX5+I9Ziyt3gd7s6n9ib3sctmOXH9QAJlB2KIN78PYlZvq9x8OJaZk8Qhw==
ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed;
d=mailchannels.net; s=arc-2022; t=1676413637;
h=from:from:reply-to:subject:subject:date:date:message-id:message-id:
to:to:cc:mime-version:mime-version:content-type:content-type:
content-transfer-encoding:content-transfer-encoding:
in-reply-to:in-reply-to:references:references:dkim-signature;
bh=4X2f84dLO6rcMdFWeYGoRt+Rm5nnKWS6nRvgDjdj2lQ=;
b=1GFbVEywJERbH/j5ILMD525NFJalKFiHRYsJakSmj9E2U3qxafJJnIrs987FGTFvmSH+Qo
OwNk14T8wq5Y8shB5yU6gwof7Z02Ixkt/+KSIJn7XVpe7JbanGyDmD405Wg7b2udtCZCug
JfybnFUc97aJTs//pRXXwt2rguzNbEdU72LEZgL8ixpNfRW9KOLsUOXzp7/TqC8GF9bS72
iaL/CbFQfpJSkoK3e4l9uf2OFw1zAG35kDV24u72rOifblqicvpnGtvTB21HfoLdwLqP08
EzALKNCcXWKO8XvtJBe2Yi99pcIJ2oIgeJOs5H6+7AVfEzVttU0wPyoizzuAeg==
ARC-Authentication-Results: i=1; rspamd-759d9dd6cd-9dp7j;
auth=pass smtp.auth=dreamhost smtp.mailfrom=list1@tompassin.net
X-Sender-Id: dreamhost|x-authsender|tpassin@tompassin.net
X-MC-Relay: Neutral
X-MailChannels-SenderId: dreamhost|x-authsender|tpassin@tompassin.net
X-MailChannels-Auth-Id: dreamhost
X-Spicy-Left: 481318df5e6d5638_1676413637273_3756639713
X-MC-Loop-Signature: 1676413637273:2423939241
X-MC-Ingress-Time: 1676413637273
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=tompassin.net;
s=dreamhost; t=1676413636;
bh=4X2f84dLO6rcMdFWeYGoRt+Rm5nnKWS6nRvgDjdj2lQ=;
h=Date:Subject:To:From:Content-Type:Content-Transfer-Encoding;
b=jRux/9yquO76jFpcLeWRQrkrvAAZy1WwBGuvimRQD3Ed/3zMgMYiRja6aZtzoPKup
AAshtmaZKhbzpaaGaBDbkvrCB5jK5+AqoqP2r69V5gibuQyeqeJpY16iRWyR6XKV9F
jz2sNf/VwUVxJ7WA1e2Nxv+FnMJHCe0rvSPLGX9SqW46M9rfVGqcqM58K/pMyDc/4b
OyFffXA2SIRS+rid7XL5TKTFooFQMm1BDsXGdeKaiRMcTKt1QLxVkHcBFTkfhcUYjy
r9ToyfC16tAZjB+3Ws3WYxRtnfqIPZrZEeaUd5P2h+2fzVveK9uLJBdCo5GuWKR5lk
wG94TIULTMW+w==
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:102.0) Gecko/20100101
Thunderbird/102.7.2
Content-Language: en-US
In-Reply-To: <CAO+295tdAifRpq6PSSix=feZFAfO-=ERxkn=aL5eB25BDU=ghw@mail.gmail.com>
X-BeenThere: python-list@python.org
X-Mailman-Version: 2.1.39
Precedence: list
List-Id: General discussion list for the Python programming language
<python-list.python.org>
List-Unsubscribe: <https://mail.python.org/mailman/options/python-list>,
<mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive: <https://mail.python.org/pipermail/python-list/>
List-Post: <mailto:python-list@python.org>
List-Help: <mailto:python-list-request@python.org?subject=help>
List-Subscribe: <https://mail.python.org/mailman/listinfo/python-list>,
<mailto:python-list-request@python.org?subject=subscribe>
X-Mailman-Original-Message-ID: <a17405db-784f-4cfe-766c-10dd8272130d@tompassin.net>
X-Mailman-Original-References: <CAO+295tdAifRpq6PSSix=feZFAfO-=ERxkn=aL5eB25BDU=ghw@mail.gmail.com>
 by: Thomas Passin - Tue, 14 Feb 2023 22:27 UTC

On 2/14/2023 3:30 PM, jose isaias cabrera wrote:
> Greetings.
>
> I have tried both Cygwin and SQLite support, and I have received very
> little ideas from them, so I am trying this to see if anyone has dealt
> with such a problem before.
>
> If I use Cygwin setup tool and 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'
>>>>
>
> As you can see, 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 4 Cygwin instances, 2 of them
> are working ok, 2 are 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 makes the other two work, and the other two not work.
> I have started a few instances of Cygwin on the PC that is not
> working, and I have been trying for a few days, 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. Since this is Windows 10, it's probably some
> SQLite DLL somewhere that is being pulled instead of the one
> installed. Perhaps some of you can provide a few suggestions to see
> where I can find a solution. I know the next step is to compile
> python, but, I rather try to find how to fix this and get to the
> bottom of it. Thanks, thanks and thanks.

As a point of reference, the Python installation I've got on my Windows
box (not a cygwin install) is

Python 3.10.9 (tags/v3.10.9:1dd9be6, Dec 6 2022, 20:01:21) [MSC v.1934
64 bit (AMD64)] on win32

and the sqlite_version is 3.39.4

1
server_pubkey.txt

rocksolid light 0.9.8
clearnet tor