replext_pgsql {npboottprm}

Replext Simulation Shiny App with Database Integration

Description

This application replicates and extends the simulation results from the paper by Dwivedi et al. (2017), now with added functionality to interact with a PostgreSQL database. The app includes a user interface for selecting simulation parameters and a server logic to process the simulation and handle user interactions, including saving and retrieving data from a database.

Usage

replext_pgsql(dbname, datatable, host, port, user, password)

Arguments

dbname

The name of the PostgreSQL database to connect to.

datatable

The name of the table in the database where the simulation results will be stored and retrieved.

host

The host address of the PostgreSQL database.

port

The port number for the PostgreSQL database connection.

user

The username for accessing the PostgreSQL database.

password

The password for the specified user to access the PostgreSQL database.

Details

The app's user interface consists of:

• A dropdown menu to select a cell block for the simulation, which is populated using the getCellBlocks function.

• Dynamic UI elements for inputting simulation parameters, generated based on the selected cell block.

• Buttons to run the simulation and submit the results to a PostgreSQL database.

• A table to display the simulation results and previously saved responses.

• A download button to export all responses as a CSV file.

The server logic of the app handles:

• Rendering the dynamic UI elements for simulation parameters.

• Observing the simulation run event and processing the simulation using the runSimulation function.

• Rendering a table to display the simulation results.

• Handling the submission of results and storing them in a PostgreSQL database.

• Loading existing responses from the database.

• Downloading responses as a CSV file.

Value

A Shiny app object which can be run to start the application.

References

Dwivedi AK, Mallawaarachchi I, Alvarado LA. Analysis of small sample size studies using nonparametric bootstrap test with pooled resampling method. Stat Med. 2017 Jun 30;36(14):2187-2205. doi: 10.1002/sim.7263. Epub 2017 Mar 9. PMID: 28276584.

Examples

if (interactive()) {
  replext_pgsql(
    dbname = "your_db_name",
    datatable = "your_data_table",
    host = "localhost",
    port = 5432,
    user = "your_username",
    password = "your_password"
  )
}