Querying MySQL programmatically
To connect to the MySQL programmatic endpoint, you need a MySQL client (command line, graphical or program library) and SSH installed on your machine.
To obtain access, please send us your public key as described here.
When we contact you back, you will be able to setup an SSH tunnel with the following command:
ssh -L 3306:web.ghtorrent.org:3306 firstname.lastname@example.org. Keep in mind that no shell will be allocated in the open SSH session.
You will then be able to connect to our server using the command:
mysql -u ght -h 127.0.0.1 ghtorrent(user name: ght, no password, database: ghtorrent).
Here is an example session:
Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1004 Server version: 5.5.5-10.1.11-MariaDB-1~wily mariadb.org binary distribution
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show tables; +-----------------------+ | Tables_in_ghtorrent | +-----------------------+ | commit_comments | [...] | users | | watchers | +-----------------------+ 21 rows in set (0.20 sec)
Have a look here.
Things to keep in mind
The hosting machine, while powerful, is not capable of processing the data very quickly.
Other people may be using the machine as well. Make sure that you do not run very heavy queries. It is better to run many small queries (e.g. in a loop) than aggregation queries. Make sure you only query on indexed fields.
Queries running in excess of 100 seconds are killed without any warning.
At any time the machine may become unavailable.
The data is provided in kind to help other people to do research with Please do not abuse the service.
The data is offered as is without any explicit or implicit quality or service guarantee from our part.
All operations are logged for security purposes.