Database

Here are the actual files available for download. Thanks to our database, you can see all the audio and voltage responses collected from various plants. Feel free to explore and download the data for your own analysis!

Filename Type Description Download
Loading files...
Technical overview

How the Database Works

Structure

A Minimal Relational Model

The database is built on SQLite — a single file (plantleaf.db) that requires no complex server infrastructure, making it well suited for small to medium scientific projects.

Internally, a single table (files) acts as a structured archive of metadata. From a database design perspective, this is a minimal relational model — one entity, no relationships.

Table Content

What Each Record Contains

Each record represents a file and stores:

Identificationid
Descriptive infofilename, description
Classificationfile_type

The database stores metadata only — not the experimental data itself.

Write — INSERT

File Upload

When a file is uploaded: format is validated, the file is saved to the filesystem, and a new record is created in the database.

Read — SELECT

File Listing

When the file list is requested, the files table is queried and results are ordered by upload date.

Update — UPDATE

Download Tracking

Each time a file is downloaded, the downloads counter is incremented in the record.

Delete — DELETE

File Removal

When a file is removed, it is deleted from the filesystem and its corresponding record is removed from the database.

Role in the system

What the Database Is Designed For

The database acts as a structured index of files, a download tracking system, and a data interface for the API. It follows a clear separation between data and metadata: real files live in the filesystem, while the database stores only information about them — reducing load and increasing efficiency.

It is not designed for complex analysis, but for fast access, simplicity, and reliability.

Structured index of files
Download tracking system
Data interface for the API
Fast access, simplicity, reliability