X-Recipient:	archive-cygwin AT delorie DOT com
DKIM-Filter:	OpenDKIM Filter v2.11.0 sourceware.org C1695385802F
DKIM-Signature:	v=1; a=rsa-sha256; c=relaxed/relaxed; d=cygwin.com;
	s=default; t=1676477145;
	bh=/Czja9ZY2b2UHYlEuwha5zEEevqn0WkUoInF00BuXUA=;
	h=Date:To:Subject:In-Reply-To:References:List-Id:List-Unsubscribe:
	List-Archive:List-Post:List-Help:List-Subscribe:From:Reply-To:Cc:
	From;
	b=QF4mKJei+Poq5oQpjXkHyE7FQMy1yHeUiiOdln//sZNY3HgaBXPZtPXfiaD2kW0Kr
	gGk6p7jIB9IcfONTTtFEiRLDuL6ELzaxszrNd9e7XswlcE4c+enM+9fiP3hbocfxoN
	J1v6QbI4Iq6/hMfTR7iNV+HONKCr9IgWblnjt2vk=
X-Original-To:	cygwin AT cygwin DOT com
Delivered-To:	cygwin AT cygwin DOT com
DMARC-Filter:	OpenDMARC Filter v1.4.2 sourceware.org 103813858C60
X-Yandex-Fwd:	1
Date:	Wed, 15 Feb 2023 18:55:08 +0300
X-Mailer:	The Bat! (v9.3.4) Professional
Message-ID:	<743494104.20230215185508@yandex.ru>
To:	Jose Isaias Cabrera <jicman AT outlook DOT com>, cygwin AT cygwin DOT com
Subject:	Re: Changing the python sqlite3 version to the latest
In-Reply-To:	<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>
	<DB9P251MB0063A4387A9146D1277A7C72DEA39 AT DB9P251MB0063 DOT EURP251 DOT PROD DOT OUTLOOK DOT COM>
MIME-Version:	1.0
X-Spam-Status:	No, score=-0.7 required=5.0 tests=BAYES_00, DKIM_SIGNED,
	DKIM_VALID, DKIM_VALID_AU, DKIM_VALID_EF, FREEMAIL_FROM, KAM_THEBAT,
	NICE_REPLY_A, SPF_HELO_NONE, SPF_PASS,
	TXREP autolearn=no 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-Unsubscribe:	<https://cygwin.com/mailman/options/cygwin>,
	<mailto:cygwin-request AT cygwin DOT com?subject=unsubscribe>
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:	Andrey Repin via Cygwin <cygwin AT cygwin DOT com>
Reply-To:	cygwin AT cygwin DOT com
Cc:	Andrey Repin <anrdaemon AT yandex DOT ru>
Errors-To:	cygwin-bounces+archive-cygwin=delorie DOT com AT cygwin DOT com
Sender:	"Cygwin" <cygwin-bounces+archive-cygwin=delorie DOT com AT cygwin DOT com>

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


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