From owner-freebsd-pkg@freebsd.org Wed Sep 9 20:46:23 2015 Return-Path: Delivered-To: freebsd-pkg@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 400F6A019D1 for ; Wed, 9 Sep 2015 20:46:23 +0000 (UTC) (envelope-from matthew@FreeBSD.org) Received: from smtp.infracaninophile.co.uk (smtp.infracaninophile.co.uk [IPv6:2001:8b0:151:1:3cd3:cd67:fafa:3d78]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client CN "smtp.infracaninophile.co.uk", Issuer "infracaninophile.co.uk" (not verified)) by mx1.freebsd.org (Postfix) with ESMTPS id C471A1AC6 for ; Wed, 9 Sep 2015 20:46:22 +0000 (UTC) (envelope-from matthew@FreeBSD.org) Received: from liminal.local (liminal.infracaninophile.co.uk [IPv6:2001:8b0:151:1:3636:3bff:fed4:b0d6]) (authenticated bits=0) by smtp.infracaninophile.co.uk (8.15.2/8.15.2) with ESMTPSA id t89KkDiE045759 (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128 verify=NO) for ; Wed, 9 Sep 2015 21:46:13 +0100 (BST) (envelope-from matthew@FreeBSD.org) Authentication-Results: smtp.infracaninophile.co.uk; dmarc=none header.from=FreeBSD.org DKIM-Filter: OpenDKIM Filter v2.10.3 smtp.infracaninophile.co.uk t89KkDiE045759 Authentication-Results: smtp.infracaninophile.co.uk/t89KkDiE045759; dkim=none; dkim-atps=neutral X-Authentication-Warning: lucid-nonsense.infracaninophile.co.uk: Host liminal.infracaninophile.co.uk [IPv6:2001:8b0:151:1:3636:3bff:fed4:b0d6] claimed to be liminal.local Subject: Re: pkg list installed by date To: freebsd-pkg@freebsd.org References: From: Matthew Seaman X-Enigmail-Draft-Status: N1110 Message-ID: <55F09A87.8040905@FreeBSD.org> Date: Wed, 9 Sep 2015 21:45:59 +0100 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:38.0) Gecko/20100101 Thunderbird/38.2.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="6UOisd3DtXQx8V3S8KjxKg2HiCFxa8m6E" X-Virus-Scanned: clamav-milter 0.98.7 at lucid-nonsense.infracaninophile.co.uk X-Virus-Status: Clean X-Spam-Status: No, score=-2.7 required=5.0 tests=ALL_TRUSTED,AWL,BAYES_00 autolearn=ham autolearn_force=no version=3.4.1 X-Spam-Checker-Version: SpamAssassin 3.4.1 (2015-04-28) on lucid-nonsense.infracaninophile.co.uk X-BeenThere: freebsd-pkg@freebsd.org X-Mailman-Version: 2.1.20 Precedence: list List-Id: Binary package management and package tools discussion List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 09 Sep 2015 20:46:23 -0000 This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --6UOisd3DtXQx8V3S8KjxKg2HiCFxa8m6E Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable On 09/09/2015 19:05, jungle Boogie wrote: > But pkg uses a sqlite3 database. Can't I alter the query? It somehow > has a query to sort alphabetically. Sure, if you want to write your own custom SQL for querying the package DB, knock yourself out. Please avoid publishing any software that relies on your own custom SQL though: the database schema does occasionally get changed and we don't guarantee that compatibility with any particular SQL queries will be maintained. Cheers, Matthew --6UOisd3DtXQx8V3S8KjxKg2HiCFxa8m6E Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG/MacGPG2 v2 iQJ8BAEBCgBmBQJV8JqQXxSAAAAAAC4AKGlzc3Vlci1mcHJAbm90YXRpb25zLm9w ZW5wZ3AuZmlmdGhob3JzZW1hbi5uZXQ2NTNBNjhCOTEzQTRFNkNGM0UxRTEzMjZC QjIzQUY1MThFMUE0MDEzAAoJELsjr1GOGkATzMkP/AveiWi4xfGHFFjr7D6XVtjj zO6qaRUJB4CR+ay2k4ZeMbyr/q5JQGKvez4hQIbQImZCslBGyaHp8mlSDp7K8EYA VhI7yu68tbLMJELB+Zc8MZSNR8UXZ5qGDURcEFdh6VbHW2eYiYIy1etY5U+x3KPS AdhPFyW0PUrfTD6oXVWXpe4cm+JVyvS+NaPaLj5CvlFsodi5Vix/lO8QOMtckqBe RFpaZc5rXuxeZXBCrOnFSyp1gsRakwy7HgTrugL/BUuGxttOB7oEnqvij5v6eUOl Wd7w7xpNqjb5oEQYJ/sM63VhoktQbskYqHVNWRNAJCpsOGrq/+wC4Ij9kfEMKJkA Dz/pUy3x0p1DqDkvGtKFGN2JfpH2SSORpypZJT0JM4YmReDVcLGxjhXZ3e4DV8fI sdEA79xQqDaaw1Xbo6YPBvPT+qUStnsL+EFvfF3R/xrF4BGPyxCqeT5p+2bfNLU4 EslWX4+AvRKXENh0diQuNZXsDJuUGRoxlSUvqPj2lyG/edHIvWpC1EXKRqSkC6ER z9RzfYnBYhwVuz5DATP1Mwrig2JYO/4vodgkSQ9/bWKf8jWDHxdHB3cXsDaI5rEO D7siBX4y1O1OwEaxMd4V4QvCjYJOKB/JBtW9UWWBd85ibVAYSitEVLy0sv+l27sH pM5b5IYXJOuFsuIl3Ivb =c7S/ -----END PGP SIGNATURE----- --6UOisd3DtXQx8V3S8KjxKg2HiCFxa8m6E--