Acme-CPANModules-BrowsingTableInteractively

 view release on metacpan or  search on metacpan

Changes  view on Meta::CPAN

0.007   2022-04-15  Released-By: PERLANCAR; Urgency: low

        - No functional changes.

        - Fix some formatting.


0.006   2022-04-15  Released-By: PERLANCAR; Urgency: medium

        - Add "entry": Visidata.


0.005   2022-03-18  Released-By: PERLANCAR; Urgency: low

        - No functional changes.

        - Tweak Abstract (add 'List of ...') to follow convention.


0.004   2021-05-01  Released-By: PERLANCAR; Urgency: medium

META.json  view on Meta::CPAN

{
   "abstract" : "List of modules/tools for browsing table data interactively",
   "author" : [
      "perlancar <perlancar@cpan.org>"
   ],
   "dynamic_config" : 0,
   "generated_by" : "Dist::Zilla version 6.028, CPAN::Meta::Converter version 2.150010",
   "license" : [
      "perl_5"
   ],
   "meta-spec" : {
      "url" : "http://search.cpan.org/perldoc?CPAN::Meta::Spec",

README  view on Meta::CPAN

NAME
    Acme::CPANModules::BrowsingTableInteractively - List of modules/tools
    for browsing table data interactively

VERSION
    This document describes version 0.009 of
    Acme::CPANModules::BrowsingTableInteractively (from Perl distribution
    Acme-CPANModules-BrowsingTableInteractively), released on 2023-06-15.

DESCRIPTION
    This list reviews what tools are available on CPAN and in general to
    browse table data interactively.

    Let me say first that the best tools are not Perl-based since sadly Perl
    is not a favorite choice for writing tools these days. That said, Perl
    is still a great glue to help make those tools work together better for
    you.

    1) Visidata, <https://www.visidata.org>

    This is currently my favorite. It's terminal-based, written in Python,
    and has more features than any other tools currently written in Perl, by
    far. vd has support for many formats, including CSV, TSV, Excel, JSON,
    and SQLite. It makes it particularly easy to create summary for your
    table like histogram or sum/average/max/min/etc, or add new columns, or
    edit some cells. It also has visualization features like XY-plots.

    It has the concept of "sheets" like sheets in a spreadsheet workbook so
    anytime you filter rows/columns or create summary or do some other
    derivation from your data, you create a new sheet which you can edit,
    save, and destroy later as needed and go back to your original table. It
    even presents settings and metadata as sheets so you can edit them as a
    normal sheet.

    It has plugins, and I guess it should be simple enough to create a
    plugin so you can filter rows or add columns using Perl expression
    instead of the default Python, if needed.

    My CLI framework Perinci::CmdLine (Perinci::CmdLine::Lite, v1.918+) has
    support for Visidata. You can specify command-line option "--format=vd"
    to browse the output of your CLI program in Visidata.

    2) DataTables, <https://datatables.net>

    DataTables is a JavaScript (jQuery-based) library to add controls to
    your HTML table so you can filter rows incrementally, sort rows, reorder
    columns, and so on. It also has plugins to do more customized stuffs. I
    still prefer Visidata most of the time because I am comfortable living
    in the terminal, but I particularly love the incremental searching
    feature that comes built-in with DataTables.

    My CLI framework Perinci::CmdLine (Perinci::CmdLine::Lite, v1.918+) also
    has support for DataTables. You can specify command-line option
    "--format=html+datatables" to output your CLI program's result as HTML
    table (using Text::Table::HTML::DataTables) when possible and then
    browse the output in browser.

    3) Tickit::Widget::Table, Tickit::Widget::Table

    This module lets you browse the table in a terminal. Using the Tickit
    library, the advantages it's supposed to have is mouse support. It's
    still very basic: you either have to specify each column width manually
    or the width of all columns will be the same. There's no horizontal
    scrolling support or a way to see long text in a column. Not updated

 view all matches for this distribution
 view release on metacpan -  search on metacpan