7 files changed, 30 insertions, 25 deletions
diff --git a/databases/sqlite3-docs/PLIST b/databases/sqlite3-docs/PLIST
index 0575d7f1a14..e23506ac507 100644
--- a/databases/sqlite3-docs/PLIST
+++ b/databases/sqlite3-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.118 2022/10/03 12:27:52 adam Exp $
+@comment $NetBSD: PLIST,v 1.119 2022/11/17 06:20:44 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -118,6 +118,7 @@ share/doc/sqlite3/c3ref/experimental.html
 share/doc/sqlite3/c3ref/extended_result_codes.html
 share/doc/sqlite3/c3ref/file.html
 share/doc/sqlite3/c3ref/file_control.html
+share/doc/sqlite3/c3ref/filename.html
 share/doc/sqlite3/c3ref/filename_database.html
 share/doc/sqlite3/c3ref/finalize.html
 share/doc/sqlite3/c3ref/free.html
@@ -468,6 +469,7 @@ share/doc/sqlite3/images/sqlite370.jpg
 share/doc/sqlite3/images/sqlite370_banner.gif
 share/doc/sqlite3/images/sqlitepie.jpg
 share/doc/sqlite3/images/src_logo.gif
+share/doc/sqlite3/images/sschart20221116.jpg
 share/doc/sqlite3/images/sw.gif
 share/doc/sqlite3/images/sw.png
 share/doc/sqlite3/images/table-ex1b2.gif
@@ -551,6 +553,7 @@ share/doc/sqlite3/queryplanner.html
 share/doc/sqlite3/quickstart.html
 share/doc/sqlite3/quirks.html
 share/doc/sqlite3/rbu.html
+share/doc/sqlite3/recovery.html
 share/doc/sqlite3/releaselog/3_0_0.html
 share/doc/sqlite3/releaselog/3_0_1.html
 share/doc/sqlite3/releaselog/3_0_2.html
@@ -669,6 +672,7 @@ share/doc/sqlite3/releaselog/3_3_6.html
 share/doc/sqlite3/releaselog/3_3_7.html
 share/doc/sqlite3/releaselog/3_3_8.html
 share/doc/sqlite3/releaselog/3_3_9.html
+share/doc/sqlite3/releaselog/3_40_0.html
 share/doc/sqlite3/releaselog/3_4_0.html
 share/doc/sqlite3/releaselog/3_4_1.html
 share/doc/sqlite3/releaselog/3_4_2.html
@@ -846,6 +850,7 @@ share/doc/sqlite3/sqlanalyze.html
 share/doc/sqlite3/sqlar.html
 share/doc/sqlite3/sqldiff.html
 share/doc/sqlite3/sqlite.css
+share/doc/sqlite3/sqlite.css~
 share/doc/sqlite3/sqlite.html
 share/doc/sqlite3/stmt.html
 share/doc/sqlite3/stricttables.html
diff --git a/databases/sqlite3-docs/distinfo b/databases/sqlite3-docs/distinfo
index 85275983396..c7a91fe46d5 100644
--- a/databases/sqlite3-docs/distinfo
+++ b/databases/sqlite3-docs/distinfo
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.121 2022/10/03 12:27:52 adam Exp $
+$NetBSD: distinfo,v 1.122 2022/11/17 06:20:44 adam Exp $
 
-BLAKE2s (sqlite-doc-3390400.zip) = ee8d991decabf8089b0dd80157930f33a9d38c8526c97da6faa17c1033a9939e
-SHA512 (sqlite-doc-3390400.zip) = 75d97b0f2f0d530b2e0ad505574af3bf657d82f0859bb5de7ee45c40a80351e933944845cedca56b579925a3d07505c6f4721f756f27862ffafdfc2caff539fb
-Size (sqlite-doc-3390400.zip) = 10853153 bytes
+BLAKE2s (sqlite-doc-3400000.zip) = 335f41408e24dc66874aeaf55bf6c7f5594b8afc0938c061c34a9f9f73d10d85
+SHA512 (sqlite-doc-3400000.zip) = 3557fe49e08fd24890da584f3fa7fb93d1e3317787f98a8ce1062dcac07733782026e50dfef7db72582739ddf0a77095cc4d3a81f3df097a69e85c672591bf7e
+Size (sqlite-doc-3400000.zip) = 10921883 bytes
diff --git a/databases/sqlite3-tcl/distinfo b/databases/sqlite3-tcl/distinfo
index 808b3420c79..9d05147502b 100644
--- a/databases/sqlite3-tcl/distinfo
+++ b/databases/sqlite3-tcl/distinfo
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.133 2022/10/03 12:27:52 adam Exp $
+$NetBSD: distinfo,v 1.134 2022/11/17 06:20:44 adam Exp $
 
-BLAKE2s (sqlite-autoconf-3390400.tar.gz) = efef4f594d97c8a4bd724c16f7ae7c9f295eb0a52193146753cb08392e5d5b97
-SHA512 (sqlite-autoconf-3390400.tar.gz) = cc1de214e69ef677cac3f6dd2000ccfcf4b672ab464a115d96f24707009a408630e762c3cda89741b728ab34c4d9f5b8f8b12e9b11448e8364642b4421c3393d
-Size (sqlite-autoconf-3390400.tar.gz) = 3065214 bytes
-SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537
+BLAKE2s (sqlite-autoconf-3400000.tar.gz) = 378945cc6da267e3c5652afe62731904acc6d4a2154c0b2fb08355a5cbdced00
+SHA512 (sqlite-autoconf-3400000.tar.gz) = 175271e620dd947df2ca63c3ea6cff80e16f8f808a3ea7f6700282768adc2d61ac375d42b2064c73eec849c67307ac5291fdadc3059861caa015ac3ac7a480e4
+Size (sqlite-autoconf-3400000.tar.gz) = 3097756 bytes
+SHA1 (patch-Makefile.in) = 8f68039c9169bc69eb0da4bd0f910c7584aed2b5
diff --git a/databases/sqlite3-tcl/patches/patch-Makefile.in b/databases/sqlite3-tcl/patches/patch-Makefile.in
index 9f1008a72d0..85ae0ff0870 100644
--- a/databases/sqlite3-tcl/patches/patch-Makefile.in
+++ b/databases/sqlite3-tcl/patches/patch-Makefile.in
@@ -1,10 +1,10 @@
-$NetBSD: patch-Makefile.in,v 1.1 2017/06/10 19:14:00 adam Exp $
+$NetBSD: patch-Makefile.in,v 1.2 2022/11/17 06:20:44 adam Exp $
 
 Install into correct directory.
 
