Export Coda database structure

Suggestion Box
1

Hi,

It’s quite common that a Coda Doc grows in complexity. More and more tables, with a good number of look-ups between them. Quite fine if you maintain order and control, but anyways it’s easy to achieve a state that is not easy to figure out all the time

When one of my documents achieves certain degree of complexity, I draw a database schema with lucidchart. There are other tools and options for that, sure, but the result is a huge step: a clear diagram which shows tables, its fields and the connections between them

Lucidchart has a importing data option. They offer a SQL request for dumping a tables structure of a database, ready for being imported into lucidchart.

image
image589×787 42.9 KB

I have defined a workaround for saving manual build time of the schema, but it is far from being perfect

If Coda would offer a table like lucidchart demands, or other table ready to be transformed, it would be a huge step. Suddenly we codamakers shouldn’t have to invest time in illustrating Coda tables structure.

Document map is fine, but not enough if document is enough complex

4 Likes
2

I would like to have such functionality. User scenario: make a sample database, then transfer it to a large company database.

3

Hi Juan

@Agile_Dynamics has done some work on visualisations here:

You might be able to use that as a foundation/ inspiration.

Or this:

I know that somebody else has also built something @Brian_Klein (?), but can’t remember the doc now.

4

Found it - the doc is called Doc Inspector.

1 Like
5

See also:

3 Likes