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",

META.json  view on Meta::CPAN

            "version" : "0.10"
         },
         {
            "class" : "Dist::Zilla::Plugin::PodnameFromFilename",
            "name" : "@Author::PERLANCAR/PodnameFromFilename",
            "version" : "0.02"
         },
         {
            "class" : "Dist::Zilla::Plugin::PERLANCAR::EnsurePrereqToSpec",
            "config" : {
               "Dist::Zilla::Role::ModuleMetadata" : {
                  "Module::Metadata" : "1.000037",
                  "version" : "0.006"
               }
            },
            "name" : "@Author::PERLANCAR/PERLANCAR::EnsurePrereqToSpec",
            "version" : "0.064"
         },
         {
            "class" : "Dist::Zilla::Plugin::PERLANCAR::MetaResources",
            "name" : "@Author::PERLANCAR/PERLANCAR::MetaResources",
            "version" : "0.043"

META.json  view on Meta::CPAN

            "version" : "0.001"
         },
         {
            "class" : "Dist::Zilla::Plugin::CheckSelfDependency",
            "config" : {
               "Dist::Zilla::Plugin::CheckSelfDependency" : {
                  "finder" : [
                     ":InstallModules"
                  ]
               },
               "Dist::Zilla::Role::ModuleMetadata" : {
                  "Module::Metadata" : "1.000037",
                  "version" : "0.006"
               }
            },
            "name" : "@Author::PERLANCAR/CheckSelfDependency",
            "version" : "0.011"
         },
         {
            "class" : "Dist::Zilla::Plugin::Git::Contributors",
            "config" : {
               "Dist::Zilla::Plugin::Git::Contributors" : {

META.json  view on Meta::CPAN

                     }
                  ],
                  "include_underscores" : 0
               },
               "Dist::Zilla::Role::MetaProvider::Provider" : {
                  "$Dist::Zilla::Role::MetaProvider::Provider::VERSION" : "2.002004",
                  "inherit_missing" : 1,
                  "inherit_version" : 1,
                  "meta_noindex" : 1
               },
               "Dist::Zilla::Role::ModuleMetadata" : {
                  "Module::Metadata" : "1.000037",
                  "version" : "0.006"
               }
            },
            "name" : "@Author::PERLANCAR/MetaProvides::Package",
            "version" : "2.004003"
         },
         {
            "class" : "Dist::Zilla::Plugin::PERLANCAR::Authority",
            "name" : "@Author::PERLANCAR/PERLANCAR::Authority",
            "version" : "0.001"

META.yml  view on Meta::CPAN

---
abstract: 'List of modules/tools for browsing table data interactively'
author:
  - 'perlancar <perlancar@cpan.org>'
build_requires:
  File::Spec: '0'
  IO::Handle: '0'
  IPC::Open3: '0'
  Test::More: '0'
configure_requires:
  ExtUtils::MakeMaker: '0'
dynamic_config: 0

META.yml  view on Meta::CPAN

      class: Dist::Zilla::Plugin::Rinci::AbstractFromMeta
      name: '@Author::PERLANCAR/Rinci::AbstractFromMeta'
      version: '0.10'
    -
      class: Dist::Zilla::Plugin::PodnameFromFilename
      name: '@Author::PERLANCAR/PodnameFromFilename'
      version: '0.02'
    -
      class: Dist::Zilla::Plugin::PERLANCAR::EnsurePrereqToSpec
      config:
        Dist::Zilla::Role::ModuleMetadata:
          Module::Metadata: '1.000037'
          version: '0.006'
      name: '@Author::PERLANCAR/PERLANCAR::EnsurePrereqToSpec'
      version: '0.064'
    -
      class: Dist::Zilla::Plugin::PERLANCAR::MetaResources
      name: '@Author::PERLANCAR/PERLANCAR::MetaResources'
      version: '0.043'
    -
      class: Dist::Zilla::Plugin::CheckChangeLog
      name: '@Author::PERLANCAR/CheckChangeLog'

META.yml  view on Meta::CPAN

    -
      class: Dist::Zilla::Plugin::CheckMetaResources
      name: '@Author::PERLANCAR/CheckMetaResources'
      version: '0.001'
    -
      class: Dist::Zilla::Plugin::CheckSelfDependency
      config:
        Dist::Zilla::Plugin::CheckSelfDependency:
          finder:
            - ':InstallModules'
        Dist::Zilla::Role::ModuleMetadata:
          Module::Metadata: '1.000037'
          version: '0.006'
      name: '@Author::PERLANCAR/CheckSelfDependency'
      version: '0.011'
    -
      class: Dist::Zilla::Plugin::Git::Contributors
      config:
        Dist::Zilla::Plugin::Git::Contributors:
          git_version: 2.25.1
          include_authors: 0
          include_releaser: 1

META.yml  view on Meta::CPAN

            -
              class: Dist::Zilla::Plugin::FinderCode
              name: '@Author::PERLANCAR/MetaProvides::Package/AUTOVIV/:InstallModulesPM'
              version: '6.028'
          include_underscores: 0
        Dist::Zilla::Role::MetaProvider::Provider:
          $Dist::Zilla::Role::MetaProvider::Provider::VERSION: '2.002004'
          inherit_missing: '1'
          inherit_version: '1'
          meta_noindex: '1'
        Dist::Zilla::Role::ModuleMetadata:
          Module::Metadata: '1.000037'
          version: '0.006'
      name: '@Author::PERLANCAR/MetaProvides::Package'
      version: '2.004003'
    -
      class: Dist::Zilla::Plugin::PERLANCAR::Authority
      name: '@Author::PERLANCAR/PERLANCAR::Authority'
      version: '0.001'
    -
      class: Dist::Zilla::Plugin::OurDate
      name: '@Author::PERLANCAR/OurDate'

Makefile.PL  view on Meta::CPAN

# This file was automatically generated by Dist::Zilla::Plugin::MakeMaker v6.028.
use strict;
use warnings;



use ExtUtils::MakeMaker;

my %WriteMakefileArgs = (
  "ABSTRACT" => "List of modules/tools for browsing table data interactively",
  "AUTHOR" => "perlancar <perlancar\@cpan.org>",
  "CONFIGURE_REQUIRES" => {
    "ExtUtils::MakeMaker" => 0
  },
  "DISTNAME" => "Acme-CPANModules-BrowsingTableInteractively",
  "LICENSE" => "perl",
  "NAME" => "Acme::CPANModules::BrowsingTableInteractively",
  "PREREQ_PM" => {
    "strict" => 0
  },

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

README  view on Meta::CPAN

    the same features like Tickit::Widget::Table with an extra one: you can
    press Enter on a row to view it as a "card" where each column will be
    displayed vertically, so you can better see a row that has many columns
    or columns with long text.

    There is currently no support beyond the most basic stuffs, so no column
    hiding, reordering, etc.

    5) less

    Don't forget the good ol' Unix pager. You can render your table data as
    an ASCII table (using modules like Text::Table::More, Text::ANSITable,
    or Text::Table::Any for more formats to choose from) then pipe the
    output to it. At least with *less* you can scroll horizontally or
    perform incremental searching (though not interactive filtering of
    rows).

    6) SQLite browser, SQLiteStudio, or other SQLite-based front-ends

    Another way to browse your table data interactively is to export it to
    SQLite database then use one of the many front-ends (desktop GUI,
    web-based, TUI, as well as CLI) to browse it. If you have your table
    data as a CSV, you can use the csv2sqlite script from App::SQLiteUtils
    to convert it to SQLite database.

    <https://sqlitebrowser.org>

    <http://sqlitestudio.pl>

    6) Microsoft Excel, LibreOffice, or other spreadsheet programs

    Yet another way to browse your table data interactively is to use a
    spreadsheet, which offers a rich way to view and manipulate data. You
    can generate a CSV from your table data; all spreadsheets support
    opening CSV files.

