A question. I'm trying to find a tool to visualise and document the evolution of obscure sports (purely because I find the interactions fascinating). It seems that your tool might be the perfect fit, especially the "writing" examples. I was wondering if it would be possible to visualise something along the lines of a quasi-directed graph. Nodes being specific instances of the inception of a "new" sport (hence the date requirement), and edges being the influence on other spots. Multiple edges for each node are possible, and all sports will have a start date and some an end date. I tried[2] with a basic POC but it seems the issue is that the nodes run without an end date, which breaks the dependency visualisation.
One comment. Once logged in I wasn't easily able to get back to the landing page, which had some useful info around visualisation types that I wanted to review.
And a note. I've apologised to a few people who I subjected to a variation on your SQL screener interview question [2], which contained far too much fiddling with SQLite time functions, entirely my mistake in ruining an otherwise great basic SQL test!
Glad you found that SQL screener interview question helpful and sorry if the date/time manipulation made it more complex than it needed to be :).
Regarding the visualization capabilities: I would change the shape of the events from a line to a solid bar. When you combine that with the connections (which you're already using) it will look more like a directed graph like you're interested in. End dates are optional for events, so you should be able to get by with or without it. Happy to discuss more over email: help@preceden.com. Regardless, good luck with your visualization, it's a fascinating use case.
A question. I'm trying to find a tool to visualise and document the evolution of obscure sports (purely because I find the interactions fascinating). It seems that your tool might be the perfect fit, especially the "writing" examples. I was wondering if it would be possible to visualise something along the lines of a quasi-directed graph. Nodes being specific instances of the inception of a "new" sport (hence the date requirement), and edges being the influence on other spots. Multiple edges for each node are possible, and all sports will have a start date and some an end date. I tried[2] with a basic POC but it seems the issue is that the nodes run without an end date, which breaks the dependency visualisation.
One comment. Once logged in I wasn't easily able to get back to the landing page, which had some useful info around visualisation types that I wanted to review.
And a note. I've apologised to a few people who I subjected to a variation on your SQL screener interview question [2], which contained far too much fiddling with SQLite time functions, entirely my mistake in ruining an otherwise great basic SQL test!
[1] https://www.preceden.com/timelines/868890-obscure-sports?s=e... [2] https://mattmazur.com/2018/11/12/analyzing-89-responses-to-a...