search

DevToys-app / DevToys

A Swiss Army knife for developers.
https://devtoys.app/
MIT License
26.94k stars 1.45k forks source link

CSV Query #655

Closed Manuel-Steinberg closed 2 months ago

Manuel-Steinberg commented 2 years ago

What's the Problem?

Working with CSV files is easy and fast, but bulk manipulations or more in depth queries can be tricky. Mostly I am using notepad++ with CsvQuery extension since it is way faster than Excel/Calc.

Solution/Idea

  1. Load a CSV file.
  2. Set optional read params, e.g. seperator.
  3. Write SQL statements against CSV file.
  4. Export to another CSV file.

Alternatives

CsvQuery

Priorities

Capability Priority
This proposal will allow developers to set custom read param Should
This proposal will allow end users to query a CSV with SQL Must
This proposal will allow end users to export query result to CSV again Must

DevToys Version

No response

Comments

No response

Manuel-Steinberg commented 2 years ago

image Screenshot of how this looks like with notepad++ and CsvQuery extension.

joshpinto6 commented 2 years ago

A feature like this would definitely be really great!

Christian-Oleson commented 2 years ago

Just as a general thought, this may be a more extensive feature to implement than some of the others since we have to write a way to query the data dynamically, since we don't have the model until we load the CSV and then have to allow folks to query on it (should use ANSI SQL).

jamescurran commented 2 years ago

I wonder if you could fork and adapt CsvQuery to work within DevToys.
Alternately, we could reference the SQLite nuget package and build on that (having SQLite in the DevToys ecosystem may also be useful for future tools)

bvtvusn commented 7 months ago

I second this!

veler commented 2 months ago

Hi, This is a good idea for an extension, but I don't think it fits DevToys' default tools. Thanks