ACME::CPANMODULES ENTRIES
    Tickit::Widget::Table
        Author: TEAM <https://metacpan.org/author/TEAM>

    Term::TablePrint
        Author: KUERBIS <https://metacpan.org/author/KUERBIS>

    Text::Table::HTML::DataTables

lib/Acme/CPANModules/BrowsingTableInteractively.pm  view on Meta::CPAN

package Acme::CPANModules::BrowsingTableInteractively;

use strict;

our $AUTHORITY = 'cpan:PERLANCAR'; # AUTHORITY
our $DATE = '2023-06-15'; # DATE
our $DIST = 'Acme-CPANModules-BrowsingTableInteractively'; # DIST
our $VERSION = '0.009'; # VERSION

our $LIST = {
    summary => 'List of modules/tools for browsing table data interactively',
    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 <pm:Perinci::CmdLine> (<pm: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 <pm:Perinci::CmdLine> (<pm: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 <pm:Text::Table::HTML::DataTables>) when possible and then browse the
output in browser.


3) **Tickit::Widget::Table**, <pm:Tickit::Widget::Table>

This module lets you browse the table in a terminal. Using the <pm: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

lib/Acme/CPANModules/BrowsingTableInteractively.pm  view on Meta::CPAN

features like Tickit::Widget::Table with an extra one: you can press Enter on a
row to view it as a "card" where each column will be displayed vertically, so
you can better see a row that has many columns or columns with long text.

There is currently no support beyond the most basic stuffs, so no column hiding,
reordering, etc.


5) **less**

