#sqlite #executable #tool #command-line-tool #cli

app dbcat

A *cat(1)* equivalent for viewing sqlite database

6 releases

0.1.5 Feb 11, 2022
0.1.4 Feb 9, 2022

#2649 in Database interfaces

MIT license

1MB
175 lines

crate

DBcat

Crates.io License

A cat(1) equivalent for viewing sqlite database.

Installation

  • 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

Usage

Read the database simply by running

$ dbcat <filename>.db

Basic Usage


Change the format of the output by choice or automatically if the output is a tty or not.

Atty Usage


Access individual tables by running

$ dbcat [-t <table>] <filename>.db

Tables Access

Pass a filter query to filter the tables by running

$ dbcat [-t <table>] -f <query> <filename>.db

Filter Command

Help

Use dbcat --help to see the help.

Contribution

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.

Dependencies

~5–13MB
~144K SLoC