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

0
Under review

how do you export a list of titles and descriptions for the attributes

Keith Alexis 9 років тому оновлено Agnieszka Kozubek-Krycuń (Chief Scientist) 9 років тому 1
0
Under review

Left/Right panel resize produces unexpected results on secondary displays

Steven Haddix 9 років тому оновлено Jack Polkowski 9 років тому 2
Steps to Reproduce:
  1. Place browser within a display/monitor not set as the main display for windows.
  2. Attempt to resize the left or right panel using the drag and drop bar.
Actual Results
  • Light blue bar appears and drags with with mouse correctly
  • When released panel resizes to smallest possible width.
Expected Results
  • Light blue bar appears and drags with with mouse correctly
  • When released panel resizes to location of blue bar.
Environment
  • OS: Windows 7
  • Browser: Chrome
Image 77
0
Виконано

Add Support for the PostgreSQL "jsonb" Data Type

Jason Futch 9 років тому оновлено Jack Polkowski 9 років тому 2
It appears "jsonb" data type is not recognized yet, is it possible to add this so my warnings go away.
0
Є відповідь

column name seems to be invalid

Alejandro Lamothe 9 років тому оновлено Agnieszka Kozubek-Krycuń (Chief Scientist) 9 років тому 1

Image 73
Column Name seems to be invalid appears in the Warnings window, it does not say why,
0
Under review

Multi column index SQL preview is often incorrect, with missing columns or incorrect order of columns.

Aubrey Jones 9 років тому оновлено anonymous 9 років тому 1
Create a table with multiple columns. Create a multi column index that doesn't include the PK. Press the SQL Preview button... maybe it's right, maybe it isn't. Reorder the columns in your index, or add/delete one, and try again. I bet it's not correct now.
0
Виконано

Support "if not exists" clause in sqlite table and index creation.

Aubrey Jones 9 років тому оновлено anonymous 9 років тому 1
It would be nice to support the "if not exists" clause for table and index creation when targeting sqlite.
Відповідь
anonymous 9 років тому
Vertabelo already supports "if not exists" clause in these two statements.

In case of table creation, just expand "Additional properties" section and set "IF NOT EXISTS clause" to "Yes":



You'll then see your this clause in generated SQL:



The same applies to index. Just set the property like this:



and you'll see this in the SQL output:



I hope this helps.
+9
Under review

Indicating that the down-scaled table has more columns than are being displayed

Chris Matus 9 років тому оновлений 9 років тому 2
Some time ago I have reduced the heights of the largest tables in my database model to minimize its size. That way, I have scaled several tables. Many columns in these tables where hidden. Unfortunately, there are no icons within the down-scaled tables indicating that these tables have more columns than are displayed. In my opinion, this is a fundamental feature to know which tables have additional, hidden content. In all other applications, there are relevant icons (usually in the right bottom corner) indicating that the object has more content inside it. It's very important to have such information available, especially when you're working an a huge database model for a long time and it's very likely that you forget which tables were vertically scaled.
0
Є відповідь

What is "check expression" (mysql -> table properties -> columns -> details -> check expression)? What should I use?

Henrique Cunha Moreira de Abre 9 років тому оновлено Rafał Strzaliński (Senior Engineer) 9 років тому 1
What data should I put inside the field "check expression"?
mysql -> table properties -> columns -> details -> check expression
0
Є відповідь

how to export the DB model into VISIO 2013?

Chaithanya Naik 10 років тому оновлено Agnieszka Kozubek-Krycuń (Chief Scientist) 10 років тому 1
I have created 2 DB models in vertabelo but now i need to export it to VISIO 2013..
is there a way to export this to VISIO 2013 format?
+1
Planned

Update columns in view fails to determin type for CASE expression

Tomasz Traczyk 10 років тому оновлено Agnieszka Kozubek-Krycuń (Chief Scientist) 10 років тому 1
In my model I have a view using the CASE expression for some column, like this:

SELECT
(...)
CASE WHEN <some condition> THEN b.name
ELSE c.name
END AS name
(...)

When I click the Update columns button, column name is constantly interpreted as int, while both b.name and c.name are varchar (in fact in my case they even refer to the same column of the same table).

I suppose it might be difficult in general to reason about the desired type of case expression, but as for me, silently assuming that it's int, without any warring is a bug.

I've fixed the type manually sometime ago, then today I've added some new columns to my view and then, not remembering about the issue, hit "Update columns", which silently broke my model. I'd rather get an error, that Vertabelo is unable to update columns.