Don't forget the good ol' Unix pager. You can render your table data as an ASCII
table (using modules like <pm:Text::Table::More>, <pm:Text::ANSITable>, or
<pm:Text::Table::Any> for more formats to choose from) then pipe the output to
it. At least with *less* you can scroll horizontally or perform incremental
searching (though not interactive filtering of rows).


6) **SQLite browser**, **SQLiteStudio**, or other SQLite-based front-ends

Another way to browse your table data interactively is to export it to SQLite
database then use one of the many front-ends (desktop GUI, web-based, TUI, as
well as CLI) to browse it. If you have your table data as a CSV, you can use the
<prog:csv2sqlite> script from <pm:App::SQLiteUtils> to convert it to SQLite
database.

<https://sqlitebrowser.org>

<http://sqlitestudio.pl>


6) **Microsoft Excel**, **LibreOffice**, or other spreadsheet programs

Yet another way to browse your table data interactively is to use a spreadsheet,
which offers a rich way to view and manipulate data. You can generate a CSV from
your table data; all spreadsheets support opening CSV files.

_
    entries => [
        {
            module => 'Tickit::Widget::Table',
        },

        {
            module => 'Term::TablePrint',
        },

lib/Acme/CPANModules/BrowsingTableInteractively.pm  view on Meta::CPAN

            module => 'Text::Table::HTML::DataTables',
        },

        {
            module => 'App::SQLiteUtils',
        },
    ],
};

1;
# ABSTRACT: List of modules/tools for browsing table data interactively

__END__

=pod

=encoding UTF-8

=head1 NAME

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

=head1 VERSION

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

=head1 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) B<Visidata>, L<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 L<Perinci::CmdLine> (L<Perinci::CmdLine::Lite>, v1.918+)
has support for Visidata. You can specify command-line option C<--format=vd> to
browse the output of your CLI program in Visidata.

2) B<DataTables>, L<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 L<Perinci::CmdLine> (L<Perinci::CmdLine::Lite>, v1.918+)
also has support for DataTables. You can specify command-line option
C<--format=html+datatables> to output your CLI program's result as HTML table
(using L<Text::Table::HTML::DataTables>) when possible and then browse the
output in browser.

3) B<Tickit::Widget::Table>, L<Tickit::Widget::Table>

This module lets you browse the table in a terminal. Using the L<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 since 2016.

lib/Acme/CPANModules/BrowsingTableInteractively.pm  view on Meta::CPAN

This module lets you browse the table in a terminal. Provides roughly the same
features like Tickit::Widget::Table with an extra one: you can press Enter on a
row to view it as a "card" where each column will be displayed vertically, so
you can better see a row that has many columns or columns with long text.

There is currently no support beyond the most basic stuffs, so no column hiding,
reordering, etc.

5) B<less>

Don't forget the good ol' Unix pager. You can render your table data as an ASCII
table (using modules like L<Text::Table::More>, L<Text::ANSITable>, or
L<Text::Table::Any> for more formats to choose from) then pipe the output to
it. At least with I<less> you can scroll horizontally or perform incremental
searching (though not interactive filtering of rows).

6) B<SQLite browser>, B<SQLiteStudio>, or other SQLite-based front-ends

Another way to browse your table data interactively is to export it to SQLite
database then use one of the many front-ends (desktop GUI, web-based, TUI, as
well as CLI) to browse it. If you have your table data as a CSV, you can use the
L<csv2sqlite> script from L<App::SQLiteUtils> to convert it to SQLite
database.

L<https://sqlitebrowser.org>

L<http://sqlitestudio.pl>

6) B<Microsoft Excel>, B<LibreOffice>, or other spreadsheet programs

Yet another way to browse your table data interactively is to use a spreadsheet,
which offers a rich way to view and manipulate data. You can generate a CSV from
your table data; all spreadsheets support opening CSV files.

=head1 ACME::CPANMODULES ENTRIES

=over

=item L<Tickit::Widget::Table>

Author: L<TEAM|https://metacpan.org/author/TEAM>

=item L<Term::TablePrint>



( run in 0.424 second using v1.01-cache-2.11-cpan-8d75d55dd25 )