Date: Thu, 6 Feb 2014 19:17:02 +0100 From: Michel Talon <talon@lpthe.jussieu.fr> To: "Julian H. Stacey" <jhs@berklix.com> Cc: freebsd-ports@freebsd.org Subject: Re: [FreeBSD-Ports-Announce] Time to bid farewell to the old pkg_ tools Message-ID: <01A7684D-EBAF-4CC2-95DD-0FED284DE878@lpthe.jussieu.fr> In-Reply-To: <201402061228.s16CRo02023097@fire.js.berklix.net> References: <201402061228.s16CRo02023097@fire.js.berklix.net>
next in thread | previous in thread | raw e-mail | index | archive | help
--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--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?01A7684D-EBAF-4CC2-95DD-0FED284DE878>