From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from EUR05-VI1-obe.outbound.protection.outlook.com (mail-vi1eur05olkn20827.outbound.protection.outlook.com [IPv6:2a01:111:f400:7d00::827]) by sourceware.org (Postfix) with ESMTPS id 931683858D33 for ; Wed, 15 Feb 2023 12:43:45 +0000 (GMT) DMARC-Filter: OpenDMARC Filter v1.4.2 sourceware.org 931683858D33 Authentication-Results: sourceware.org; dmarc=pass (p=none dis=none) header.from=outlook.com Authentication-Results: sourceware.org; spf=pass smtp.mailfrom=outlook.com 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 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=outlook.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=WO9xIwPnUL/eXTwqTOXwWU7bpSQ4fyRi934O80arCSU=; b=mR6eXdfkPcZaFlfv4cntI5xh6pj62lZV1RtkITMj/hlh/cGTfymAYfRQCZrt8RaDH72pNHq6UIeadIzTXF31wt279lwD7FuR1MASccp8rSeNOhEAX/wIpMR1E0Gh+qhvjX/RTpq3C0vpFfhdP6rIHq94Ba0+kWKrJ0GHsUoDOKaQNFpi0izuafYG4sMzxAxSTQ36y/Dzo7f7F2W7lGBIR+eo+qKrIrgx+xOco2CIYyyLcTmryLBnh6HxtOuN/13/oUliwSDHnCs0Kers3frGFbxyPXAOeix2Q2uofFH2Sfs1h7h0KPb63TJPQEADY/1Lz2303YrsxIsxj7pCEXb+5A== Received: from DB9P251MB0063.EURP251.PROD.OUTLOOK.COM (2603:10a6:10:2c9::18) by AS1P251MB0680.EURP251.PROD.OUTLOOK.COM (2603:10a6:20b:48c::21) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.6086.24; Wed, 15 Feb 2023 12:43:41 +0000 Received: from DB9P251MB0063.EURP251.PROD.OUTLOOK.COM ([fe80::b2b1:626e:c893:7382]) by DB9P251MB0063.EURP251.PROD.OUTLOOK.COM ([fe80::b2b1:626e:c893:7382%5]) with mapi id 15.20.6086.026; Wed, 15 Feb 2023 12:43:41 +0000 From: Jose Isaias Cabrera To: "cygwin@cygwin.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: References: <82184ff9-cc61-2a5f-947b-ecf9916e2411@gmail.com> In-Reply-To: Accept-Language: en-US Content-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?= Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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 List-Id: On February 14, 2023 8:46 PM, Jose Isaias Cabrera expressed: >=20 >=20 > 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 >=20 > 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=3D/usr $ make install And this process has set the python SQLite version to the sqlite-snapshot v= ersion. After that, you can download the trunk and follow the same procedur= e, 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 ecdeef43b27412b0b0b09e09a62ad3a03836a3fc80f2070268090e7= ca8f02712 I hope this helps. [JIC]=20 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 =3D ":memory:" con =3D ConnectToSharedDB(SharedDB) cur =3D con.cursor() cur.execute("SELECT sqlite_version(),sqlite_source_id();") for row in cur: print(row[0] + '\r\n' + row[1]) con.close()