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

  1. Forum: Vertabelo
+1
W trakcie analizy

Adding rulers/guide lines to help with positioning elements

Eric Norcross 10 lat temu • Ostatnio zmodyfikowane przez Jack Polkowski 10 lat temu • 3
0
Naprawione

The application allows to create two indexes with the same name

Marek Berkan 10 lat temu • Ostatnio zmodyfikowane przez mark leavesley 10 lat temu • 11
A model validator doesn't check if index name is unique within model. I created two indexes with name "book_fk" in two different tables and a SQL script failed in PostgreSQL database:

SQLState:42P07
message:
ERROR: relation "book_fk" already exists
IMO it should be validated by the application.

Kind regards,
Marek Berkan.
Odpowiedź
anonymous 10 lat temu
I turned out that it's specific for MySQL that keys' names may be duplicated within a database. It has been already fixed.
0
W trakcie analizy

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

Keith Alexis 10 lat temu • Ostatnio zmodyfikowane przez Agnieszka Kozubek-Krycuń (Chief Scientist) 10 lat temu • 1
0
W trakcie analizy

Left/Right panel resize produces unexpected results on secondary displays

Steven Haddix 10 lat temu • Ostatnio zmodyfikowane przez Jack Polkowski 10 lat temu • 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
Ukończony

Add Support for the PostgreSQL "jsonb" Data Type

Jason Futch 10 lat temu • Ostatnio zmodyfikowane przez Jack Polkowski 10 lat temu • 2
It appears "jsonb" data type is not recognized yet, is it possible to add this so my warnings go away.
0
Z odpowiedzią

column name seems to be invalid

Alejandro Lamothe 10 lat temu • Ostatnio zmodyfikowane przez Agnieszka Kozubek-Krycuń (Chief Scientist) 10 lat temu • 1

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

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

Aubrey Jones 10 lat temu • Ostatnio zmodyfikowane przez anonymous 10 lat temu • 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
Ukończony

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

Aubrey Jones 10 lat temu • Ostatnio zmodyfikowane przez anonymous 10 lat temu • 1
It would be nice to support the "if not exists" clause for table and index creation when targeting sqlite.
Odpowiedź
anonymous 10 lat temu
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
W trakcie analizy

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

Chris Matus 10 lat temu • zaktualizowano 10 lat temu • 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
Z odpowiedzią

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

Henrique Cunha Moreira de Abre 10 lat temu • Ostatnio zmodyfikowane przez Rafał Strzaliński (Senior Engineer) 10 lat temu • 1
What data should I put inside the field "check expression"?
mysql -> table properties -> columns -> details -> check expression


Customer support service by UserEcho