ER Diagrams

Note: please leave bug reports and feature requests on

ER Diagrams

Postby jjunk » Tue Jun 04, 2013 12:37 pm

I'm just getting started with DBeaver and Eclipse (4.2).

I've opened an existing SQLite database with lots of tables and relationships between them.

When I view the ER Diagram, all of the tables are there but there are no relationships (lines, etc.) between any of the columns and tables, even though relationships exist.

I see a screenshot on your website that shows lines and related information between various columns and tables.

Am I missing something here?

Thanks

metadata.png
ER Diagram export
metadata.png (33.55 KiB) Viewed 60058 times
jjunk
 
Posts: 3
Joined: Tue Jun 04, 2013 12:28 pm

Re: ER Diagrams

Postby Serge » Tue Jun 04, 2013 1:59 pm

Hello,

What SQLLite driver do you use?
As far as I know all SQLite JDBC drivers (Zentus, Zerial, Werner) lacks foreign keys metadata support. While underlying SQLite engine supports FKs manipulations high level metadata API doesn't.
I've just checked recent versions and it seems that nothing changed in last couple of years. I'd be happy to add fully functional JDBC driver in DBeaver config but it doesn't exist :(
Maybe someday I'll add my own implementation of fixed JDBC driver for SQLite (as I did for Cassandra).
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: ER Diagrams

Postby jjunk » Tue Jun 04, 2013 11:52 pm

Hi Serge,

Thanks for the quick response!

I have tried all three SQLite drivers with the same results.

Am I correct in understanding that it is a limitation of the SQLite JDBC drivers and is peculiar to reverse engineering SQLite ER Diagrams?

I haven't tried another database and related drivers yet (e.g. MySQL) but does it work for those in Eclipse?

Not a show stopper. Just wondering if I was doing something wrong.

Thanks

Jeff
jjunk
 
Posts: 3
Joined: Tue Jun 04, 2013 12:28 pm

Re: ER Diagrams

Postby Serge » Wed Jun 05, 2013 7:52 am

Yes, it is a limitation of driver. DBeaver needs informations about foreign keys to build ERD associations.
For instance here is ERD I made a minute ago for Oracle sample schema:
Attachments
erd_hr.png
erd_hr.png (27.38 KiB) Viewed 60046 times
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: ER Diagrams

Postby stonebig » Sun Jan 26, 2014 11:25 am

Hello,

I would like to see If I can improve the situation regarding SQLite Driver,as I see there is life in the Xerail Driver.
Could you pinpoint where I should start in existing documentation of DBeaver or JDBC ?

Regards,
stonebig
 
Posts: 1
Joined: Sun Jan 26, 2014 11:20 am

Re: ER Diagrams

Postby Serge » Sun Jan 26, 2014 8:44 pm

Hello,

I agree, current situation with SQLite driver support isn't good. I'm going to change it in the next version.
I'll remove Werner and Zentus drivers (obviously they are too old, doesn't support many features, etc). And I'll update Xerial to the most recent version and will improve metadata reading functions.
Some improvements are already done. Example of ERD rendered in SQLite/Chinook sample DB is in attachment.
Next version release planned on the beginning of February. If you'd wish to test recent improvements then I can make EA version.

Thanks
Attachments
sqlite_Chinook.png
sqlite_Chinook.png (42.11 KiB) Viewed 58080 times
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: ER Diagrams

Postby valix » Wed Mar 26, 2014 4:29 pm

Hello,
It's nice to see that in the latest version the ER diagrams stared to work for SQLite, but there still is a limitation/bug.
If there are multiple foreign keys in a table, DBeaver is only displaying the first foreign key in table properties and the ER Diagram is incomplete.
I am running DBeaver 2.3.8 that is using sqlite-jdbc4-3.8.2 driver.

Is this a bug that can be addressed or it's another limitation ?

Thanks.
valix
 
Posts: 1
Joined: Wed Mar 26, 2014 4:18 pm

Re: ER Diagrams

Postby Serge » Thu Mar 27, 2014 11:31 am

Hi,

Yep, it is a yet another bug (actually two bugs, one in SQLite driver and one in DBeaver). Driver just doesn't return names of FK/PK so I have to generate them when loading metadata.
This problem will be fixed in the next version.

Thanks for report!
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: ER Diagrams

Postby noanylove » Fri Oct 24, 2014 8:35 pm

Having the same problem as valix mentioned, it does not work correctly when there are multiple foreign keys in a table. I'm using Dbeaver 3.0.2 and xerial's sqlite-jdbc-3.7.2.jar. Wish to fix the this probelm soon. Thanks. :D
noanylove
 
Posts: 5
Joined: Fri Oct 24, 2014 8:28 pm

Re: ER Diagrams

Postby Serge » Sun Oct 26, 2014 12:25 pm

Hello,

That's odd. I can see all FKs in my sample databases. But maybe you have another database version.
Did you try another SQLite drivers? (you can add them manually in driver manager).

Thanks
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Next

Return to Support



Who is online

Users browsing this forum: No registered users and 19 guests