← Back to Projects

Lab Experiment Tracker

Innovative web application to centralize and streamline lab data, moving beyond inefficient spreadsheets.

Node.js SQLAlchemy Flask React Tailwind CSS SQLite
lab experiment tracker screenshot

The Problem

In many research environments, experimental data is scattered across multiple spreadsheets. This 'spreadsheet-based method' is often manual, error-prone, and makes it incredibly difficult to query, analyze, or collaborate on data effectively. I saw a need for a centralized, reliable system that researchers could trust.

My Solution

To solve this, I designed and built the Lab Experiment Tracker, a full-stack web application. It provides a clean, simple web interface for researchers to log experiment parameters, upload results, and track progress. The entire system is backed by a SQLite database, ensuring data integrity and making analysis simple.

Key Features

Writing new experiments

Writing new experiments

Create and initialize new experiments with an intuitive interface. Organize experiments by date, status, and project type for easy tracking and management.

Logging experimental data

Logging experimental data

Efficiently log and update experimental data in real-time. Track parameters, results, and observations with a clean, organized interface that replaces clunky spreadsheets.

Group membership

Group membership

Share experiments with your lab members. Collaborate effectively by viewing team progress and sharing insights across your research lab.

View member experiments

View member experiments

Browse and filter experiments from all group members. Collaborate effectively by viewing team progress and sharing insights across your research lab.

Tech Stack

Backend

SQLAlchemy Flask

Frontend

React Tailwind CSS HTML CSS JavaScript

Database

SQLite

Deployment

Flask REST API GCP

Potential Impact & Value

This system can help researchers track their experiments and data more efficiently, allowing them to focus on analysis and interpretation of data instead of manually tracking data in spreadsheets.