D3.js & MS SQL datasource

Question

D3.js & MS SQL datasource

J Livingston SQL

SSC Guru

Points: 51550
More actions
November 17, 2016 at 1:37 pm

#401075

Hi....you can call this request "homework" or as I prefer "self learning".
Anyone out there that can point me towards an idiots guide for using D3 and using MS SQL (2016) as the source of the data.
been thrown a "project" that I have zilch knowledge of.... seen lots of resources on the web, but most assume prior knowledge.
I am very comfortable in querying SQL.....but now have a need to get up to speed with at least a base understanding of how D3 can query SQL.
sorry if it sound vague.....but at the moment I am wallowing in websites !
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 1

To be honest, I thought "D3" was the latest rage in dietary supplements. I apologize for not being a help but at least this will act as a "bump" for your post.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

pietlinden SSC Guru Points: 63509 More actions · Answer 2

I think I understand what's up with this... D3 apparently consumes JSON data. check out Mike Bostock's site... If you look at the bottom of the page, there's a section that shows the JSON (that basically looks like name/value pairs). So I think what you want is a way to transform your query results to JSON, which SQL 2016 can do, but I've never done it. Then you can just feed the JSON result to the D3 functions to do what you need.

hope that helps a little.

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 3

pietlinden (11/18/2016)
I think I understand what's up with this... D3 apparently consumes JSON data. check out Mike Bostock's site... If you look at the bottom of the page, there's a section that shows the JSON (that basically looks like name/value pairs). So I think what you want is a way to transform your query results to JSON, which SQL 2016 can do, but I've never done it. Then you can just feed the JSON result to the D3 functions to do what you need.
hope that helps a little.

thanks for this......can get JSON output fine, (using SQL 2016) its the feeding to D3 functions thats getting me confussed!!

will take a look at Mike Bostock site...

thanks again

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day