thomasp85

6 ms·

1.
by thomasp85 3mo ago
No objections at all. But probably good to describe that it is ggsql-inspired rather than a full reimplementation as it could lead to user confusion about what syntax is supported etc And you are correct about how our extension is implement
2.
by thomasp85 3mo ago
ggsql developer here. It's quite fun to see an alternative implementation of our syntax so early. Why did you decide on this path rather than working with the ggsql duckdb extension? (honest curious question - not trying to push you aw
3.
ggsql 0.4.1: new release adds spatial plotting and in-layer aggregation(opensource.posit.co)
2 points by thomasp85 3mo ago|0 comments
4.
by thomasp85 5mo ago
We are not out to convince anyone to switch from ggplot2 (and we are not planning to stop developing that). ggsql is (partly) about reaching new audiences and putting powerful visualisation in new places. If you live in R most of the time I
5.
by thomasp85 5mo ago
Ah - I don't think it really matters here, but if you find yourself in need then you can open a GitHub issue and we can discuss
6.
by thomasp85 5mo ago
Ah - yes, in theory you could create a "ggplot2 writer" which renders the plot object to an R file you can execute. It is not too far away from the current Vega-Lite writer we use. The other direction (ggplot2->ggsql) is not re
7.
by thomasp85 5mo ago
That is certainly in the pipeline. We chose to start with vegalite so we could focus on the internals of the representation
8.
by thomasp85 5mo ago
I'm not quite sure I understand what you mean by "degrade in context" - care to elaborate?
9.
by thomasp85 5mo ago
My answers will probably disappoint 1) No (unless you count 'render to image and insert that into your excel document') 2) This is not possible - manual adjustments are not reproducible and we live by that ethos
10.
by thomasp85 5mo ago
Let me try to not miss any of the questions :-) ggsql is modular by design. It consists of various reader modules that takes care of connecting with different data backends (currently we have a DuckDB, an SQLite, and an ODBC reader), a cent
11.
by thomasp85 5mo ago
I don't think we will get the various niche geoms that have been developed by the ggplot2 community anytime soon. The point of this is not to superseed ggplot2 in any way, but to provide a different approach which can do a lot of the t
12.
by thomasp85 5mo ago
That is conceivable, not a top priority as we want to focus on this being a great experience for every backend, but certainly something we are thinking of
13.
by thomasp85 5mo ago
We certainly plan to create a few videos showing how to set it up and use it. If you use it in Positron with the ggsql extension it can interact directly with the connection pane to connect to the various backends you have there
14.
by thomasp85 5mo ago
That is fair - it is somewhat of a special concept. ggsql connects directly with your database backend (if you wish - you can also run it with an in-memory DuckDB backend). Your visual query is translated into a SQL query for each layer of
15.
by thomasp85 5mo ago
I'd say it does, though it is certainly much more low-level than e.g. ggplot2. But the basic premises of the building blocks described be Leland Wilkinson is there
16.
by thomasp85 5mo ago
I'm one of the authors - happy to take any questions!
17.
ggsql: A Grammar of Graphics for SQL(opensource.posit.co)
452 points by thomasp85 5mo ago|85 comments
18.
by thomasp85 5mo ago
The new visualisation tool from Posit. Combines SQL with the grammar of graphics, known from ggplot2, D3, and plotnine
19.
Gganimate has been released. A grammar of animated graphics(data-imaginist.com)
1 points by thomasp85 8y ago|0 comments
20.
by thomasp85 10y ago
Really happy you like it. Would love to see something published using it
21.
by thomasp85 10y ago
You can of course animate it like this https://twitter.com/thomasp85/status/694905779539812352 but a static representation is often easier to interogate. I would try to bin the time points and facet on them...
22.
by thomasp85 10y ago
Without needing to get into an R vs Python discussion I think it is fair to say that this is a perfectly valid subjective opinion and that a lot of people will disagree completely... none of the ggplot2 Python ports holds a candle to the or
23.
by thomasp85 10y ago
Depending on the number of time points you can use the facetting functions in ggraph to create small multiples
24.
by thomasp85 10y ago
I'm in talk with the plotly devs regarding ggraph support — once that materialises it should cover most interaction
25.
by thomasp85 10y ago
Yes, you use already available network packages like igraph and network (where you can import dot files) and then use the declarative API of ggraph to specify your plot