4 ms·
Can you elaborate on how exactly you're "using SQLite for data visualization?"
by EForEndeavour 8y ago
Can you elaborate on how exactly you're "using SQLite for data visualization?"
- zzo38computer 8y agoThe data is either stored in a SQLite database or can be imported (either permanently or temporarily), and then queried (including with a WHERE clause and/or various other stuff, if applicable), and extension for graphics can be use for making the graphics (sqlext_graph), display on screen (sqlext_xwindows), or save to disk (sqlext_pipe and Farbfeld Utilities). Mainly, I fail to see why should I need a different program, if SQL seems good enough? (Of course, if other programs are more helpful to you, you can use those other programs, either instead of or in addition to, SQL. For example, I think sometimes SQLite is combined with R for statistics and graphics.)
- EForEndeavour 8y agoGoogle searches for both sqlext_graph and sqlext_xwindows return your comment as the only result, but I'd love to learn more about these. Can you provide an example of how to produce a scatter plot of, for example, the iris dataset, with points coloured by species? Also, by the time you're leveraging SQL extensions, are you really still "using SQL"?