GRDC Trials

This project attempts to standardize how farming research data could be stored in a centralized database including:

• A schema for related tables
• A web application for uploading/inputting data
• An API server for the web app to insert data into the database

Table of Contents

• Development
  • Prerequisites
  • Local Server
  • Deployment
    • Docker
• Features

Development

Prerequisites

1. Node.js
2. Docker

Local Server

Start a PostgreSQL instance,

docker-compose down && docker-compose up -d

Generate typing for Prisma ORM,

npx prisma generate

Migrate database and create migration scripts,

cp ./.env.sample ./.env.local
yarn migrate:local                        

Start a web app on http://localhost:3000,

yarn dev

Deployment

Docker

Build,

docker build -t upload-interface .

Run,

docker run -it -p 3000:3000 upload-interface

Features

• Parse operational management excel file.
• Add subplot as a dropdown selection with confirmation.