NetBSD Problem Report #51947

From  Sun Feb  5 12:47:26 2017
Return-Path: <>
Received: from ( [])
	(using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits))
	(Client CN "", Issuer "Postmaster" (verified OK))
	by (Postfix) with ESMTPS id DBE497A283
	for <>; Sun,  5 Feb 2017 12:47:26 +0000 (UTC)
Message-Id: <>
Date: Sun, 5 Feb 2017 21:47:19 +0900 (JST)
From: Izumi Tsutsui <>
Subject: more pkgsrc sqlite3 features for firefox
X-Send-Pr-Version: 3.95

>Number:         51947
>Category:       pkg
>Synopsis:       more pkgsrc sqlite3 features for firefox
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    pkg-manager
>State:          open
>Class:          change-request
>Submitter-Id:   net
>Arrival-Date:   Sun Feb 05 12:50:00 +0000 2017
>Originator:     Izumi Tsutsui
>Release:        NetBSD 7.1_RC1 + pkgsrc-2016Q4
System: NetBSD mirage 7.1_RC1 NetBSD 7.1_RC1 (GENERIC.201701060741Z) i386
Architecture: i386
Machine: i386
Currently www/firefox use internal sqlite3 instead of pkgsrc sqlite3,
probably because pkgsrc one does not enable features
required by firefox. It would be worth to enable them in pkgsrc sqlite3.

Per "Compile-time Options" document
SQLITE_SECURE_DELETE is in "Options To Control Operating Characteristics"
and SQLITE_ENABLE_DBSTAT_VTAB is in "Options To Enable Features Normally
Turned Off."

I'm not sure if these options affect other packages that depend on
pkgsrc sqlite3, though.

N/A (change request)

pkgsrc/database/sqlite3 (3.16.2 in HEAD) with the following patch allows
firefox builds with --enable-system-sqlite.

(BTW py-sqlite2 and other python version definitions in
 seem obsolete)

Other packages that refer common sqlite3/Makefile.version might also
want PKGREVISION bump.

Index: Makefile
RCS file: /cvsroot/pkgsrc/databases/sqlite3/Makefile,v
retrieving revision 1.113
diff -u -p -r1.113 Makefile
--- Makefile	2 Jan 2017 17:52:23 -0000	1.113
+++ Makefile	5 Feb 2017 12:10:15 -0000
@@ -5,6 +5,7 @@
 .include "Makefile.common"

 CATEGORIES=	databases

 # This define includes the sqlite3_unlock_notify() API in the build.
 # It is required by Firefox 4.x.
+# Firefox requires SECURE_DELETE and DBSTAT_VTAB.
 # The following are defined in the NetBSD builtin version.

NetBSD Home
NetBSD PR Database Search

(Contact us) $NetBSD: query-full-pr,v 1.39 2013/11/01 18:47:49 spz Exp $
$NetBSD:,v 1.8 2006/05/07 09:23:38 tsutsui Exp $
Copyright © 1994-2014 The NetBSD Foundation, Inc. ALL RIGHTS RESERVED.