4 ms·

Looks like it can save to sqlite? Seems like a very good companion in that case. I often analyze csv files in sqlite but importing data to it can sometimes be a

by mongol 6y ago

Looks like it can save to sqlite? Seems like a very good companion in that case. I often analyze csv files in sqlite but importing data to it can sometimes be a bit of work. If I can use VisiData as an intermediary step, it seems very useful. Also looks powerful in it's own right.

asamarin 6y ago
Not sure about saving but, more importantly for me, it can read sqlite DBs, which has been a godsend whenever I need to take a quick glance at some random DB just to see what kind of tables it holds and what does the data look like. I know my SELECTs but I can't, for the life of me, remember what are the commands to check schemas and DB metadata on sqlite ("Was it .describe? Maybe .schema? Or perhaps \t? Gah, let's check the help once again..."), so knowing that visidata gets me there much faster feels good. > Also looks powerful in it's own right If you aren't convinced of that yet, I'd simply suggest to take a look at this lightning demo (~5 mins): https://www.youtube.com/watch?v=N1CBDTgGtOU https://www.youtube.com/watch?v=N1CBDTgGtOU
gregsadetsky 6y ago
I just confirmed while testing vd, it does save to sqlite (select cols/rows, ctrl-s to save, name your file something.sqlite, done!) That's really awesome. I might write a plugin [0] to load logged FIX [1] messages (an ascii-based, industry standard format for communicating financial transactions) [0] https://jsvine.github.io/intro-to-visidata/advanced/extending-visidata/ https://jsvine.github.io/intro-to-visidata/advanced/extendin... [1] https://en.wikipedia.org/wiki/Financial_Information_eXchange https://en.wikipedia.org/wiki/Financial_Information_eXchange
- rabidrat 6y ago
  Hey, VisiData author here! If you do want to make a FIX loader (or any plugin), you can come chat with us on Freenode #visidata and we'd love to help. A straightforward row-based file format should be quite straightforward to make a loader for!
  - gregsadetsky 6y ago
    Thanks a lot! I look forward to that. Congrats on such a great tool

by mongol 6y ago

asamarin 6y ago

Not sure about saving but, more importantly for me, it can read sqlite DBs, which has been a godsend whenever I need to take a quick glance at some random DB just to see what kind of tables it holds and what does the data look like. I know my SELECTs but I can't, for the life of me, remember what are the commands to check schemas and DB metadata on sqlite ("Was it .describe? Maybe .schema? Or perhaps \t? Gah, let's check the help once again..."), so knowing that visidata gets me there much faster feels good. > Also looks powerful in it's own right If you aren't convinced of that yet, I'd simply suggest to take a look at this lightning demo (~5 mins): https://www.youtube.com/watch?v=N1CBDTgGtOU https://www.youtube.com/watch?v=N1CBDTgGtOU

gregsadetsky 6y ago

I just confirmed while testing vd, it does save to sqlite (select cols/rows, ctrl-s to save, name your file something.sqlite, done!) That's really awesome. I might write a plugin [0] to load logged FIX [1] messages (an ascii-based, industry standard format for communicating financial transactions) [0] https://jsvine.github.io/intro-to-visidata/advanced/extending-visidata/ https://jsvine.github.io/intro-to-visidata/advanced/extendin... [1] https://en.wikipedia.org/wiki/Financial_Information_eXchange https://en.wikipedia.org/wiki/Financial_Information_eXchange

rabidrat 6y ago
Hey, VisiData author here! If you do want to make a FIX loader (or any plugin), you can come chat with us on Freenode #visidata and we'd love to help. A straightforward row-based file format should be quite straightforward to make a loader for!
- gregsadetsky 6y ago
  Thanks a lot! I look forward to that. Congrats on such a great tool