17

I'm using Derby ij to look into my local Apache Derby database. It's just a folder and I connect to it like this:

 connect 'jdbc:derby:C:\Users\Torben\MyDatabase' USER 'me' PASSWORD 'secret';

It works, but I don't really like to look into the database in the console. Is there another tool for this? The best would be something with a GUI.

Joachim Sauer
  • 302,674
  • 57
  • 556
  • 614
Torben
  • 173
  • 1
  • 1
  • 4
  • 2
    Here is a list of applications: http://wiki.apache.org/db-derby/UsesOfDerby#Products_By_Type –  Feb 19 '13 at 13:25
  • DBVisualizer is another tool, you can connect to many DBs – Davut Gürbüz Feb 10 '19 at 08:45
  • Above link (wiki.apache.org/....) is no more valid. New link: https://cwiki.apache.org/confluence/display/DERBY/UsesOfDerby (but needs an apache-login) – Heri Oct 31 '19 at 17:01

3 Answers3

15

Squirrel SQL can connect to an Apache Derby database. Getting Started using the SQuirreL SQL Client

TENNO
  • 165
  • 2
  • 11
Bryan Pendleton
  • 16,128
  • 3
  • 32
  • 56
  • 1
    RazorSQl is another option (more user friendly than squirrel in my opinion), but it is free just for 30 days =( – Thomas Nov 05 '12 at 15:13
6

I use DBeaver Community Edition (free and open source).

When comparing DBeaver CE 6.0.2 (2019-04-08) against SQuirreL 3.9.1 (2019-02-24) I noticed that SQuirreL does not show some database objects (eg. sequences).

DBeaver supports intellisense / auto-completion, updating table rows in-place (ie. "select for update"), and can globally apply filters on schemas and catalogs in connection settings (eg. exclude SYS schemas from the object tree display). It can also run pre- and post-connection scripts (handy for initialising an ij session with preferences eg. protocols).

enter image description here

mvanle
  • 1,847
  • 23
  • 19
  • Worked great - intuitive and super easy to set up. Automatically downloaded the Derby driver files for me. – LeslieM Feb 15 '22 at 16:32
2

I simply use NetBeans IDE (Services -> Databases) to connect to my local or remote derby databases.

You can also create new derby databases there.

Stefan Uhlig
  • 21
  • 2