Date: Thu, 5 Jan 2023 13:03:01 +0300 From: Mehmet Erol Sanliturk <m.e.sanliturk@gmail.com> To: Nuno Teixeira <eduardo@freebsd.org> Cc: Yuri <yuri@freebsd.org>, ports <freebsd-ports@freebsd.org> Subject: Re: PortsDB: a program that imports the ports tree into an SQLite database Message-ID: <CAOgwaMstuGgCtZbRFnjJXRSOHEcZ-BA6bUz5K94iX-b5_RXMFg@mail.gmail.com> In-Reply-To: <CAFDf7UKk0hfyXEZYY965-qw%2B_5_bNpnAt%2Bdwe0Ejbp_sSqbEoQ@mail.gmail.com> References: <f84e138d-46f7-9353-112f-492b1460c3c3@tsoft.com> <CAFDf7UKk0hfyXEZYY965-qw%2B_5_bNpnAt%2Bdwe0Ejbp_sSqbEoQ@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
--000000000000375a6b05f1816a37
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
On Thu, Jan 5, 2023 at 12:50 PM Nuno Teixeira <eduardo@freebsd.org> 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 <db.sqlite> <file.sql> [{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 <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-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
<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:tahoma,sans-serif;font-size:large"><br></div></div><br><div class=
=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Thu, Jan 5, 2023 =
at 12:50 PM Nuno Teixeira <<a href=3D"mailto:eduardo@freebsd.org">eduard=
o@freebsd.org</a>> wrote:<br></div><blockquote class=3D"gmail_quote" sty=
le=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);paddi=
ng-left:1ex"><div dir=3D"ltr"><div>Hello Yuri!</div><div><br></div><div>/et=
c/make.conf:<br></div><div>PORTSDIR=3D/work/freebsd/ports/main</div><div><b=
r></div><div>`portsdb-import`:<br></div><div>error: the PORTSDIR environmen=
t variable should point to a valid ports tree<br>Usage: /usr/local/bin/port=
sdb-import <db.sqlite> <file.sql> [{sync|async}]</div><div><br>=
</div><div>Any clues?</div><div><br></div><div>I don't work with SQL fo=
r about 20 years, any simple commands to start with as an example?</div><di=
v><br></div><div>I usaually use grep and portgrep but this tools promises t=
hat we can do deep search within ports.</div><div>Thats what I looking for!=
</div><div><br></div><div>Cheers!<br></div></div><br></blockquote><div><br>=
</div><div><br></div><div><br></div><div><a href=3D"https://www.google.com/=
search?q=3Dfree+open+books+about+sqlite+database&sxsrf=3DALiCzsZv1AJgR5=
UkUadj4f--jQ9kh0gXQg%3A1672912760855&source=3Dhp&ei=3DeJ-2Y6LUMdaOx=
c8P4JGcYA&iflsig=3DAJiK0e8AAAAAY7atiNKf0anco-A8BtH3TLESAj9VyBwU&oq=
=3Dfree+open+books+about+sqlite&gs_lcp=3DCgdnd3Mtd2l6EAEYADIFCCEQoAEyBQ=
ghEKABMgUIIRCgAToECCMQJzoNCC4QxwEQ0QMQ1AIQQzoECAAQQzoFCAAQgAQ6BQguEIAEOggIL=
hCABBDUAjoLCC4QgAQQxwEQ0QM6CAgAEIAEEMsBOgoIABCABBAKEMsBOgYIABAWEB46CggAEBYQ=
HhAPEAo6CAghEBYQHhAdOgsIIRAWEB4Q8QQQHToECCEQFToHCCEQoAEQClAAWMhgYIKWAWgAcAB=
4AIABrQGIAd0bkgEEMC4yOJgBAKABAQ&sclient=3Dgws-wiz">https://www.google.c=
om/search?q=3Dfree+open+books+about+sqlite+database&sxsrf=3DALiCzsZv1AJ=
gR5UkUadj4f--jQ9kh0gXQg%3A1672912760855&source=3Dhp&ei=3DeJ-2Y6LUMd=
aOxc8P4JGcYA&iflsig=3DAJiK0e8AAAAAY7atiNKf0anco-A8BtH3TLESAj9VyBwU&=
oq=3Dfree+open+books+about+sqlite&gs_lcp=3DCgdnd3Mtd2l6EAEYADIFCCEQoAEy=
BQghEKABMgUIIRCgAToECCMQJzoNCC4QxwEQ0QMQ1AIQQzoECAAQQzoFCAAQgAQ6BQguEIAEOgg=
ILhCABBDUAjoLCC4QgAQQxwEQ0QM6CAgAEIAEEMsBOgoIABCABBAKEMsBOgYIABAWEB46CggAEB=
YQHhAPEAo6CAghEBYQHhAdOgsIIRAWEB4Q8QQQHToECCEQFToHCCEQoAEQClAAWMhgYIKWAWgAc=
AB4AIABrQGIAd0bkgEEMC4yOJgBAKABAQ&sclient=3Dgws-wiz</a></div><div><br><=
/div><div>free open books about sqlite database</div><div><br></div><div><b=
r></div><div><div style=3D"font-family:tahoma,sans-serif;font-size:large" c=
lass=3D"gmail_default">With my best wishes .</div><br></div><div><br></div>=
<div><br></div><div><div style=3D"font-family:tahoma,sans-serif;font-size:l=
arge" class=3D"gmail_default">Mehmet Erol Sanliturk</div><div style=3D"font=
-family:tahoma,sans-serif;font-size:large" class=3D"gmail_default"><br></di=
v><div style=3D"font-family:tahoma,sans-serif;font-size:large" class=3D"gma=
il_default"></div><br></div><div><br></div><div><br></div><div>=C2=A0</div>=
<blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-=
left:1px solid rgb(204,204,204);padding-left:1ex"><div class=3D"gmail_quote=
"><div dir=3D"ltr" class=3D"gmail_attr">Yuri <<a href=3D"mailto:yuri@fre=
ebsd.org" target=3D"_blank">yuri@freebsd.org</a>> escreveu no dia quarta=
, 4/01/2023 =C3=A0(s) 22:31:<br></div><blockquote class=3D"gmail_quote" sty=
le=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);paddi=
ng-left:1ex">Hi,<br>
<br>
<br>
I developed the PortsDB project that imports FreeBSD ports into an <br>
SQLite database: <a href=3D"https://github.com/yurivict/freebsd-portsdb" re=
l=3D"noreferrer" target=3D"_blank">https://github.com/yurivict/freebsd-port=
sdb</a><br>
The port is ports-mgmt/portsdb.<br>
The database can be fully rebuilt in ~20 minutes, after which in can be <br=
>
quickly (in seconds) updated with new commits.<br>
The database is currently updated hourly: <br>
<a href=3D"https://people.freebsd.org/~yuri/ports.sqlite" rel=3D"noreferrer=
" target=3D"_blank">https://people.freebsd.org/~yuri/ports.sqlite</a><br>;
<br>
<br>
PortsDB can be used to query ports using SQL, as a relational database.<br>
External services like Repology, FreshPorts, Portscout and similar can <br>
use PortsDB to access information in the ports tree.<br>
Users can, for example, easily find their broken ports, or port <br>
duplicates, or all ports that they maintain that use gmake, among many <br>
other possible queries.<br>
Such queries aren't easy to perform grepping the ports tree.<br>
Cross-DB queries are also easy to do, combining PortsDB and <br>
/var/db/pkg/repo-FreeBSD.sqlite and /var/db/pkg/local.sqlite.<br>
<br>
All that needs to be done to run PortsDB is ./import.sh and then ./update.s=
h<br>
<br>
<br>
<br>
Regards,<br>
Yuri<br>
<br>
<br>
</blockquote></div><br clear=3D"all"><br>-- <br><div dir=3D"ltr"><div dir=
=3D"ltr"><span style=3D"color:rgb(102,102,102)">Nuno Teixeira<br>FreeBSD Co=
mmitter (ports)</span></div></div>
</blockquote></div></div>
--000000000000375a6b05f1816a37--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CAOgwaMstuGgCtZbRFnjJXRSOHEcZ-BA6bUz5K94iX-b5_RXMFg>