[FreeBSD-Ports-Announce] Time to bid farewell to the old pkg_ tools

Nikola Pavlović nzp at riseup.net
Sat Feb 8 22:03:56 UTC 2014

On 08/02/14 14:04, Julian H. Stacey wrote:
> Michel Talon wrote:
>> So
>> how to interact with local.sqlite?
> Thanks Michel,
> Noted.

Further, if you really want to debug and inspect with text tools you can
simply do

$ sqlite3 local.sqlite .dump > dump.sql


$ sqlite3 -csv local.sqlite .dump > dump.csv

From there, I'm sure an impressive pipeline to do just about
anything you want can be constructed, if that's what you need.

You can also do any kind of additional SQL in that last parameter (.dump
is just an sqlite specific SQL meta command) with semicolon separated

Contestants have been briefed on some questions before the show.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 730 bytes
Desc: OpenPGP digital signature
URL: <http://lists.freebsd.org/pipermail/freebsd-ports/attachments/20140208/c46b3d68/attachment.sig>

More information about the freebsd-ports mailing list