3 ms·
It is 'just' the parsing, but the analysis is fairly easy. Here is an example of: 1. Taking a database 2. Parsing every view and stored procedure 3. Tracking
by i_s 9y ago
It is 'just' the parsing, but the analysis is fairly easy. Here is an example of:
1. Taking a database
2. Parsing every view and stored procedure
3. Tracking how tables are joined
4. Creating a graph visualization of the tables and their relationships:
https://github.com/isaksky/FsSqlDom/blob/master/examples/FsSqlDomGallery/FsSqlDomGallery/GraphTableRelationships.fs https://github.com/isaksky/FsSqlDom/blob/master/examples/FsS...
(Not perfect, but does a pretty good job on databases I have tested.)
- intrasight 9y agoI've long thought that a graph visual based query client would be really neat
- weavie 9y agoDidn't ms access have something like this?
- intrasight 9y agoYes - "something like". I'm envisioning more interact with the graph rather than the graph only showing relationships.