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

0
Є відповідь

does not recognize my email

jeffreyjohnson11 6 років тому оновлено Adam Mościcki 6 років тому 1

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. 

0
Fixed

SQLite Autoincrement

Javier Tejedor 9 років тому оновлено hepeyowa 6 років тому 3

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.

Відповідь
anonymous 9 років тому

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.


0
Declined

Is posible to share tables between diagrams?

Toni Aracil Sobrino 6 років тому оновлено Adam Mościcki 6 років тому 1

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.

+1
Under review

Please add adjustable rules for all of us anal-retentive people

Eric Norcross 9 років тому оновлено Joana PhotoshopSupply 6 років тому 3

I spend waaaaay too much time trying to align and make boxes the same size

0
Є відповідь

Getting error trying to use reverse engineering tool

Kent Graziano 10 років тому оновлено Yomiyu Malifu 6 років тому 11
I am using this command line on Windows 8:
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 running in my \vertabelo directory. I downloaded the .jar file to that folder.

I am very bad at command line so have no idea how to fix this.
0
Виконано

login history

Samir Agarwal 9 років тому оновлено Jeffrey E 6 років тому 1

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

+1
Planned

Add data type support for PostgreSQL

Matthew Weber 6 років тому оновлено Rafał Strzaliński (Senior Engineer) 6 років тому 1

This is the datatype recommended by PG to use but it isn't supported.

Likewise Serial2 would be a nice addition

0
Є відповідь

How to create a query joining tables

Fabien SARFATI 6 років тому оновлено Adam Mościcki 6 років тому 1

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


Відповідь
Adam Mościcki 6 років тому

Hello,

No, you can't. There is no such option.

Best regards,
Adam

0
Виконано

Security / Privacy

Julian Thomas 6 років тому оновлено Łukasz Kubicki 6 років тому 1

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?

Відповідь
Łukasz Kubicki 6 років тому

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

+6
Under review

Triggers

mark leavesley 10 років тому оновлено Chad P. Prince 6 років тому 2
I've seen the workaround to add computed columns but it doesn't show graphically that the column is computed. Likewise, I could do the same for triggers but again I wouldn't be able to see at a glance where the triggers were. I would have thought another box like you have for default value etc would suffice. If you don't want to make an interface to build triggers fine, but at least allow us to mark that a column has update/insert/delete triggers or is computed.