---- Makefile.in.orig	2014-03-10 13:47:51.000000000 +0000
+--- Makefile.in.orig	2022-11-16 13:42:39.000000000 +0000
 +++ Makefile.in
-@@ -81,7 +81,7 @@ DESTDIR		=
+@@ -83,7 +83,7 @@ DESTDIR		=
  
  PKG_DIR		= $(PACKAGE_NAME)$(PACKAGE_VERSION)
  pkgdatadir	= $(datadir)/$(PKG_DIR)
@@ -12,4 +12,4 @@ Install into correct directory.
 +pkglibdir	= $(libdir)/sqlite3
  pkgincludedir	= $(includedir)/$(PKG_DIR)
  
- top_builddir	= .
+ top_builddir	= @abs_top_builddir@
diff --git a/databases/sqlite3/Makefile.common b/databases/sqlite3/Makefile.common
index 9aa4bc179df..d719deb2bbe 100644
--- a/databases/sqlite3/Makefile.common
+++ b/databases/sqlite3/Makefile.common
@@ -1,12 +1,12 @@
-# $NetBSD: Makefile.common,v 1.95 2022/10/03 12:27:52 adam Exp $
+# $NetBSD: Makefile.common,v 1.96 2022/11/17 06:20:44 adam Exp $
 #
 # used by databases/sqlite3/Makefile
 # used by databases/sqlite3-docs/Makefile
 # used by databases/sqlite3-tcl/Makefile
 # used by devel/lemon/Makefile
 
-SQLITE3_DISTVERSION=	3390400
-SQLITE3_VERSION=	3.39.4
+SQLITE3_DISTVERSION=	3400000
+SQLITE3_VERSION=	3.40.0
 
 MASTER_SITES=	http://www.sqlite.org/2022/
 MASTER_SITES+=	http://www.hwaci.com/sw/sqlite/2022/
diff --git a/databases/sqlite3/distinfo b/databases/sqlite3/distinfo
index c72037e696f..72075ac1d32 100644
--- a/databases/sqlite3/distinfo
+++ b/databases/sqlite3/distinfo
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.188 2022/10/03 12:27:52 adam Exp $
+$NetBSD: distinfo,v 1.189 2022/11/17 06:20:44 adam Exp $
 
-BLAKE2s (sqlite-autoconf-3390400.tar.gz) = efef4f594d97c8a4bd724c16f7ae7c9f295eb0a52193146753cb08392e5d5b97
-SHA512 (sqlite-autoconf-3390400.tar.gz) = cc1de214e69ef677cac3f6dd2000ccfcf4b672ab464a115d96f24707009a408630e762c3cda89741b728ab34c4d9f5b8f8b12e9b11448e8364642b4421c3393d
-Size (sqlite-autoconf-3390400.tar.gz) = 3065214 bytes
+BLAKE2s (sqlite-autoconf-3400000.tar.gz) = 378945cc6da267e3c5652afe62731904acc6d4a2154c0b2fb08355a5cbdced00
+SHA512 (sqlite-autoconf-3400000.tar.gz) = 175271e620dd947df2ca63c3ea6cff80e16f8f808a3ea7f6700282768adc2d61ac375d42b2064c73eec849c67307ac5291fdadc3059861caa015ac3ac7a480e4
+Size (sqlite-autoconf-3400000.tar.gz) = 3097756 bytes
 SHA1 (patch-configure) = c0aa83bddc20d090b3cd2fd840ac69031f4396e4
diff --git a/devel/lemon/distinfo b/devel/lemon/distinfo
index 50f8768a73e..1c7e3785546 100644
--- a/devel/lemon/distinfo
+++ b/devel/lemon/distinfo
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.62 2022/10/03 12:27:52 adam Exp $
+$NetBSD: distinfo,v 1.63 2022/11/17 06:20:44 adam Exp $
 
-BLAKE2s (sqlite-src-3390400.zip) = 58782c11d2e04d06f8ed91c5ae61bf2099cb9f812373f761c8cf697c5f584063
-SHA512 (sqlite-src-3390400.zip) = 0acb8afc87f911c91ec555cc97af5b77b6b0e80cc8672711ddd87c651d9e11b697c9669ff9ba2b58da12b972bb46acdf8b8fe35993950f10735b4036501b73bb
-Size (sqlite-src-3390400.zip) = 13405169 bytes
+BLAKE2s (sqlite-src-3400000.zip) = 6fcf2d0a0046143a892cef16c3c5d4986aa93febebbf4fcae207e9069a94a038
+SHA512 (sqlite-src-3400000.zip) = c3bb3829f99c663f3381f4c610e401173f133fe944558b70da7521cc44116d048e4e1651993feb128b0f3814381aa4fa93f48ba3e277abca3442af805159287d
+Size (sqlite-src-3400000.zip) = 13723231 bytes