...
Table of Contents | ||||
---|---|---|---|---|
|
With a web browser
DaCHS provides a web interface to visualize and query your published tap services.
Open http://127.0.0.1 (or http://127.0.0.1:<port_numer> if you don't use the port 80).
Note: Several links may not be not updated : refresh with ctr+F5, or even open a private session (Ctrl + Maj + P on Firefox).
You can click check service metadata by clicking on the numerous tables link to check service metadata.
Or, /and click on the link form-base ADQL (also accessible from the sidebar) and type an SQL query, for instance (replace "transplanet" by your actual service name):
select top 10 * from <service_name>transplanet.epn_core
With TOPCAT
TOPCAT is an interactive graphical viewer and editor for tabular data and can be used to visualize an query your published services. It is supported on all OS and can be downloaded here.
...
2/ On the new window, click on Query remote databases using sql-like language button on the icon menu:
3/ From the Select service tab, fill the TAP URL field (on the bottom) with http://127.0.0.1/__system__/tap/run/tap
(or http://127.0.0.1:<port_number>/__system__/tap/run/tap
) and click on Use service button:
...
4/ Take a look to the DaCHS tables: do you see the <service_name>.epn_core
table? Good. Now try to type an ADQL query on the bottom field, for example (again):
select top 10 * from
:<service_name>
transplanet
.epn_core
5/ On the new window, click on the last element of the left panel : you can now visualize the results of your query.
With PGAdmin
Installation
pgAdmin is a postgreSQL client, it aims to provide a graphical interface to view and manage your databases. We will use this tool on section Setting up an EPN-TAP service. If you don't want to install pgAdmin on you computer, you can however use psql commands instead.
First, install pgAdmin on your host machine. If you are on Debian based distribution:
sudo apt-get install pgadmin3 |
Compiled sources are also available for MacOS and Windows.
You need pgAdmin v. 1.20 or upper in order to deal with postgreSQL 9.4. Once installed, check pgdmin version (Help menu, About).
Configuration
Check for the gavo
user password by typing on the DaCHS server:
cat /var/gavo/etc/feed |
Now start pgAdmin, then click on Add a connection to a server (power socket icon) and fill the fields as the following:
Test | Production | Comment | |
---|---|---|---|
Name | DaCHS-test | DaCHS | As you want |
Host | 127.0.0.1:<port_number> | <<my_server>>.<<my_domain>> | |
TCP port | 5433 | ||
Service | leave empty | ||
Base maintenance | postgres | ||
Use name | gavoadmin | ||
password | ******* | Get it with the command above | |
save password | yes | As you want |
...
Usage
Now you should be able to see your database:
...
With the VESPA client
The VESPA client is a web site that allow you to query epn-tap services.
...