Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Tad, a tabular data viewer

tadviewer.com

Post reply on HN
Print view View original

51–60 of 113 posts

Re: Tad, a tabular data viewer

#51

Post by dgudkov »

Macuyiko wrote: post #36

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…

I believe my http://easymorph.com would also count as competition. It loads CSV files and queries databases, filters, pivots/unpivots, cleanses, aggregates, merges. Free edition. Windows only (yeah, Mac owners, I know).

Re: Tad, a tabular data viewer

#52

Post by baldfat »

MrMattWright wrote: post #28

This is absolutely terrific! I often work with csv or tsv and large data, and I just want to quickly look at it without loading excel or exporting to google sheets. https://atom.io/packages/tablr Tablr for Atom is good too. One feature request. I very often get data in JSON format (then convert to csv), it would be amazing to also support JSON. Thanks for sharing.

OpenRefine http://openrefine.org/ for years has been my go to tool when looking at csv or tsv. I really love this project.

> OpenRefine (formerly Google Refine) is a powerful tool for working with messy data: cleaning it; transforming it from one format into another; and extending it with web services and external data.

Re: Tad, a tabular data viewer

#54

Post by _acme »

Macuyiko wrote: post #36

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…

Why is it sad that it's an Electron app? Can you articulate a reason why that's an automatic negative? Would you rather software, such as this, not exist than be Electron-based?

Re: Tad, a tabular data viewer

#56

Post by nerdponx »

TheAceOfHearts wrote: post #45

Related to this, if you're looking for a CLI tool for handling CSVs, xsv [0] is looking promising. Based on prior experiences with CSV, one of the big problems I've seen has been figuring out what text encoding is being used. This problem appears to be more prominent with people outside of the US. It looks like Tad is using fast-csv, which I don't think will properly handle different file encodings. Life would be so…

Csvkit [0] has been my go-to for a while now. I never heard of XSV before, but I will try just about anything with BurntSushi's name on it. Ripgrep is an amazing tool.

[0]: https://github.com/wireservice/csvkit

Re: Tad, a tabular data viewer

#58

Post by nerdponx »

lumost wrote: post #53

One area to consider growing this, existing SQL clients/viewers are pretty awful. It would be awesome if I could directly connect to a DB

If you use MySQL, you should definitely check out Sequel Pro. It's very polished and very usable.

Re: Tad, a tabular data viewer

#59

Post by johnlbevan2 »

misterdata wrote: post #46

Just noticed the installer changes the file association for CSV's so they all open with Tad, without asking me first. Please do not do this. Otherwise, nice app. How does it scale to larger CSV files? I have been working on something similar ( https://warp.one ) for Mac, which streams CSV files (apparently you use a SQLite database behind the scenes as cache?)

Upvote for "don't change default file handler without asking".

Re: Tad, a tabular data viewer

#60

Post by jpttsn »

_acme wrote: post #54
Macuyiko wrote: post #36

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…

Why is it sad that it's an Electron app? Can you articulate a reason why that's an automatic negative? Would you rather software, such as this, not exist than be Electron-based?

Not that we'd want to start a flame war or anything.
Post reply on HN