From nobody Thu Jan 5 10:03:01 2023 X-Original-To: freebsd-ports@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 4NnhrF5F3Xz2p3M7 for ; Thu, 5 Jan 2023 10:03:41 +0000 (UTC) (envelope-from m.e.sanliturk@gmail.com) Received: from mail-oi1-x22c.google.com (mail-oi1-x22c.google.com [IPv6:2607:f8b0:4864:20::22c]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (2048 bits) client-digest SHA256) (Client CN "smtp.gmail.com", Issuer "GTS CA 1D4" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4NnhrF2lm2z3GsY; Thu, 5 Jan 2023 10:03:41 +0000 (UTC) (envelope-from m.e.sanliturk@gmail.com) Authentication-Results: mx1.freebsd.org; none Received: by mail-oi1-x22c.google.com with SMTP id h185so9099972oif.5; Thu, 05 Jan 2023 02:03:41 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=Ep5RL0NmP/lJcEm7hP8iVzGKG1RNEm/XrjrXeLUT89E=; b=CwuZ7J/I/LDC5OFMUy7LSVKRgnd5OUNE9gASNyJa2Z0dnj/pXgedckdIblyt6AlB8e OHTNN5fZiR/6MfYlI1jD1UDoEO/Fe5ww75ugg79xu/7ixUevXs0e/W2r0AKfNXZgLMgr afRG1hCAkTMm3bIhZ1CWfPqSFiPGy7OXHb1vSR4khDDsz/hRF2t3XHna36WMAaCH6ms/ okXMwjtkmhi+Cgf2mkX7PbCAv4wvgUvt0Ba25ngrK8jop4/b/clXqT0Vshit8/AWD3E+ 7uhu8KcvS8jQ4gqmYvYR/um46OCJQBa1TNSyoKv0pGffN2h1Uu8zn6Egy+wBnfE1UVyk ovKA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=Ep5RL0NmP/lJcEm7hP8iVzGKG1RNEm/XrjrXeLUT89E=; b=CVyjLlfhdpR+/2F5HahoKQP84EtO3fNIfO9iqErOKTaOc6h67qTavDS3sHHr/adien tpUVhsRC9kpknhKqmZ77xXP4LU3nfVPpqyN5P530hMZQqHHbEMR30hKtmBJlPEZCInWb EQWOgEX8Ylc+2ByTUeL3Kx3zYqNSbtuwKSHSnCoLluuclLKKQg16r45r9dGsI4Rwkqxx a4ijCcpJPFZyn9x5t/q2fSN3UaxD7Dj7DPWWFOIm00tEmpzleI1Z1mHDa1TQUJqJvR/p ZzKw4YirpUoC8dwhlz8Q7q4d7d3UftNkvO81yodNT4lBDsgHQC5Lh4GUTbGro5KZaF41 Catw== X-Gm-Message-State: AFqh2krw4+ezkVHX5NB6TcyEc1hYCA4zIFmZXPvVgQ4J1fB/Y7nZj01E /sbxshIUQCIi35xFpStLEMpOybAVYMluFf4U7V/kxJyQH6rSVQ== X-Google-Smtp-Source: AMrXdXvBR4pXroF2qOSZ/NW9qAusHodWj8cmbA6LR0nn4PXr8A4jwokQPLQM7zSZmc4aHfwHKoSzD8c7n56NydLRwwY= X-Received: by 2002:a05:6808:3a3:b0:35a:e725:fb25 with SMTP id n3-20020a05680803a300b0035ae725fb25mr2210189oie.193.1672913018639; Thu, 05 Jan 2023 02:03:38 -0800 (PST) List-Id: Porting software to FreeBSD List-Archive: https://lists.freebsd.org/archives/freebsd-ports List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-ports@freebsd.org X-BeenThere: freebsd-ports@freebsd.org MIME-Version: 1.0 References: In-Reply-To: From: Mehmet Erol Sanliturk Date: Thu, 5 Jan 2023 13:03:01 +0300 Message-ID: Subject: Re: PortsDB: a program that imports the ports tree into an SQLite database To: Nuno Teixeira Cc: Yuri , ports Content-Type: multipart/alternative; boundary="000000000000375a6b05f1816a37" X-Rspamd-Queue-Id: 4NnhrF2lm2z3GsY X-Spamd-Bar: ---- X-Spamd-Result: default: False [-4.00 / 15.00]; REPLY(-4.00)[]; ASN(0.00)[asn:15169, ipnet:2607:f8b0::/32, country:US]; TAGGED_FROM(0.00)[] X-Rspamd-Pre-Result: action=no action; module=replies; Message is reply to one we originated X-ThisMailContainsUnwantedMimeParts: N --000000000000375a6b05f1816a37 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thu, Jan 5, 2023 at 12:50 PM Nuno Teixeira wrote: > Hello Yuri! > > /etc/make.conf: > PORTSDIR=3D/work/freebsd/ports/main > > `portsdb-import`: > error: the PORTSDIR environment variable should point to a valid ports tr= ee > Usage: /usr/local/bin/portsdb-import [{sync|async}= ] > > Any clues? > > I don't work with SQL for about 20 years, any simple commands to start > with as an example? > > I usaually use grep and portgrep but this tools promises that we can do > deep search within ports. > Thats what I looking for! > > Cheers! > > https://www.google.com/search?q=3Dfree+open+books+about+sqlite+database&sxs= rf=3DALiCzsZv1AJgR5UkUadj4f--jQ9kh0gXQg%3A1672912760855&source=3Dhp&ei=3DeJ= -2Y6LUMdaOxc8P4JGcYA&iflsig=3DAJiK0e8AAAAAY7atiNKf0anco-A8BtH3TLESAj9VyBwU&= oq=3Dfree+open+books+about+sqlite&gs_lcp=3DCgdnd3Mtd2l6EAEYADIFCCEQoAEyBQgh= EKABMgUIIRCgAToECCMQJzoNCC4QxwEQ0QMQ1AIQQzoECAAQQzoFCAAQgAQ6BQguEIAEOggILhC= ABBDUAjoLCC4QgAQQxwEQ0QM6CAgAEIAEEMsBOgoIABCABBAKEMsBOgYIABAWEB46CggAEBYQHh= APEAo6CAghEBYQHhAdOgsIIRAWEB4Q8QQQHToECCEQFToHCCEQoAEQClAAWMhgYIKWAWgAcAB4A= IABrQGIAd0bkgEEMC4yOJgBAKABAQ&sclient=3Dgws-wiz free open books about sqlite database With my best wishes . Mehmet Erol Sanliturk > Yuri escreveu no dia quarta, 4/01/2023 =C3=A0(s) 22:31= : > >> Hi, >> >> >> I developed the PortsDB project that imports FreeBSD ports into an >> SQLite database: https://github.com/yurivict/freebsd-portsdb >> The port is ports-mgmt/portsdb. >> The database can be fully rebuilt in ~20 minutes, after which in can be >> quickly (in seconds) updated with new commits. >> The database is currently updated hourly: >> https://people.freebsd.org/~yuri/ports.sqlite >> >> >> PortsDB can be used to query ports using SQL, as a relational database. >> External services like Repology, FreshPorts, Portscout and similar can >> use PortsDB to access information in the ports tree. >> Users can, for example, easily find their broken ports, or port >> duplicates, or all ports that they maintain that use gmake, among many >> other possible queries. >> Such queries aren't easy to perform grepping the ports tree. >> Cross-DB queries are also easy to do, combining PortsDB and >> /var/db/pkg/repo-FreeBSD.sqlite and /var/db/pkg/local.sqlite. >> >> All that needs to be done to run PortsDB is ./import.sh and then >> ./update.sh >> >> >> >> Regards, >> Yuri >> >> >> > > -- > Nuno Teixeira > FreeBSD Committer (ports) > --000000000000375a6b05f1816a37 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


On Thu, Jan 5, 2023 = at 12:50 PM Nuno Teixeira <eduard= o@freebsd.org> wrote:
Hello Yuri!

/et= c/make.conf:
PORTSDIR=3D/work/freebsd/ports/main
`portsdb-import`:
error: the PORTSDIR environmen= t variable should point to a valid ports tree
Usage: /usr/local/bin/port= sdb-import <db.sqlite> <file.sql> [{sync|async}]

=
Any clues?

I don't work with SQL fo= r about 20 years, any simple commands to start with as an example?

I usaually use grep and portgrep but this tools promises t= hat we can do deep search within ports.
Thats what I looking for!=

Cheers!


=



<= /div>
free open books about sqlite database

With my best wishes .


=

Mehmet Erol Sanliturk




=C2=A0
=
Yuri <yuri@freebsd.org> escreveu no dia quarta= , 4/01/2023 =C3=A0(s) 22:31:
Hi,


I developed the PortsDB project that imports FreeBSD ports into an
SQLite database: https://github.com/yurivict/freebsd-port= sdb
The port is ports-mgmt/portsdb.
The database can be fully rebuilt in ~20 minutes, after which in can be quickly (in seconds) updated with new commits.
The database is currently updated hourly:
https://people.freebsd.org/~yuri/ports.sqlite


PortsDB can be used to query ports using SQL, as a relational database.
External services like Repology, FreshPorts, Portscout and similar can
use PortsDB to access information in the ports tree.
Users can, for example, easily find their broken ports, or port
duplicates, or all ports that they maintain that use gmake, among many
other possible queries.
Such queries aren't easy to perform grepping the ports tree.
Cross-DB queries are also easy to do, combining PortsDB and
/var/db/pkg/repo-FreeBSD.sqlite and /var/db/pkg/local.sqlite.

All that needs to be done to run PortsDB is ./import.sh and then ./update.s= h



Regards,
Yuri




--
Nuno Teixeira
FreeBSD Co= mmitter (ports)
--000000000000375a6b05f1816a37--