From owner-freebsd-ports@FreeBSD.ORG Thu Feb 6 18:17:34 2014 Return-Path: Delivered-To: freebsd-ports@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) (using TLSv1 with cipher ADH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id 0369756D for ; Thu, 6 Feb 2014 18:17:34 +0000 (UTC) Received: from shiva.jussieu.fr (shiva.jussieu.fr [134.157.0.129]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mx1.freebsd.org (Postfix) with ESMTPS id 344B014BC for ; Thu, 6 Feb 2014 18:17:32 +0000 (UTC) Received: from parthe.lpthe.jussieu.fr (parthe.lpthe.jussieu.fr [134.157.10.1]) by shiva.jussieu.fr (8.14.4/jtpda-5.4) with ESMTP id s16IH3pH017514 ; Thu, 6 Feb 2014 19:17:16 +0100 (CET) X-Ids: 168 Received: from [192.168.1.101] (sge91-2-82-227-32-26.fbx.proxad.net [82.227.32.26]) (using TLSv1 with cipher AES128-SHA (128/128 bits)) (Client did not present a certificate) by parthe.lpthe.jussieu.fr (Postfix) with ESMTPSA id BD73FE0EE8; Thu, 6 Feb 2014 19:17:01 +0100 (CET) Subject: Re: [FreeBSD-Ports-Announce] Time to bid farewell to the old pkg_ tools Mime-Version: 1.0 (Apple Message framework v1283) Content-Type: multipart/signed; boundary="Apple-Mail=_D6A04D32-0B97-4630-B76B-5AE247E97500"; protocol="application/pkcs7-signature"; micalg=sha1 From: Michel Talon In-Reply-To: <201402061228.s16CRo02023097@fire.js.berklix.net> Date: Thu, 6 Feb 2014 19:17:02 +0100 Message-Id: <01A7684D-EBAF-4CC2-95DD-0FED284DE878@lpthe.jussieu.fr> References: <201402061228.s16CRo02023097@fire.js.berklix.net> To: "Julian H. Stacey" X-Mailer: Apple Mail (2.1283) X-Miltered: at jchkmail2.reseau.jussieu.fr with ID 52F3D19F.000 by Joe's j-chkmail (http : // j-chkmail dot ensmp dot fr)! X-j-chkmail-Enveloppe: 52F3D19F.000 from parthe.lpthe.jussieu.fr/parthe.lpthe.jussieu.fr/134.157.10.1/parthe.lpthe.jussieu.fr/ X-Content-Filtered-By: Mailman/MimeDel 2.1.17 Cc: freebsd-ports@freebsd.org X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.17 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 06 Feb 2014 18:17:34 -0000 --Apple-Mail=_D6A04D32-0B97-4630-B76B-5AE247E97500 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=iso-8859-1 Le 6 f=E9vr. 2014 =E0 13:27, Julian H. Stacey a =E9crit : >>=20 >> you =3D >> have to spend a couple of minutes >> learning the basic SQL queries, which is no more difficult that = learning =3D >> obtuse find and grep options. >=20 > Package addicts were so myopic they ignored some people won't even > use packages, just /usr/ports & make. local.sqlite was immaturely > shoved in without documenting it, no "man 5 local.sqlite" no hook > there for the "couple of minutes learning" you assert, (no hook to = believe > the "couple" you assert). First please excuse me, this message is posted via an Apple mail system. = So how to interact with local.sqlite? niobe% sqlite3 local.sqlite=20 SQLite version 3.8.2 2013-12-06 14:53:30 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .tables annotation options pkg_script =20 categories packages pkg_shlibs =20 deps pkg_annotation pkg_shlibs_provided directories pkg_categories pkg_shlibs_required files pkg_directories pkg_users =20 groups pkg_groups script =20 licenses pkg_licenses scripts =20 mtree pkg_option shlibs =20 option pkg_option_default users =20 option_desc pkg_option_desc =20 sqlite> .schema packages CREATE TABLE packages (id INTEGER PRIMARY KEY,origin TEXT UNIQUE NOT = NULL,name TEXT NOT NULL,version TEXT NOT NULL,comment TEXT NOT NULL,desc = TEXT NOT NULL,mtree_id INTEGER REFERENCES mtree(id) ON DELETE RESTRICT = ON UPDATE CASCADE,message TEXT,arch TEXT NOT NULL,maintainer TEXT NOT = NULL, www TEXT,prefix TEXT NOT NULL,flatsize INTEGER NOT NULL,automatic = INTEGER NOT NULL,locked INTEGER NOT NULL DEFAULT 0,licenselogic INTEGER = NOT NULL,time INTEGER, manifestdigest TEXT NULL, pkg_format_version = INTEGER); CREATE INDEX pkg_digest_id ON packages(origin, manifestdigest); sqlite> select name,version from packages limit 10; pkg|1.2.5 xproto|7.0.25 xextproto|7.2.1 xbitmaps|1.1.1 renderproto|0.11.1 libXdmcp|1.1.1 libXau|1.0.8 libxml2|2.8.0_3 libpthread-stubs|0.3_4 kbproto|1.0.6 and to replace grepping sqlite> select name,version from packages where name like '%kde%' limit = 10; kdehier4|1.1.1_1 kde4-wallpapers-freebsd|1.0 pam_kde|1.0 kde4-xdg-env|1.0.1 kde4-icons-oxygen|4.10.5 kde4-shared-mime-info|1.2 kdelibs|4.10.5_2 kde-wallpapers|4.10.5 kde-base-artwork|4.10.5 polkit-kde|0.99.1 sqlite> .quit niobe%=20 =46rom this it is easy to experiment, and the full sqlite documentation = is at: http://www.sqlite.org/lang.html -- Michel Talon talon@lpthe.jussieu.fr --Apple-Mail=_D6A04D32-0B97-4630-B76B-5AE247E97500 Content-Disposition: attachment; filename=smime.p7s Content-Type: application/pkcs7-signature; name=smime.p7s Content-Transfer-Encoding: base64 MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIIbzCCA7Yw ggKeoAMCAQICAQMwDQYJKoZIhvcNAQEFBQAwLDELMAkGA1UEBhMCRlIxDTALBgNVBAoTBENOUlMx DjAMBgNVBAMTBUNOUlMyMB4XDTA5MDEyMTA5MDM1MloXDTI5MDEyMDA5MDM1MlowNTELMAkGA1UE BhMCRlIxDTALBgNVBAoTBENOUlMxFzAVBgNVBAMTDkNOUlMyLVN0YW5kYXJkMIIBIjANBgkqhkiG 9w0BAQEFAAOCAQ8AMIIBCgKCAQEAnKlkarQHIxnDvggIxOIqXe3UKN7+P6DtkkRrFkc1EzeNdKn1 TYPkBRuPCGFM3ndb16n/u2Wdyaw8D/GJe5MioEcPXwa+jnigC3nXQmVhcmOSQIpbZxD61ic+2HdN Hnnbb0sSAFJY4thCBbIzN3fgjWwdvPj28pRYJfeC2YbZXPPYLs39cIkEh+850SrYkoxpLxxSZfpg jxB/zI/5XC4U7UyL4J03uNI8lMpQ/UF63vY87K7svVwW3bDwc5l6gf87M9IAnk2Mxls4LjPDdobK clTbLeIQ/ZJQaJOE7XepiWlRhevglKP5lwgRjCTwD7o4tCzW12xOY/60MZ/vj6ZapQIDAQABo4HZ MIHWMA8GA1UdEwEB/wQFMAMBAf8wHQYDVR0OBBYEFBHj2dFSRxtZsTwbeGZr9KGI7QpbMFQGA1Ud IwRNMEuAFFCXtg33rDMXr/EdRjxrO/8AoOXloTCkLjAsMQswCQYDVQQGEwJGUjENMAsGA1UEChME Q05SUzEOMAwGA1UEAxMFQ05SUzKCAQAwDgYDVR0PAQH/BAQDAgEGMD4GA1UdHwQ3MDUwM6AxoC+G LWh0dHA6Ly9jcmxzLnNlcnZpY2VzLmNucnMuZnIvQ05SUzIvZ2V0ZGVyLmNybDANBgkqhkiG9w0B AQUFAAOCAQEAT+njF+ZMJ/UXalBV6u7PTKq97izddj5ZoC8LaInaQ9AeHSxrEvlnE55lK6SE0jHP gqDK7yLoEGzpzxd8rK2HhUyK4dV7TObZDrKh5CmeIK8PPnu5fyRMMuCI/nrarBZgoXWuiZyKZp2U un6rDiAj7ffHhF2CSBTexNSwxU4sh9SNAxEvNtUpb66ZZxkMjW1aIN/Rn8bLr1XuC8qxWw/vXHT0 80aJY0d+LM6/yDANAEb2GOZsPzB+kG4QjR85Sc+TaevInsJnc69Ki/Z8Qijdpd3tr8lVG2Q/VLxh JhDrkdXp9+7Q9gsL+qaQ3WD0QJ0Lp5z4zi8hOP6rBr/aDXf6ZzCCBLEwggOZoAMCAQICAlA7MA0G CSqGSIb3DQEBBQUAMDUxCzAJBgNVBAYTAkZSMQ0wCwYDVQQKEwRDTlJTMRcwFQYDVQQDEw5DTlJT Mi1TdGFuZGFyZDAeFw0xMjA0MjQxMTE2MDJaFw0xNDA0MjQxMTE2MDJaMGwxCzAJBgNVBAYTAkZS MQ0wCwYDVQQKEwRDTlJTMRAwDgYDVQQLEwdVTVI3NTg5MRUwEwYDVQQDEwxNaWNoZWwgVGFsb24x JTAjBgkqhkiG9w0BCQEWFnRhbG9uQGxwdGhlLmp1c3NpZXUuZnIwggEiMA0GCSqGSIb3DQEBAQUA A4IBDwAwggEKAoIBAQDgBxV/HgKdmPL6b8jVvUTR1SWD0aKiqo5WtdQqBIcmN2/dNqXbNt9YNznR Y4KLzV8VIFSj4WqDfzxCx6Xxulww7iwP8FE+Mt9NEQFtYoh9yZdokMTPQgYQ/sJTbvTSLK2f9IRV HCTnJkG1jRLzNKp9T+jbLpauKNX97jAzGFa5pqip0ARGduLmVTSEY4yDzgMjUXT/ghrA+emngSBW RDMj2nbcvPi5UqvbHv6oC/HrSl8YiN7zck9A7sWQqw8Dkzi7y5Az9cHaK5baoDJsmXtJjdE2poJU QFgj+qw5v1//rzWao6vF1Y2YuALbDk2rY0FGbHKBvQdUIOd9FPWVHcDhAgMBAAGjggGSMIIBjjAM BgNVHRMBAf8EAjAAMBEGCWCGSAGG+EIBAQQEAwIEsDAOBgNVHQ8BAf8EBAMCBeAwegYJYIZIAYb4 QgENBG0Wa0NlcnRpZmljYXQgQ05SUzItU3RhbmRhcmQuIFBvdXIgdG91dGUgaW5mb3JtYXRpb24g c2UgcmVwb3J0ZXIg4CBodHRwOi8vaWdjLnNlcnZpY2VzLmNucnMuZnIvQ05SUzItU3RhbmRhcmQv MB0GA1UdDgQWBBQVwmDyLZNTeQ9+lLkAnYAWHPUEyTBUBgNVHSMETTBLgBQR49nRUkcbWbE8G3hm a/ShiO0KW6EwpC4wLDELMAkGA1UEBhMCRlIxDTALBgNVBAoTBENOUlMxDjAMBgNVBAMTBUNOUlMy ggEDMCEGA1UdEQQaMBiBFnRhbG9uQGxwdGhlLmp1c3NpZXUuZnIwRwYDVR0fBEAwPjA8oDqgOIY2 aHR0cDovL2NybHMuc2VydmljZXMuY25ycy5mci9DTlJTMi1TdGFuZGFyZC9nZXRkZXIuY3JsMA0G CSqGSIb3DQEBBQUAA4IBAQBZqTWOw11I3rblql8PEPHhnPntu2IEg9DQRgP8jucvURw8KpZ7s94W 4hP13kmDhqGC4/St/XH4IlT86L64Zqt3toUoncLPjBfBYmQWGUgC08qhhuopLqsE1uvkdg5IX0bz RqOpEeybEpdrWrTs5DmGycZf93C1ud8PTLhSQYjYhGPfrOw5/3RNUQvL1yZK4ZaqzWucmvT9fjMW h24ofSN0sJyrBTInv30CzauKlIacgBtTfaMyQkoR1tch3hn57UI9w0/Ad5ywkdgFbA7PVBO12Bsi WHNpHVk1muWUYaGLYE7L4rvx1klv2uS+yQ7aJ1De9MtFy655R//GaJJlgfLvMYICXDCCAlgCAQEw OzA1MQswCQYDVQQGEwJGUjENMAsGA1UEChMEQ05SUzEXMBUGA1UEAxMOQ05SUzItU3RhbmRhcmQC AlA7MAkGBSsOAwIaBQCggfcwGAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUx DxcNMTQwMjA2MTgxNzAzWjAjBgkqhkiG9w0BCQQxFgQUhKcRb3MZtkFAooMk7Y+G3u2A8FUwSgYJ KwYBBAGCNxAEMT0wOzA1MQswCQYDVQQGEwJGUjENMAsGA1UEChMEQ05SUzEXMBUGA1UEAxMOQ05S UzItU3RhbmRhcmQCAlA7MEwGCyqGSIb3DQEJEAILMT2gOzA1MQswCQYDVQQGEwJGUjENMAsGA1UE ChMEQ05SUzEXMBUGA1UEAxMOQ05SUzItU3RhbmRhcmQCAlA7MA0GCSqGSIb3DQEBAQUABIIBAKBL /FH/SXqzPPuBC17gu7Tj0sGVIOXSiIMSXSmYECkL7Q0VliA2w/y+BWlu9TelFfNHuPN67woU/rl0 xwN4pPO6oR8glb9mRuhWXjeghcxMZU6tIzhw6PslIFqC5OHXr+FU3jMn3FIhe1+jTe8zU1uvUwl0 2tjsoL2meUNWZt6YsS6o7WaPtqQdTNGgOwoGZm4dLGtsVYd6PfP1EdE945Zn5vQDMBh7sX5ItsOX h3MWA6H2Anzu4+cF4M2DTA9q7euyppIkmYZDjvIovdK4eiBHsdSvKZbknz1zFr40kzN9aQjdYBX7 DsfEQ2dUVxLcwJh+CTeXvq0794fXCfY1FgYAAAAAAAA= --Apple-Mail=_D6A04D32-0B97-4630-B76B-5AE247E97500--