Reading and Writing your Database's Documentation using JSON

Question

Post reply

Reading and Writing your Database's Documentation using JSON

Phil Factor

SSC-Insane

Points: 20244
More actions
May 28, 2021 at 7:47 pm

#3889363

Comments posted to this topic are about the item Reading and Writing your Database's Documentation using JSON
Best wishes,
Phil Factor
June 29, 2021 at 5:24 am

This was removed by the editor as SPAM
June 29, 2021 at 5:26 am

This was removed by the editor as SPAM

Viewing 9 posts - 1 through 8 (of 8 total)

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

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

I guess I don't understand two things...

Why you would ever want the documentation to be separate from the database.
Why on Earth you would want the result to be in JSON.

--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)

ZZartin SSC-Dedicated Points: 30894 More actions · Answer 2

Jeff Moden wrote:

I guess I don't understand two things...
Why you would ever want the documentation to be separate from the database.
Why on Earth you would want the result to be in JSON.

Well I might want to look at the documentation without having to open up SSMS or what not particularly if it's being shared with a non tech person.
Yeah raw json is not the way to do that....

Jeff Moden SSC Guru Points: 1003863 More actions · Answer 3

ZZartin wrote:

Jeff Moden wrote:
I guess I don't understand two things...
Why you would ever want the documentation to be separate from the database.
Why on Earth you would want the result to be in JSON.
Well I might want to look at the documentation without having to open up SSMS or what not particularly if it's being shared with a non tech person.
Yeah raw json is not the way to do that....

What I meant by question 1 was why would you want to maintain it separately? It should all be contained in the database where you can generate the documentation at the drop of a hat... any hat. Maintaining the documentation separately is a sure fire way to have things go "out of sync" or even be skipped entirely.

--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)

james.of.rivendell SSC-Addicted Points: 425 More actions · Answer 4

hi Phil

Could you explain what this means?

"We are in Marcel Proust territory already."

What issue is this describing?

Jeff Moden SSC Guru Points: 1003863 More actions · Answer 5

james.of.rivendell wrote:

hi Phil
Could you explain what this means?
"We are in Marcel Proust territory already."
What issue is this describing?

If you do a search in the article for the first reference, you'll find where Phil states "Remember that, like Marcel Proust's 'À la recherche du temps perdu', everyone will think it wonderful, but nobody will read it."

--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)

Phil Factor SSC-Insane Points: 20244 More actions · Answer 6

'If you do a search in the article for the first reference, you'll find where Phil states "Remember that, like Marcel Proust's 'À la recherche du temps perdu', everyone will think it wonderful, but nobody will read it."'

Thanks Jeff. Absolutely right.

In the question of using JSON, I don't use it because I think it is wonderful, but just because it can be read by almost anything. It is like speaking English. It is not that it is pretty, just that it gets understood. I discovered that it was a good way of documentiung databases entirely by accident. I was doing a series of articles on Flyway. It is a product that intrigues me, but a migrations approach isn't a good way of approaching database documentation. Where do you find it? It isn't with the build script because there isn't one. it could be anywhere in any migration. I was forced to do it but then found it was quick and painless and it was easier to stash in source control.

This reply was modified 2 years, 9 months ago by Phil Factor.

Best wishes,
Phil Factor