Aqua Data Studio

Register New Server

Toolbar menu:

Server -> Register Server

Or right-click on a Server Group.

In the Register Server window (or Edit Server window):

  • Select the type of server

  • Give the connection a name

  • Enter credentials

  • Enter host, port, database name


Click “Test Connection” to confirm the connection works.

Save

Configuring SSL

The Aqua Data Studio documentation on SSL Configuration covers configuration of SSL including installing certificates.

A simpler alternative, for non-production testing purposes, is to use a "NonValidatingFactory".  In summary, under Server Properties > Driver, use the parameter:

?ssl=true;sslfactory=org.postgresql.ssl.NonValidatingFactory

Summarize all loans from each location by patron group

select li.location_name, g.groupname, count(*)

from loans_item li

join loans l on li.loan_id = l.id

join users u on l.user_id = u.id

join groups g on u.patron_group_id = g.id

group by li.location_name, g.groupname

order by li.location_name, g.groupname

;


Export Results

Results can be saved to a variety of formats. From menu bar:

File -> Save Results

Then you can save in different data formats such as delimited text, HTML, XML, Excel, etc.:

Note that the results will need to fit into memory. This will not be suitable for a very large result set.

For large results, one might try generating and modifying and AquaScript. This is a JavaScript-like language (extension?) for ADS. I have not investigated, it is possible it has the features for spooling a large result set without accumulating it all in memory.