zkuralt/chilobiobase

ChiloBioBase is a shinydashboard interface for database of Chilopoda based on MariaDB.

ChiloBioBase 2.0

In order for this app to work you need installed and configured MariaDB on your computer and a creds.R file with structure displayed below in your working directory.

creds.R

con <- dbConnect(RMariaDB::MariaDB(),  
                 username = "user",  
                 dbname = "database",  
                 password = "password",  
                 host = "00.000.000.00")

Current structure of the database is displayed below.
Plot was made in MySQL Workbench 6.3 CE.

chilobiobase's Issues

Finalise models.R layout

The models layout needs some work.

Querying database is not working yet

• Quick query by species
• Quick query by location
• Limit statements for custom querying (such as DROP, REMOVE etc.)

Refresh summary when new record is submitted

Also refresh other stuff.

Quick filtering at "About database" tab

Currently only filtering by altitude is working. We could also add filtering by species and habitat type.

• Filtering by species
• Filtering by habitat type

Transfer specimen option

If specimen is moved to different collection / box. It would be best to implement this into records browser.

Add label generator

Automatically generate labels (for printing) for specimens.

Build Records browser tab

Something like that.

Data input is not working yet

• Survey data input
• Photo material input
• Specimen remarks
• Add "cf." option
• Collection and box input
• move Stage to morphology input

Update readme.md

"Add data" to tables option

In tables tab, option for adding data to the tables should be added. I was thinking of displaying all tables in boxes and when user wants to add data to the table via "Add data" button an input form for that table appears.