Your feedback is highly appreciated! Let's make Vertabelo even better.

0
Completed

Export selected subset of Tables to .png

Gabe Gates 9 years ago updated by anonymous 9 years ago 1
Once a model becomes too big to export as .png there isn't much of an alternative (that I'm aware of) to share. It would be awesome to define a set of tables / areas to export. Currently I have to split up the main model and create smaller models in order to export and share.
Answer
anonymous 9 years ago
There already is such an option. You can just select multiple tables (and references or views) and click the button to export to PNG. Only these elements will be present on the image. The same applies to the subject area - just select an area and export it to PNG.

If it's about managing large diagrams, please watch this video tutorial:

It explains how to make the work with big diagrams easier using subject areas and table shortcuts.
+7
Under review

Option to hide all references and leave only tables displayed

Patrick Otin 9 years ago updated by Gabe Gates 9 years ago 2
My model is huge and it consists of over 100 tables and twice as more references. The jungle of lines was very confusing for me. Therefore, I deleted all references and used table colors, sizes and positions, as well as subject areas to visualize the structure of my database.
It would be great for me if Vertabelo had an option allowing user to hide all references without deleting them.
The other idea is to allow user to hide all references and show only these ones which are associated with the currently selected table. If no table is selected, all references are hidden but when the cursor is over the table, all references associated with that table are being displayed in gray. If user selects the table, all these references (associated with the table) are shown in normal color (black).
0
Answered

[PostgreSQL] Add quotes to generated SQL table names and columns

john palat 9 years ago updated 9 years ago 2
PostgreSQL does not require double quotes around table names and identifiers, it will just lower case them. However, I want them to remain in a certain case in the database. For example, if I add a table Team, I want it to show up as Team, not team. The generated sql will not add any quotes to the name unless it's a reserved keyword. Is there a way for me to add this? I only found this: http://support.vertabelo.com/topic/529465-postgresql-script-generated-ignore-double-quota-set-schema-and-tablespace-name/


but I don't think it's related.




Also with FK, if I have Team_id as a column, it will become team_id in the database w/o quotes. Help?
Answer
anonymous 9 years ago
Just check the "Quote all SQL identifiers" checkbox in "SQL generation settings" section:




All table and column names will be in double quotes.
+2
Under review

Bulk update table properties

Grzegorz Kaczor 9 years ago updated by anonymous 9 years ago 1
I would like to be able to bulk update properties of selected tables. For example, set tablespace for all tables except one. Or change initial value of multiple sequences. Now I have to click all the tables, one by one.
0
Answered

How to add and hide references on diagram?

Grzegorz Kaczor 9 years ago updated by anonymous 9 years ago 3
I have table A which is connected to many other entities, and I want to organize my diagram better.

So I drag the second copy of table A (the one with dashed borders) to the diagram. And I drag table B next to it. How can I draw an existing reference between these tables?

And how can I hide reference between original table A and table B? I don't want to delete the reference, I just want to hide its particular instance in the picture.
Answer
anonymous 9 years ago
So I drag the second copy of table A (the one with dashed borders) to the diagram. And I drag table B next to it. How can I draw an existing reference between these tables?
OK, you can do this with exactly 4 mouse clicks. First, select those tables (2 clicks). Then click on the reference symbol in the menu and choose "Show all references" option:




The reference will show up.

And how can I hide reference between original table A and table B? I don't want to delete the reference, I just want to hide its particular instance in the picture.
If an object (table or reference) has more than one visual representation (has dashed borders), it's deletion is deletion of visual representation only. The model object is deleted when its last visual representation is deleted.
0
Answered

How are anonymous models saved between browser sessions?

Timothy Duch 9 years ago updated by anonymous 9 years ago 2
I'm curious as to how Vertabelo is remembering my (anonymous) model between my browser sessions. I have cookies turned off, so where is Vertabelo storing this information? I cleared my history, and the model is magically no longer saved (I figured it was done via cookies... so why is it gone now even though cookies were turned off earlier?). There are obvious reasons as to why this question is important.
0
Answered

How can you export the schema so as to import the schema into MS Access?

Marco Naylon 9 years ago updated by anonymous 9 years ago 1
I want to be able to have all the tables and relationships imported so I can test queries.
Answer
anonymous 9 years ago
Vertabelo does not support MS Access in any special way.

If you want to test queries using a DBMS you chose when creating a model, I'd recommend you SQL Fiddle. It supports MySQL, Oracle, PostgreSQL, MS SQL Server and SQLite.
0
Answered

Do high schools count under the educational plans?

Kenny Cohen 9 years ago updated by Jack Polkowski 9 years ago 2
I was just wondering if there was any way that my high school friend could register for vertabelo using his high school id and email as he is not in college yet. We are teaching each other how to build database systems.

Thanks
0
Answered

Vilnius University Mathematical and Informatics faculty email address. Cannot get Academic plan. Possible to be fixed?

Tomas Juodokas 9 years ago updated by Agnieszka Kozubek-Krycuń (Chief Scientist) 9 years ago 1
Can you add this email to whitelist? Need vertabelo for learning and academic purposes.
University email: name.surname@mif.stud.vu.lt
Faculty website: http://mif.vu.lt/lt3/
0
Started

Check with newline generated to SQL without spaces

Grzegorz Kaczor 9 years ago updated by Agnieszka Kozubek-Krycuń (Chief Scientist) 9 years ago 3
I have a check:

CONDITION
OR
CONDITION

written in 3 lines. In generated SQL the check looks like:

CONDITIONORCONDITION

but it should be

CONDITION OR CONDITION