Add the ability to integrate models from vertabelo in confluence pages.

We are looking into data modeling tools, and vertabelo looks like a great candidate.

We use confluence in the company for intranet and knowlede sharing, and therefore we will need to integrate the published models in confluence. I cannot see how this can be done.

We are not referring to a link, but rather to be able to create a view only for the model, like it is done in some of your blog posts.

[MySQL 5.7]

I found that the queries

CREATE TABLE `test` (
  `test_id` int(16) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

ALTER TABLE `test`
  ADD PRIMARY KEY (`test_id`);

ALTER TABLE `test`
  MODIFY `test_id` int(16) AUTO_INCREMENT;

seem to be parsed in a strange way. After importing the above as a script and viewing the generated table as SQL it shows

CREATE TABLE test (
  test_id int(16) NULL AUTO_INCREMENT,
  test_id int(16) NULL AUTO_INCREMENT,
  CONSTRAINT test_pk PRIMARY KEY (test_id)
) ENGINE InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;

Which is not what I had in mind but I cannot figure out the problem. 

MySQL Workbench parses this in the wrong way, too - ignoring the MODIFY completely.

PHPMyAdmin on the other hand does it correctly.

Any thoughts on this? :-)

Thanks!

Add an option to generate a Liquibase file for updates. Next to the Generate migration SQL. So the versions (exclude auto saved) contains Liquibase changesets.

Could you add this email to your white list? Need vertabelo for learning and academic purposes.
University email: name.surname@utoronto.ca

University of Toronto

The session timeout behaviour is really really annoying.

I agree that an idle session should become inactive after a while, but a simple reload on the browser should be enough, I always get redirected to the login page and additionally the "Remember me" feature doesn't quite work, because it seems to remember me for just a couple of hours, so what's the point of having this useless feature?

When a diagram starts to have too many objects, it becomes impossible to follow the relationship lines. Adding layers would work like this:

A table could belong to one or more user defined layers, and the user can turn on or off the visibility for each layer. For example, I could turn off all layers except for the 'accounting' layer, and I'd have a very clear view of those objects and their relation.

I don't know why no ER diagraming solution has a layering feature but this should be a must for professional diagrams, this could set you miles apart from other solutions.

I'm trying to create a Vertabelo model from an existing Postgres schema. It looks like you can't create a model from a Postgres database connection, so I exported my Postgres using pg_dump to SQL text and tried Vertabelo "Create New Model" "From SQL".

I get an error message: "SQL import failed. Either our parser is not perfect or your SQL syntax is invalid." with no other info.

1) What's the best way to make a Vertabelo model from an existing Postgres database?

2) The SQL import should give a more useful error message. The lack of useful error info means I don't know what I could do to fix it (e.g, play with Postgres pg_dump export options to get SQL that Vertabelo can read.)

Is there a way to show only the Entity, or the Primary Key of the entity, instead of all the attributes for the entity? Alternatively, is there a way to "shrink" selected entitites in order to fit more entities in a subject area?

how can i display the table filed description in the mysql data model doc?