Wednesday, March 26, 2014

Re: Vim Spreadsheets

On Wed, Mar 26, 2014 at 12:15:13PM +0000, piemas25 wrote:
>
> I might also want a CSV file so it can easily be interacted with
> programmatically in the future, if I ever needed to.
>
> In this case I could either use sc, or csv.vim. I have to try both.
>
>
> 2. For a user-friendly interface (but slower, and the convenience of
> formulas in cells
>
> => Full fledged spreadsheet, probably with sc.

only on vim's mailing list you would call sc's interface
"user-friendly"; great stuff.

>
>
> 3. When I need a more lightweight and flexible way to interact with the data
>
> Then I need an app. I can either store the data in a database or in CSV
> files, depending on my needs.

not sure what you mean by "lightweight" and "flexible".

> - A CSV file is easier to setup, to diff, to look into and to modify
> manually.

sc does io everything in text (another unix feature btw), though i've
had problem with diff'ing in-line. also with using vcs (git in my case)
for keeping track of stuff and laying out different scenarios... but in
both cases my knowledge of the tools (diff and git) may have been
lacking so your mileage may well vary.

> - A database represents relationships between data, and thus will grow
> better as new types of data get added to the mix.
>
> CSV files for simple needs, databases for complexity.
>
>
> One drawback of using one specialized too for each use case, is that you
> lose the benefit of "muscle memory" for key mappings. I'm guessing that
> sc's key mappings are similar enough to Vim's, so it won't be too much of a
> problem.

that, the "muscle memory", and the superior speed of cmdline
user-inteface to that of GUI, are preciesly the reasons i've gone with
sc, and also dwm, dwb, mutt, zathura, newsbeuter and ...

there is a lack of import/export of csv files in sc though but i
understand that libreoffice has a module for that. i use a python script
for that, from linuxjournal.com i think.

--
--
You received this message from the "vim_use" maillist.
Do not top-post! Type your reply below the text you are replying to.
For more information, visit http://www.vim.org/maillist.php

---
You received this message because you are subscribed to the Google Groups "vim_use" group.
To unsubscribe from this group and stop receiving emails from it, send an email to vim_use+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments: