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

does not recognize my email
I created an account a year ago for the beginner SQL course. I tried to go back to the course today but Vertabelo is claiming that the email associated with my account does not exist. I have the receipt from my purchase on my email account. How would I go about recovering my account? Thank you.

SQLite Autoincrement
Hello, I have exported the SQL for a SQLite Database. In the tables, I have PRIMARY_KEY and AUTOINCREMENT.
CREATE TABLE CSS_AT_RULES ( id integer NOT NULL AUTOINCREMENT, css_version varchar(10) NOT NULL, syntax_id integer NOT NULL, CONSTRAINT CSS_AT_RULES_pk PRIMARY KEY (id) );
Using this format, SQLite is throwing an error due the AUTOINCREMENT is not declared as PRIMARY KEY yet (it is being done in the CONSTRAINT). I am using the java sqlite-jdbc-3.8.11.2.jar driver from org.xerial
SQL Error [1]: [SQLITE_ERROR] SQL error or missing database (near "AUTOINCREMENT": syntax error) java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (near "AUTOINCREMENT": syntax error)
A possible correct syntax (regarding to the SQLite documentation https://www.sqlite.org/autoinc.html ) for the previous example would be:
CREATE TABLE CSS_AT_RULES ( id integer NOT NULL PRIMARY KEY AUTOINCREMENT, css_version varchar(10) NOT NULL, syntax_id integer NOT NULL );
Could you please confirm if I am right?
Regards,
Javier.

Hello,
Yes, it is a bug.
I think, the correct syntax is (as sqlite's faq mentions https://www.sqlite.org/faq.html#q1):
CREATE TABLE CSS_AT_RULES ( id integer NOT NULL, css_version varchar(10) NOT NULL, syntax_id integer NOT NULL, CONSTRAINT CSS_AT_RULES_pk PRIMARY KEY (id) );
If column has type 'integer' and 'primary key' then has also 'autoincrement'.
In this case, the fastes solution is to unset an autoincrement option.
I hope this helps.

Is posible to share tables between diagrams?
I need to share tables between diagrams. Because I need a change in one entity be replicated to table shared table with other diagram. Is that possible?
Thanks.

Please add adjustable rules for all of us anal-retentive people
I spend waaaaay too much time trying to align and make boxes the same size

Getting error trying to use reverse engineering tool
java -cp .;reverse-engineering-1_6_9; com.vertabelo.reverse.Main -url jdbc:oracle:thin:@//localhost:1521/xe -user dv -password xx -o dv_demo
But get the error: Could not find or load main class com.vertabelo.reverse.Main
I am very bad at command line so have no idea how to fix this.

login history
I need the login history of employees also like google docs if you can show history with changes made by employees

Add data type support for PostgreSQL
This is the datatype recommended by PG to use but it isn't supported.
Likewise Serial2 would be a nice addition

How to create a query joining tables
Hello all,
I have existing tables in a database, in a star schema.
I would like a visual tool to create a query joining all tables of the star schema.
Can I do this with Vertabelo ?
Thank you very much

Security / Privacy
I would like to start using this product, but the models that I create here will reveal privileged, proprietary information about my clients, so I need to be comfortable with the associated privacy.
How are the models secured, what assurances do I have as to the privacy of my models?

Hi Julian,
Thanks for reaching out. All the models are hosted on our dedicated servers in Poland. Under the link below you'll find our security white paper which I hope sheds light on the most interesting topics.
Vertabelo Security White Paper
If you need any further information, please let us know.
Regards,
Luke

Triggers
Служба підтримки клієнтів працює на UserEcho