X-Recipient:	archive-cygwin AT delorie DOT com
DKIM-Filter:	OpenDKIM Filter v2.11.0 sourceware.org 997B1385B516
DKIM-Signature:	v=1; a=rsa-sha256; c=relaxed/relaxed; d=cygwin.com;
	s=default; t=1676465068;
	bh=wYwb32OpXx5xGQW6WYPGkHswgBdNMcSekOlUSP4IfvU=;
	h=To:Subject:Date:References:In-Reply-To:List-Id:List-Unsubscribe:
	List-Archive:List-Post:List-Help:List-Subscribe:From:Reply-To:
	From;
	b=BT5oK+56aPDT+Ta+i0QsUmDDCvuKkuz4Co/WlCj5GNKXv8qci/9o2Wt0kkC+GcPF+
	WwlAYbo8q40I6VzYAfplcgotYoln0yZOqad62fxzmeab2YswDIhdI/GChCVFbQWdXf
	kTrgyY0yoM219YCQzLxSkVk2WkzN5ArfWQUKOT24=
X-Original-To:	cygwin AT cygwin DOT com
Delivered-To:	cygwin AT cygwin DOT com
DMARC-Filter:	OpenDMARC Filter v1.4.2 sourceware.org 931683858D33
ARC-Seal:	i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none;
	b=in0nAJDLxEDfjQtQkFKmOwi74+O/bUrPZcgri3FwUFHKy8x5becGBii/5g3p+o/xjh3QZBi7KgpLpbn1syqYTTs7fUuSE2x56aJLRbkCA8t/Ai3QtlKxP2uZCw3p3c/Tq51VGRBaxdxjb9dyDip76XBvaWL6x+ZSM9M/mwoIuH3b5RtNLabMu1DeA2/b1++G13a70QA/EOGQ2bP7ON6CHN0Kmi2j5od92LPxq+tGHUsKQ9OAixBHzxGpMZ5phKOYIDzh4Da9/6a6pp/mgX226kTs8qBBavu237UPqtJaVWnDF7+WJ8XASig9OYGVWLnb/wZ1moOBGccD6Vs38+jGbg==
ARC-Message-Signature:	i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com;
	s=arcselector9901;
	h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1;
	bh=WO9xIwPnUL/eXTwqTOXwWU7bpSQ4fyRi934O80arCSU=;
	b=ZzWzN3nEawi8K6XrOo4rByz5O9lFl8IKL8qBUTLPmik+3JctP8pWuDb7Us12H2vbJOrF2BpoViTPifTvJLfQRihdHANSvU1WXZe9MsNrZ8UcoSE6L5ubxL7bsUfpjeb7Cf/sAJi5TGZ11iVULQPvS3ggd7Ruc69u2IBK45XJTvhLiANdP+WVayMS7L69R3ejJLQ5GxwcwduyjZtdj1Thnma0/2XQMCMdef2SemscDcmhSMmkG1WDQPOBowGN7tiTw6pLST0ZNCNTbk6qLFBnPh3fn+yFwclc21XJtUOJtNPticeQiX1pc1eW/qQNStow3hWc7sYvlxyy3vKgn/horw==
ARC-Authentication-Results:	i=1; mx.microsoft.com 1; spf=none; dmarc=none;
	dkim=none; arc=none
To:	"cygwin AT cygwin DOT com" <cygwin AT cygwin DOT com>
Subject:	RE: Changing the python sqlite3 version to the latest
Thread-Topic:	Changing the python sqlite3 version to the latest
Thread-Index:	Adk+YPsn5Soi7NL3SV+5X5NCtP5kKwCZtk6AAAW7EiAAFvppYA==
Date:	Wed, 15 Feb 2023 12:43:41 +0000
Message-ID:	<DB9P251MB0063A4387A9146D1277A7C72DEA39@DB9P251MB0063.EURP251.PROD.OUTLOOK.COM>
References:	<DB9P251MB006335721B0284B32132E802DEDF9 AT DB9P251MB0063 DOT EURP251 DOT PROD DOT OUTLOOK DOT COM>
	<82184ff9-cc61-2a5f-947b-ecf9916e2411 AT gmail DOT com>
	<DB9P251MB0063FCE9A3850830F5A1F632DEA39 AT DB9P251MB0063 DOT EURP251 DOT PROD DOT OUTLOOK DOT COM>
