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

0
Résolu

does not recognize my email

jeffreyjohnson11 il y a 6 ans mis à jour par Adam Mościcki il y a 6 ans 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
Corrigé

SQLite Autoincrement

Javier Tejedor il y a 9 ans mis à jour par hepeyowa il y a 6 ans 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.

Solution
anonymous il y a 9 ans

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
Écarté

Is posible to share tables between diagrams?

Toni Aracil Sobrino il y a 6 ans mis à jour par Adam Mościcki il y a 6 ans 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
À l'étude

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

Eric Norcross il y a 9 ans mis à jour par Joana PhotoshopSupply il y a 6 ans 3

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

0
Résolu

Getting error trying to use reverse engineering tool

Kent Graziano il y a 10 ans mis à jour par Yomiyu Malifu il y a 6 ans 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
Terminé

login history

Samir Agarwal il y a 9 ans mis à jour par Jeffrey E il y a 6 ans 1

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

+1
Prévu

Add data type support for PostgreSQL

Matthew Weber il y a 6 ans mis à jour par Rafał Strzaliński (Senior Engineer) il y a 6 ans 1

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

Likewise Serial2 would be a nice addition

0
Résolu

How to create a query joining tables

Fabien SARFATI il y a 6 ans mis à jour par Adam Mościcki il y a 6 ans 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


Solution
Adam Mościcki il y a 6 ans

Hello,

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

Best regards,
Adam

0
Terminé

Security / Privacy

Julian Thomas il y a 6 ans mis à jour par Łukasz Kubicki il y a 6 ans 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?

Solution
Łukasz Kubicki il y a 6 ans

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
À l'étude

Triggers

mark leavesley il y a 10 ans mis à jour par Chad P. Prince il y a 6 ans 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.