Parsing HTML to SQL using SQLDOM

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by David Rueter » Parsing HTML to SQL using SQLDOM

20 posts, Page 1 of 2

1 2 »»

Parsing HTML to SQL using SQLDOM

Rate Topic

Display Mode

Topic Options

Author

Message

David Rueter

Posted Sunday, April 15, 2012 11:30 PM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 11:22 PM
Points: 44, Visits: 357

Comments posted to this topic are about the item Parsing HTML to SQL using SQLDOM

Post #1283878

davoscollective

Posted Monday, April 16, 2012 1:08 AM

SSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 12:34 AM
Points: 408, Visits: 686

Very useful tools, thanks for sharing!

Post #1283908

phil 26982

Posted Monday, April 16, 2012 1:39 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, June 22, 2012 7:49 AM
Points: 1, Visits: 9

Very nice thanks for sharing those tools with us!
I have had to do somethinng similar in the past but was fortunate enough to be using an html source that was well formatted xml, so the xml type was just what I needed. This looks very useful for 'other' flavours of html document.

Post #1283915

Jerrry Brenner

Posted Monday, April 16, 2012 2:55 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, November 19, 2012 4:53 PM
Points: 1, Visits: 109

I gave a talk at SQL Saturday 109 about how we have functionality in our application that captures the top 400 SQL statements by total elapsed time, including the showplan xml, and builds a zip file of interlinked html pages and returns the zip file to the user through the browser. For each showplan xml string, we build a DOM and run some xPath expressions across the DOM, to pull out useful information and to build a tabular representation of the query plan, showing useful information that's dependent on the type of RelOp node. (I'm repeating the talk for the SQL PASS Virtual Performance Chapter on 5/24. I got the idea of using a tabular display for the query plans from blog posts by Pinal Dave and Michael Coles. They used xQuery imbedded in SQL, but doing it in the app server is much more efficient, especially given the # of plans that I am capturing and the conditional evaluation of xPath expressions. (Show the build and probe tables for a hash match, sort columns, etc.)

It seems like your code could be used to do some (or all) of that, with the ability to conditionally run xPath expressions against the showplan xml being very useful for anyone that wanted to do a detailed analysis of an arbitrary query plan.

Post #1283935

Phil Morris-454316

Posted Monday, April 16, 2012 3:13 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, April 27, 2012 8:54 AM
Points: 6, Visits: 36

That's really neat Jerry. SSIS log tables would be another similar need for something good like that. I've done it with the BI tools before, but a SQL-HTML setup for this would be even better. I had a play with SQL-XML-XSLT-HTML with this also and that also seemed a neat approach.

Post #1283945

chris.rogers00

Posted Monday, April 16, 2012 7:42 AM

Valued Member

Group: General Forum Members
Last Login: Today @ 2:31 PM
Points: 56, Visits: 121

Very useful tool, thank you, but I don't know why you felt the need to include a whole text document about "God" in the project files. I'm not sure what your god has to do with SQL Server. Thank you though

Post #1284112

Dave Vroman

Posted Monday, April 16, 2012 9:41 AM

SSC Rookie

Group: General Forum Members
Last Login: Today @ 10:44 AM
Points: 46, Visits: 205

Very nice. I'm curious if the SQLDOM is using HTML5.
In that case the <BR>
would become <br />. Any of the tags that do not have a closing tag, such as line break and image must be in the form <tag />.

Post #1284212

dmfd

Posted Monday, April 16, 2012 9:48 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, April 19, 2012 2:30 PM
Points: 5, Visits: 14

David, thank you for this. I have a pet project that will require me to screen scrape a few sites. This will definitely come in handy.

Post #1284224

dsfjoijoiioj

Posted Monday, April 16, 2012 7:38 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, April 16, 2012 7:37 PM
Points: 5, Visits: 1

n2012 comes, in order to thank everyone, characteristic, novel style, varieties, low price and good quality, and the low sale price. Thank everyone

==== ( http://www.fullmalls.com ) =====

==== ( http://www.fullmalls.com ) =====

$33 True Religion jeans, Ed Hardy jeans,LV,Coogi jeans,Affliction jeans

$30 Air Jordan shoes,Shox shoes,Gucci,LV shoes

50%Discount winter fashion :Sandle,t-shirt,caps,jerseys,handbag and brand watches!!!

$15 Ed Hardy ,LV ,Gucci Bikini

$15 Polo, Ed Hardy, Gucci, LV, Lacoste T-shirts

$25 Coach,Gucci,LV,Prada,Juicy,Chanel handbag,

$10 Gucci,Ed Hardy sunglasses

$9 New Era caps.

give you the unexpected harvest

==== ( http://www.fullmalls.com ) =====

==== ( http://www.fullmalls.com ) =====

==== ( http://www.fullmalls.com ) =====

==== ( http://www.fullmalls.com ) =====

==== ( http://www.fullmalls.com ) =====

==== ( http://www.fullmalls.com ) =====

==== ( http://www.fullmalls.com ) =====

==== ( http://www.fullmalls.com ) =====

==== ( http://www.fullmalls.com ) =====

Post #1284632

mohdasalah

Posted Tuesday, April 17, 2012 12:29 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, November 16, 2012 2:53 AM
Points: 1, Visits: 21

Thank you it's very usefull but how about its performance, did you do any stress test?

Post #1284689

« Prev Topic | Next Topic »

20 posts, Page 1 of 2

1 2 »»

Permissions