In-Reply-To:	<DB9P251MB0063FCE9A3850830F5A1F632DEA39@DB9P251MB0063.EURP251.PROD.OUTLOOK.COM>
Accept-Language:	en-US
X-MS-Has-Attach:
X-MS-TNEF-Correlator:
x-tmn:	[WgLUsW/PVXwMR5Lfo9Y3g6+FWKH3Jrjv]
x-ms-publictraffictype:	Email
x-ms-traffictypediagnostic:	DB9P251MB0063:EE_|AS1P251MB0680:EE_
x-ms-office365-filtering-correlation-id:	b825cd04-0135-46b9-f063-08db0f52447c
x-microsoft-antispam:	BCL:0;
x-microsoft-antispam-message-info:	r+PMLeZ2zp+9nbTnSl6JTJ0ZFqBJ60umAp1E5O2EkR+Q3UqtEVprFsvC0UqcjQURYIDkUFRuS9IoZ349OsUzMbWGWnfFGTLj0gElSa78fR3lTpsjJD1e9pPUT9we9PLV5Pbse7JunA1kiwJpJbEqYhP1s7umXYm0HFezbi3g0onKvi+zH6dUty9hbbaCjDdF7+WsL6vxSQME4008DRWc6pq4PJfEsivpknETsGXhSW4NBdkRUIyQgS+rOD7OeNa69WkseYJxFQq1DXVcDuaKfkgjuEeAMjXBsP7uCol+NLBNlW620E7HXlgIlRtNen1Pzb23uAmBc1NNsPnEIN4HYQ7TxhFEodkJOfMLW2Dwv2NLjsNbAvKkoG44Hj94Ddb+wFpKW/w4td/28OUpBDXuLKd+1hk7sxNTnwFowKjLubfbh9q1PXbZKl+XSh21LMbXf13A98BtmY6+4kb+6B/DtZEw2PGOUuo9aAJtMkHzoWU84R/GNaMKuF8pUAfXOI2R9IdJsX07U1BP/Y84+Xy1reLUrtAEJlaqzft1qW1tMTpjVhHfz5qnvc1UQ3op97B7yl6EKH8LUf3vUt6ZArvaOZZjumE9ukHG/YSKQq16k4aZglVcNmp1LEvqBmwR7/Pfm5CCakBLY/GZWkMsueNCNQ==
x-ms-exchange-antispam-messagedata-chunkcount:	1
x-ms-exchange-antispam-messagedata-0:	=?us-ascii?Q?1rwvYl9z2F9XDdrqfRFKXzhWsEVMWW/QnaFL3K3GeGCr5lD4DWiocdGPpuzz?=
	=?us-ascii?Q?rJH3/LfsTWcmaaCu/wc7COT4qiEwIJ7/Pug2Ir/VTI5o4JIDFW5zhgv/B4vX?=
	=?us-ascii?Q?XKJOyb9Q+pkoOxj4LZqBcm7cZfEmYYU3BlLxWgvTyPnEa2IUfAt1cO5q4Q2z?=
	=?us-ascii?Q?P303wut2gs8j4y/7qINObQtPZKLg0pbfYCqA16ZAwB6f619UUzyRWyPdZL1t?=
	=?us-ascii?Q?y+3yKDf9wW1vWhttfpUtjzNwegBySc+jdDTI7MMiOiLuvP8Im9IHBYfhSNiz?=
	=?us-ascii?Q?RmyLVyfIdLvdjTRTDyGuovC2MPxWofcKYVYbgKELY8jXZiKJkSIHNhSNJRz0?=
	=?us-ascii?Q?Elfg6Ju0dJiZ2e94I8Zmebf2o548tK4eNUmQufLrn9rLM9cjnRanpiQCyU8d?=
	=?us-ascii?Q?rp/BL/C8zcZmlGCoILNqmzODeA9cr+eh77ZxeizkqPDBQO2hYmFoNvptQxlp?=
	=?us-ascii?Q?h0gqkzZPX5H6MyIkY6FrV0CVCVF1DbxLhKikCRGuZ0q12LKqwkBAN8/mTWB9?=
	=?us-ascii?Q?b/etVvMYtAKHOG2qgTRFClpub5YBUUNA6kHlXjiv+BDPo7M3zehTh6/CIRbi?=
	=?us-ascii?Q?s4SxyNd+dfAEfOQeBAmBmAw/IF4HQp9/jT0DwePB9Mgcu44sMgVN9MVBqadV?=
	=?us-ascii?Q?iGOC4GxAy0EB5p6pjIr+lCqBaBNY6UxMgGWko9GBfuMpcD1vfhaWlgsnBne/?=
	=?us-ascii?Q?XuJhJJpU+IUkb/wPctupXwnAFP6PyehVEiHKDEBkFOLE7ghKI18d59iwYfg7?=
	=?us-ascii?Q?lz6M2pD2PsxCF+gOH9ZhZqSEW3+nwM6PCS1INjIYQJhyASmxrB4yv5rWfWVX?=
	=?us-ascii?Q?YQEgDe5fNsXO3Le0wdewROCBVHM2qZTapv4HP0Q+dceJRksBAO8r4V6ebN3n?=
	=?us-ascii?Q?dd1BdiuLx3H3zU2x76zeRqyiHAwFzTF0yvk/YkqeM18CXyqlGO161lHIEOn5?=
	=?us-ascii?Q?XoupHv3Yww2PFOAvNZ5YBpF4LaC7yAHSn1AZTub4Ol/0jx2vKmy2yIWj1+yr?=
	=?us-ascii?Q?2RJw0atrVZJTrrTDI5ou/yyL5oafMt0U1phxdOfUXyw2ts/Ofl5glDtXX2KI?=
	=?us-ascii?Q?+fA7DBYF72U85xMtCjNg4QzU9VyFJUlLFzc3ZBdqsEq7QO/+HEzVc40WYVtE?=
	=?us-ascii?Q?Hiu/3iwtvJ1O0FnoUV7KsvrVL6VGi/Awr21grYqNdshflfKJ7Ald6LtAo11n?=
	=?us-ascii?Q?c6zSO+p1/p+PJ7Pqj+JbvL86k3yAQwjC5tqgvm42Q+dCi7KM0IRBB0poGjus?=
	=?us-ascii?Q?QNNFibDylv2uz+bcxmox?=
