A cat(1) equivalent for viewing sqlite database.
-
cargo: Install cargo from Here!
$ cargo install dbcat
NetBSD (Official repositories)
pkgin install dbcat
or, if you prefer to build it from source
cd /usr/pkgsrc/textproc/dbcat
make install
Read the database simply by running
$ dbcat <filename>.db
Change the format of the output by choice or automatically if the output is a tty or not.
Access individual tables by running
$ dbcat [-t <table>] <filename>.db
Pass a filter query to filter the tables by running
$ dbcat [-t <table>] -f <query> <filename>.db
Use dbcat --help
to see the help.
Your contribution is highly appreciated. Do not hesitate to open an issue or a pull request. Note that any contribution submitted for inclusion in the project will be licensed according to the terms given in LICENSE.