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

+9
Under review

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

Chris Matus 9 years ago updated 9 years ago 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
Answered

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

Henrique Cunha Moreira de Abre 9 years ago updated by Rafał Strzaliński (Senior Engineer) 9 years ago 1
What data should I put inside the field "check expression"?
mysql -> table properties -> columns -> details -> check expression
0
Answered

how to export the DB model into VISIO 2013?

Chaithanya Naik 9 years ago updated by Agnieszka Kozubek-Krycuń (Chief Scientist) 9 years ago 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 9 years ago updated by Agnieszka Kozubek-Krycuń (Chief Scientist) 9 years ago 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 review

Adding a group to view my large schema

sam Prin 9 years ago updated by Rafał Strzaliński (Senior Engineer) 9 years ago 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
Answered

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

Sally C 9 years ago updated by anonymous 9 years ago 1
Answer
anonymous 9 years ago
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
Fixed

How do i move a model into my team account ?

Ed Croft 9 years ago updated by anonymous 9 years ago 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
Fixed

Typo in bonus-page

Valentin Mocanu 9 years ago updated by anonymous 9 years ago 1
On http://www.vertabelo.com/bonus-points there's a typo at the end: "For new and valueble feature request..."
Answer
anonymous 9 years ago
Fixed. Thanks for letting us know about this.
0
Answered

How to change the text size

Mengzhou Fang 9 years ago updated by Agnieszka Kozubek-Krycuń (Chief Scientist) 9 years ago 1
When I export an PDF, my printout looks so tiny. I need to make the text size larger. But I can't
0
Not a bug

SQL Server Model with column name of Order adds quotes

Kindler Chase 9 years ago updated by Rafał Strzaliński (Senior Engineer) 9 years ago 6
When adding a table for SQL Server and with a column name of Order, the generated SQL incorrectly adds quotes around the column name:

-- tables-- Table: OrderTest
CREATE TABLE OrderTest (
 "Order" int NOT NULL,
 Value varchar(250) NOT NULL
)
;

The generated SQL should be using brackets:

-- tables-- Table: OrderTest
CREATE TABLE OrderTest (
[Order] int NOT NULL,
 Value varchar(250) NOT NULL
)
;

I haven't tried other key words; if you fix this, I'd suggest testing other key words as well.

Thanks!