3 Ways to use the database

Depending on what you want to do (and, depending on your user rights, you are allowed to do) there are several ways to access the database.

Most of the time you will start at the webpage: http://woodcar.boku.ac.at/ where you have all possible access-options listed:

  • Access views on either solid, wood_based or adhesive separately. You should consider this if you just want to review or download data, but don’t want to do any administrative tasks, data upload or SQL queries. This option is further described in this section.

  • Log in through the DB Admin application. This is the best option if you want to do more advanced data filtering, administrative tasks, data uploads etc. You find more information in this section.

  • Use a different and suitable client side front-end application such as SQL Workbench for cases when you want do download any stored files in the database (project report, measurement files etc.) as the upper two only allow to download the hexadecimal representation of those files which need further conversation to be opened again.

The first two run on a server and therefore you need only a web browser to access, using SQL Workbench requires to install software on your PC and to set up a direct database connection.

Future plans include also an interactive application for visual data exploration, therefore there will also be another option appearing offering the link to:

  • shiny applications

It’s also possible to connect to the database with various scientific programming languages such as R, Matlab, Python etc. - this manual gives only a rough guide as it’s expected that users of those tools find good ressources/documentation on their own anyway.