corvus

corvus is a measurement stations managing application. The app is built with the {shiny} package and uses a PostgreSQL database with the TimescaleDB extension. The app is designed to manage measurement stations and their time series data. The app allows to insert, update and delete data. The app also allows to visualize the data with different plots, make correction and validation.

Installation

Install package from GitHub

remotes::install_github("https://github.com/gehco-univ-tours/corvus.git")

Install PostgreSQL timescaleDB database

• Install PostreSQL lastest version compatible with TimescaleDB extension. See the version compatibility in TimescaleDB install documentation for your operating system. The PostgreSQL version for each operating system are here.
• Install TimescaleDB extension following the installation documentation.
• With Docker you can follow this guide.
  • The app has been tested with the latest-pg16 version of the TimescaleDB Docker timescale/timescaledb-ha image.
  • docker-compose.yml example :

timescaledb:
    image: timescale/timescaledb-ha:pg16
    container_name: timescaledb
    ports:
      - "5434:5432"
    volumes:
      - ./timescaledb_data:/var/lib/postgresql/data
    environment:
      - POSTGRES_PASSWORD=my_password
      - POSTGRES_DB=my_first_db
      - POSTGRES_USER=my_user

Create database

• Create an empty database with TimescaleDB extension.
• The database structure :
• Create database infrastructure with the SQL script in the inst/sql folder or in the package with the following command:

library(corvus)
system.file("sql", "db_model_pg_timescale.sql", package = "corvus") # file to create an empty database
system.file("sql", "db_data_example.sql", package = "corvus") # file to add example data

Run app

corvus::run_app()

Insert data

How to cite

Manière, L. (2024). corvus (Version 0.0.0.9000) [Computer software]. https://github.com/gehco-univ-tours/corvus

Licence

This program is released under the GNU Public License v3.