Leo already has reasonable CSV support via the "edit-pane-csv" command,
thanks to Terry.
This could be improved if the CSV header line could be "frozen", so it
shows even when scrolling down in the CSV table.
IMHO, this is of limited use unless one can also scroll horizontally, hide
columns, filter rows etc. You end up with a large subset of Excel. I
usually use LibreOffice calc for this, although it too has annoying
misfeatures, like automatic spelling correction and type (date, number)
recognition, which makes it a pain to use on plain CSV files.
For storing structured data in a text file I find JSON acceptable and YAML
too complicated. I myself prefer Lua files to store structured data, and
read it into Python with the lupa module (the data files return a table
with "return {...}", so it becomes easy to read them with dofile and to
check the syntax with lua. This works well when the data is to be edited by
hand, especially when your data is better represented in a tree than in a
table.
For large, programmatically generated databases, better use a real SQL or
NoSQL database to store the data.
It would be interesting to use Leo as a database front-end, like Edward
suggests (I currently use "DB Browser for SQLite" for this purpose).
Perhaps the Leo would be more suited as a front-end to NoSQL databases,
though.
- Josef
On Saturday, May 4, 2019 at 7:25:24 PM UTC+2, Arjan wrote:
>
> I'd also be very interested in this.
>
> Also related, this earlier thread on Using Leo as a database
> <https://groups.google.com/forum/#!msg/leo-editor/CsCpbheOFMw/-FZnbknRAAAJ> -
> I'd love to hear followup on that.
>
> I'd prefer having the result set of a query (multiple rows) inside a
> single node body, but I think improved handling of CSV-like data would be
> needed to make this more useful.
>
--
You received this message because you are subscribed to the Google Groups
"leo-editor" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to leo-editor+unsubscr...@googlegroups.com.
To post to this group, send email to leo-editor@googlegroups.com.
Visit this group at https://groups.google.com/group/leo-editor.
For more options, visit https://groups.google.com/d/optout.