MIME-Version:	1.0
X-OriginatorOrg:	outlook.com
X-MS-Exchange-CrossTenant-AuthAs:	Internal
X-MS-Exchange-CrossTenant-AuthSource:	DB9P251MB0063.EURP251.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg:	00000000-0000-0000-0000-000000000000
X-MS-Exchange-CrossTenant-Network-Message-Id:	b825cd04-0135-46b9-f063-08db0f52447c
X-MS-Exchange-CrossTenant-originalarrivaltime:	15 Feb 2023 12:43:41.3518 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader:	Hosted
X-MS-Exchange-CrossTenant-id:	84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa
X-MS-Exchange-CrossTenant-rms-persistedconsumerorg:	00000000-0000-0000-0000-000000000000
X-MS-Exchange-Transport-CrossTenantHeadersStamped:	AS1P251MB0680
X-Spam-Status:	No, score=-1.5 required=5.0 tests=BAYES_00, DKIM_SIGNED,
	DKIM_VALID, DKIM_VALID_AU, DKIM_VALID_EF, FREEMAIL_FROM, SPF_HELO_PASS,
	SPF_PASS, TXREP autolearn=ham autolearn_force=no version=3.4.6
X-Spam-Checker-Version:	SpamAssassin 3.4.6 (2021-04-09) on
	server2.sourceware.org
X-BeenThere:	cygwin AT cygwin DOT com
X-Mailman-Version:	2.1.29
List-Id:	General Cygwin discussions and problem reports <cygwin.cygwin.com>
List-Archive:	<https://cygwin.com/pipermail/cygwin/>
List-Post:	<mailto:cygwin AT cygwin DOT com>
List-Help:	<mailto:cygwin-request AT cygwin DOT com?subject=help>
List-Subscribe:	<https://cygwin.com/mailman/listinfo/cygwin>,
	<mailto:cygwin-request AT cygwin DOT com?subject=subscribe>
From:	Jose Isaias Cabrera via Cygwin <cygwin AT cygwin DOT com>
Reply-To:	Jose Isaias Cabrera <jicman AT outlook DOT com>
Sender:	"Cygwin" <cygwin-bounces+archive-cygwin=delorie DOT com AT cygwin DOT com>

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

-- 
Problem reports:      https://cygwin.com/problems.html
FAQ:                  https://cygwin.com/faq/
Documentation:        https://cygwin.com/docs.html
Unsubscribe info:     https://cygwin.com/ml/#unsubscribe-simple

- Raw text -