Your message dated Sat, 07 May 2022 12:39:08 +0000
with message-id <[email protected]>
and subject line Bug#1010516: fixed in sqlite3 3.38.5-1
has caused the Debian Bug report #1010516,
regarding sqlite3: consider linking dynamically
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
1010516: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1010516
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: sqlite3
Version: 3.38.3-1
Severity: wishlist
Tags: patch
Hi,
I was investigating why sqlite3 was so "big" and noticed that it links
libsqlite3 statically. The most common reason for doing so is usage of
unexported symbols. Evidently that's not the case here. So why would it
not link dynamically?
I looked into whether doing it was possible. The attached patch makes
sqlite3 link libsqlite3 dynamically. Easy enough. Possibly, we'd have to
guard it by some configure option to make it upstreamable.
How do package sizes change?
libsqlite3-0 has an Installed-Size of 1664 and is obviously unaffected
by the change. Prior to the change, sqlite3 weighs in at Installed-Size
1878. After the change, its size is reduced to 519, but we must now
account for libsqlite3-0, so we effectively get 2183, i.e. a growth of
305. The bulk of that is the (duplicated) contents of of /usr/share/doc.
Given that libsqlite3-0 is pulled by very many packages, and that
/usr/share/doc can be removed in size-constrained settings, the
reduction achieved by dynamic linking seems reasonable to me. Do you
agree?
Helmut
--- sqlite3-3.38.3.orig/Makefile.in
+++ sqlite3-3.38.3/Makefile.in
@@ -657,9 +657,9 @@
-avoid-version
sed -i "/dependency_libs/s/'.*'/''/" $@
-sqlite3$(TEXE): shell.c sqlite3.c
+sqlite3$(TEXE): shell.c libsqlite3.la
$(LTLINK) $(READLINE_FLAGS) $(SHELL_OPT) -o $@ \
- shell.c sqlite3.c \
+ shell.c libsqlite3.la \
$(LIBREADLINE) $(TLIBS) -rpath "$(libdir)"
sqldiff$(TEXE): $(TOP)/tool/sqldiff.c sqlite3.lo sqlite3.h
--- End Message ---
--- Begin Message ---
Source: sqlite3
Source-Version: 3.38.5-1
Done: Laszlo Boszormenyi (GCS) <[email protected]>
We believe that the bug you reported is fixed in the latest version of
sqlite3, which is due to be installed in the Debian FTP archive.
A summary of the changes between this version and the previous one is
attached.
Thank you for reporting the bug, which will now be closed. If you
have further comments please address them to [email protected],
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Laszlo Boszormenyi (GCS) <[email protected]> (supplier of updated sqlite3 package)
(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing [email protected])
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512
Format: 1.8
Date: Sat, 07 May 2022 13:18:57 +0200
Source: sqlite3
Architecture: source
Version: 3.38.5-1
Distribution: unstable
Urgency: high
Maintainer: Laszlo Boszormenyi (GCS) <[email protected]>
Changed-By: Laszlo Boszormenyi (GCS) <[email protected]>
Closes: 1010516
Changes:
sqlite3 (3.38.5-1) unstable; urgency=high
.
* New upstream release:
- fix a byte-code problem in the Bloom filter pull-down optimization that
enters an infinite loop.
.
[ Helmut Grohne <[email protected]> ]
* Link sqlite3 dynamically with its library (closes: #1010516).
Checksums-Sha1:
892ef49abd27c3f49af90ae06475156e4150fdb5 2487 sqlite3_3.38.5-1.dsc
61ed6d8ba6bf8555176d3ced875f5d8c88855206 5739536 sqlite3_3.38.5.orig-www.tar.xz
3805b11cf617826a9ad5f32846ef302188f3c59f 7670860 sqlite3_3.38.5.orig.tar.xz
5382373df795e193b24ec5e6a7eab39467bd6a85 28960 sqlite3_3.38.5-1.debian.tar.xz
Checksums-Sha256:
d931677fdf1b1517c78fafff8f035d82dd5f4eb5ca7ccee0be9e2e46aac414d2 2487
sqlite3_3.38.5-1.dsc
d7a8f9efbf9183fac33bbcd973d43d749c0cf5a9d91ef1004df96c8c20e271e3 5739536
sqlite3_3.38.5.orig-www.tar.xz
a61b5287627f969ce55bfe19dc2f263bf16154fc033add1ed9f49c01fa5c0566 7670860
sqlite3_3.38.5.orig.tar.xz
2b958966b1ef32be41480cbaf100c9eddc3ab76bb63dbf3987f63ff2d1258682 28960
sqlite3_3.38.5-1.debian.tar.xz
Files:
c729b3c848ca24cbafab13d45202926d 2487 devel optional sqlite3_3.38.5-1.dsc
a059b486c344ecfc3e461f41545667c8 5739536 devel optional
sqlite3_3.38.5.orig-www.tar.xz
4c1658f06925ee0651a6035dad831a76 7670860 devel optional
sqlite3_3.38.5.orig.tar.xz
1c94a6c8b5386707763abed253ef4397 28960 devel optional
sqlite3_3.38.5-1.debian.tar.xz
-----BEGIN PGP SIGNATURE-----
iQIzBAEBCgAdFiEEfYh9yLp7u6e4NeO63OMQ54ZMyL8FAmJ2YskACgkQ3OMQ54ZM
yL8AyhAApcumRUztDIrh0XWaRyfk0pv7NtXzdUWK6WoIjKG/9vtZEjavKnPCMBf8
70ljPaFvIPXRXibcJh/J3CSDjEHJ2J9gxG6xsl0/MNDs0lnrPw3m9kYyMYuoH75o
y/EuSD9FFOwSDwJ5Qe/9f+SRtAigG3OBhkZEDOg6cT3ork94TbALVOeBllKWLsQF
Tl1NA9dPPDdLgljstIQahrUUF8MUAQPlzhz9Ea9oj7U3fWLRqba4UPUbF+aO/rqt
TxUvgOp758k7KslVIoCFgs9KSNZfbfBeOTwkyYtolhuVmq/PsM4Giec2r6R3qmTZ
98DDmSLyeNxyYRC/wr9h6iyzE1FkiIBpjGNTvEtJDCWMty/NXoTrivwsETWSFMeA
MMKceC/uqU3GDTZc1FvH8dz9qT7FZdXigsuUAGyzcQxRUa9OCbAE3KsgawmVgUja
UkmvtjAOF6Wv78s9nFIlUs6Pe7seDFJ7SVu6ItZN3+H2CxAucWTOmZBJIxfl2xQc
lG9bAo5kYUH3rnNLvjhaAS/jjm1VitWqNJzzgzbClQcv0lYHesfhsYjg7JpHQlHE
YAGlXHAETLeMMBJ+9zp/EPV/oRTTJgi80A37Q6OC1PCPEI3oeYTeWvKEejAbV1fs
DqpA4GjyXn6cDpVSu+yWgQDPjXBFV23+d5YSLT4JWktDRwuPJyE=
=m1Z7
-----END PGP SIGNATURE-----
--- End Message ---
