Skip site navigation (1)Skip section navigation (2)
Date:      Sat, 08 Feb 2014 23:03:46 +0100
From:      =?UTF-8?B?Tmlrb2xhIFBhdmxvdmnEhw==?= <nzp@riseup.net>
To:        freebsd-ports@freebsd.org
Subject:   Re: [FreeBSD-Ports-Announce] Time to bid farewell to the old pkg_ tools
Message-ID:  <52F6A9C2.3060009@riseup.net>
In-Reply-To: <201402081304.s18D4HDb019675@fire.js.berklix.net>
References:  <201402081304.s18D4HDb019675@fire.js.berklix.net>

next in thread | previous in thread | raw e-mail | index | archive | help
This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--rXjHp0W65jiVXQWmuPXP7jO1BWeh6bQbM
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

On 08/02/14 14:04, Julian H. Stacey wrote:
> Michel Talon wrote:
>> So
>> how to interact with local.sqlite?
>=20
> 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

or

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

=46rom 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
statements.

--=20
Contestants have been briefed on some questions before the show.



--rXjHp0W65jiVXQWmuPXP7jO1BWeh6bQbM
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.14 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQGcBAEBCAAGBQJS9qnFAAoJECVxJsPurgHoijIMAJQH6lDi+BkULMSCDD2Qo6SI
9ci8fnmTZj8GwGzgvnhiWVYil5BmRVU/4f94iwQafbW37ETd2Q2Qnq8Ygp3k+3Gu
yzMBSFE9LzoEhcHO86ZM57O0uW+kk77GKM8Wh88VAFmRxU+A6LJkoj4Z1aL0vYum
M9StKUMrfudJWtXnN4KrRSaU1KF3D3J00BGnHO6lY5xm+8Vk+mkjvzqs7msaitvA
ufRE2RyQNajOkaStZ+6STcQAnvGEAjlcft1FUlFDK24vNIHlqSy8AmPs5gSO3w3E
G81oy/+3FblDsmvRZuvN4TwQVB/GcU5y76Sw9syUj+42cHpapJ7iOG7yjHt1h465
uU4LHgNLVNb8yzuZCbBZMZZbvCzqi2tVfUmcvE8HRL7U4ieqei4kHEqmsSzth5Nr
YgtwDyeNzRt8ZxM/Awp9p82r38OEwqH4DJEvjiyIo72cxGjiOzIWG/4lZH48RVeK
KsRQSEfvBO3Pftvoc6ZUnCrYc1MlCKxwcb9MuhpvYg==
=eZWN
-----END PGP SIGNATURE-----

--rXjHp0W65jiVXQWmuPXP7jO1BWeh6bQbM--



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?52F6A9C2.3060009>