Relational Database Implementation in Tinderbox?

This is correct, I spend more time figuring out what I need to figure out in TB.

Almost certainly if UML is a markup language like XML. Don’t think in terms of one template per export. By using ^include()^ all sorts of things are possible.

One way to approach things is to take an existing UML documents source code and think how/where you would substitute data expected from XML.

Oddly, when I tried to look up the source code of a specimen UML file lots of references stated it had fallen from use.

Yes UML/RUP are out of favor. I brought it up because I am old and it was a structured system for analysis therefore rigid.

I think I see where you are going, a prototype will supply the primitives and the output (template w/ include) would be tied to those to build out the structure.

Linear thinking is so much easier when you don’t want to think.

Back to the question,
The field/data elements could be a simple note with a field prototype - name, type, length, range, description in the body.

A table would be compose of fields plus additional data (name, desc, space).

Links can used for inner, outer, left, right joins.

A schema would be an upper level container containing all of the above plus name spaces etc. The alisase could be used to represent fk’s.

It sounds like a DTD, database docs and SQL could all be driven out of the above.

Sorry if I bored anyone, answering the question helps me think.

This approach would SQL in multiple RDMBS’s to be generated as needed. (postgres, MSSQL, the Big O).

1 Like

This is easily done. There is nothing in TBX that requires a template to be HTML, the template (or a collection of them) can produce any output: CSV, TSV, JSON, XML, HTML, YAML, Markdown, LaTeX, RDF, Turtle, N-Triples, NDJSON, TOML, INI, TXT, RTF

John, thanks for the response. This is exactly what I wwas trying to get at…Tinderbox can do most of what people need to do in a traditional RD model. To accomplish this they just have to look at the toolset and tackle the problem with these tools and forgoe wha tthey’d traditinal see in a more rigid environment.