pictures or diagrams of data and query patterns ?

[denis-bz]

Hi Damien
(not an issue, just a question, please move to Discussions)
I think I saw pictures or diagrams of data and query patterns, little trees ?
under polars someplace, but can't find it again and don't know the right terms.
I'm not a database guy, but there are so many different ways of storing and querying data
that little pictures might be fun / help intuition.
Does that ring a bell or am I way off ?
Thanks, cheers
-- denis

[ddotta]

Hello @denis-bz,
Sorry for the delay in replying.
The images or diagrams you're talking about don't ring a bell and I've never come across them.
Maybe other Polars users will have an idea?
Maybe @eitsupi or @etiennebacher?

[denis-bz]

Hi Damien,
found it, wasn't polars after all: https://github.com/tableau/query-graphs
Thanks, cheers

[etiennebacher]

Polars can create query trees: https://pola-rs.github.io/polars/py-polars/html/reference/expressions/api/polars.Expr.meta.tree_format.html

This has been improved in the development version, see here for an example: pola-rs/polars#11176

AFAIK this is not available in the R version for now

[etiennebacher]

Actually the example above only creates trees that detail polars expressions.

For query trees, use show_graph: https://pola-rs.github.io/polars/py-polars/html/reference/lazyframe/api/polars.LazyFrame.show_graph.html

[ddotta]

Thank you both for this information, I close the issue

[denis-bz]

Folks,
would a gallery of pictures of a dozen different query trees be informative, fun ?
Seems to me there's quite a gap between users' views of queries, and developers' views;
could little pictures, easy to collect and send around, help close the gap ?
Ideally they could be used both to analyze and test --
real queries --> Qpic, query pics --> testbench

Does that make sense, what do you think ?