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
Precedence: list
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>
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
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