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

0
Under vurdering

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

Aubrey Jones 9 år siden opdateret af anonymous 9 år siden 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
Færdig

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

Aubrey Jones 9 år siden opdateret af anonymous 9 år siden 1
It would be nice to support the "if not exists" clause for table and index creation when targeting sqlite.
Svar
anonymous 9 år siden
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 vurdering

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

Chris Matus 9 år siden opdateret 9 år siden 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
Besvaret

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

Henrique Cunha Moreira de Abre 9 år siden opdateret af Rafał Strzaliński (Senior Engineer) 9 år siden 1
What data should I put inside the field "check expression"?
mysql -> table properties -> columns -> details -> check expression
0
Besvaret

how to export the DB model into VISIO 2013?

Chaithanya Naik 9 år siden opdateret af Agnieszka Kozubek-Krycuń (Chief Scientist) 9 år siden 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
Planlagt

Update columns in view fails to determin type for CASE expression

Tomasz Traczyk 9 år siden opdateret af Agnieszka Kozubek-Krycuń (Chief Scientist) 9 år siden 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.

0
Under vurdering

Adding a group to view my large schema

sam Prin 9 år siden opdateret af Rafał Strzaliński (Senior Engineer) 9 år siden 2
I'd like to add a group of email addresses to view my large database schema.

I don't want to have to pay individually for each member because they are based around the world and I do not have access to their email addresses. I would like to add them to my account. I have tried setting up a company account but the members are unable to view because there are too many tables.

Is this possible?
0
Besvaret

Can I use Vertabelo to learn SQL ? If so, what is the best way to get started ?

Sally C 9 år siden opdateret af anonymous 9 år siden 1
Svar
anonymous 9 år siden
Well, I think it'd be much more useful to learn about database basics and good DB design rather than SQL. We even created a series of videos called "Vertabelo Database Academy" that you can find on YouTube:
https://www.youtube.com/playlist?list=PLghpIrBTN3RJdlnubOCuCmQMQOkgKAYWI

If you want to learn SQL, you can look at the changes in generated SQL while adding tables, references, indexes, keys, etc to your model. This might help you to understand the structure of DDLs. However, it won't be much helpful to learn SQL queries. Here, I'd recommend SQL Fiddle, which allows you to run queries against database "in cloud". You can use SQL script generated with Vertabelo to create a DB structure in SQL Fiddle and then play with inserting, updating and querying the data.

Hope this helps.
+1
Fast

How do i move a model into my team account ?

Ed Croft 9 år siden opdateret af anonymous 9 år siden 7
I have bought a team subscription... but your system won't let me move my models ? How do I move them into team account ?
0
Fast

Typo in bonus-page

Valentin Mocanu 9 år siden opdateret af anonymous 9 år siden 1
On http://www.vertabelo.com/bonus-points there's a typo at the end: "For new and valueble feature request..."
Svar
anonymous 9 år siden
Fixed. Thanks for letting us know about this.

Kundesupport af UserEcho