Google Answers Logo
View Question
 
Q: Code browsing tools/advice needed for ASP & SQL ( No Answer,   0 Comments )
Question  
Subject: Code browsing tools/advice needed for ASP & SQL
Category: Computers > Programming
Asked by: donphiltrodt-ga
List Price: $62.00
Posted: 23 Jun 2004 12:14 PDT
Expires: 25 Jun 2004 12:18 PDT
Question ID: 365215
.

WANTED: Recommendations (tools and advice) for facilitating the
process of "code reading" as I begin the process of rewriting a big
web application written in ASP (VBscript, not .NET) and SQL.


I've got a big ol' pile of code that I wrote two years ago.  I need to
get my head wrapped around it and refamiliarize myself with it.  The
ultimate objective is not for *me* to rewrite it, but to document the
code (comments AND external docs) so that I can successfully manage
somebody else rewriting (and upgrading) it.

The code consists of ASP (VBScript) and Microsoft SQL: Tables, Views,
Stored Procedures, Functions and Triggers.

I believe there are tools (Code browsers?  Really smart text editors?
File search tools?) that can facilitate the process of "code reading",
that is, the process of studying the code exhaustively in order to
fully "grok" it in order to refactor/upgrade it.

The tools I hope you'll help me find go beyond your typical "file
search and replacement" tool.  I already have a great text searching
program by Funduc software that is somewhat helpful for codebrowsing,
but doesn't offer as much help as I need.  However, there are probably
search-and-replacement tools that have a feature set specifically
designed for code browsing.  Feel free to recommend anything!

Here are some ways these tools (or tactics) could help me...

--) Dependency tracking:  I'm guessing that there are tools that
elucidate which parts of the code rely on what and vice versa.

--) Code visualization.  Being able to view a diagram of my
dependencies would be immensely helpful.

--) Code surfing: being able to surf my code like the web would be
excellent.  For example, double-clicking a function call would show me
the code, regardless of where that function is located.  Furthermore,
while viewing the function, being able to see a list of routines that
call that function would be very helpful as well.

--) Cross-language browsing: Since the ASP depends on SQL objects,
being able to browse between the ASP code and SQL it depends on would
be very helpful.  Since this feature (like all the features I'm hoping
for) seems unlikely, I'd be satisfied to use SQL-only tools in
parallel with ASP-only tools.

Since my awareness level is so low when it comes to these magic tools
that I HOPE exist, you and I will need to use the clarification
process to iteratively clarify the direction and scope of your
research.  Perhaps a good starting point is to post the titles of
tools you've found, along with the amount of time you've spent.  Then,
based on preliminary info, we can determine the next step.

Thank you and good luck.

Clarification of Question by donphiltrodt-ga on 23 Jun 2004 12:17 PDT
UPDATE: Oops!  I just realized that I have a similar need to
browse/visualize/surf Perl code.

Since I don't want to bloat this question, I'd like to request that,
as you're searching, you keep a list of browsers that would work with
Perl as well.  No need to investigate, just keep a "dump" of Perl
browsing options.
Answer  
There is no answer at this time.

Comments  
There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy