Live data from Hacker News

Tad, a tabular data viewer

tadviewer.com

61–70 of 113 posts

Re: Tad, a tabular data viewer

#61
Dies immediately when launched on Debian Jessie:

Error: /usr/lib/x86_64-linux-gnu/libstdc++.so.6: version `GLIBCXX_3.4.21' not found (required by /tmp/.org.chromium.Chromium.ibqKoR)

  $ strings /usr/lib/x86_64-linux-gnu/libstdc++.so.6 | grep 
  GLIBCXX_
  ...
  GLIBCXX_3.4.19
  GLIBCXX_3.4.20
  GLIBCXX_DEBUG_MESSAGE_LENGTH

Re: Tad, a tabular data viewer

#63

Feature Suggestions (top level comment to hold various suggestions, so upvoting can be used per-suggestion to bubble the best to the top)

Aggregate Function: Count

I've seen that COUNT is implemented for numeric values; but not for text. There's no reason to limit COUNT to numeric (unlike AVG and SUM).

Re: Tad, a tabular data viewer

#64

Feature Suggestions (top level comment to hold various suggestions, so upvoting can be used per-suggestion to bubble the best to the top)

Aggregate Function: Count Distinct

Like count, but only counts each distinct value once. Useful for judging data quality (i.e. if you have 600 items with 599 distinct values, chances are there's an invalid duplicate; if you have 1 distinct item chances are that column's not of interest; if you have a few distinct values, you have a potential pivot candidate, etc).

Re: Tad, a tabular data viewer

#65

Feature Suggestions (top level comment to hold various suggestions, so upvoting can be used per-suggestion to bubble the best to the top)

DATE support.

Help mentions INT REAL, and TEXT. Having support for dates would be useful; especially if this enables us to treat dates as multi-part values; e.g. pivot by year & month instead of by the complete value.

Re: Tad, a tabular data viewer

#67

Feature Suggestions (top level comment to hold various suggestions, so upvoting can be used per-suggestion to bubble the best to the top)

Aggregate Function: Count I've seen that COUNT is implemented for numeric values; but not for text. There's no reason to limit COUNT to numeric (unlike AVG and SUM).

Good points and great suggestions, thanks!

Re: Tad, a tabular data viewer

#68

Feature Suggestions (top level comment to hold various suggestions, so upvoting can be used per-suggestion to bubble the best to the top)

Quick Filter

i.e. Currently to add a filter you to the bottom, clicking filter, selecting a column name, selecting equals, entering a value.

Instead, right clicking on a cell and selecting "filter > equals" would apply a filter to that column for values matching the selected cell's value. Likewise "filter > contains", "filter > does not equal", "filter > greater than or equal", etc.

These filters would then be appended to the filter at the bottom, so could still be managed there; but just saves some effort when first populating.

Re: Tad, a tabular data viewer

#69

Nice, some initial remarks: - Sad to see it's an Electron app, but I don't want to start this flamewar all over again - Mid-sized CSV file opens fairly quick - If you want to build this into a full-fledged app, be prepared to handle a lot of CSV edge cases, also think about supporting AVRO, Parquet files - Regarding filtering: I can filter on CONTAINS and '=' but not on NOT-CONTAINS or ' ' I think? This is annoying t…

All great feedback, thanks! Some quick replies: - The omission of '' from the operator list was just an embarrassing mistake on my part. #facepalm #WILLFIX - Also agree that a drop-down list of checkboxes (ideally a searchable one!) with an 'in' operator for low cardinality columns would be great. But the UI for that is a bit involved, and probably also need to provide some user control over when to do this since gathering distinct values can be an expensive operation for large data sets. - Totally agree that it would be useful to provide more interesting column stats. Thanks for the suggestions and refs to other tools -- very helpful.

Re: Tad, a tabular data viewer

#70
post #49

Nice, some initial remarks: - Sad to see it's an Electron app, but I don't want to start this flamewar all over again - Mid-sized CSV file opens fairly quick - If you want to build this into a full-fledged app, be prepared to handle a lot of CSV edge cases, also think about supporting AVRO, Parquet files - Regarding filtering: I can filter on CONTAINS and '=' but not on NOT-CONTAINS or ' ' I think? This is annoying t…

> Sad to see it's an Electron app, but I don't want to start this flamewar all over again Then stop mentioning it. Just don't use anything electron and don't mention it. I will use my RStudio and VS Code.

I think it is ok to express displeasure at the state of something without just silently doing something else and hoping that the entire ecosystem catches up to you. For example, I take every opportunity (like right now, for example) to shit on node.js and npm for that very reason. There is so much evangelism on one side, it is nice to hear the opposing view points.
Post reply on HN