Client Case Study · Environmental science

Enhancing a Pesticide Product
Evaluation Database

For a pesticide science consultancy, we enhanced its subscription database of pesticide products, which offers hazard ratings, detailed hazard data and subscriber reviews. We added membership management, advanced search and an admin interface.

Engagement at a glance
3
Enhancements: members, search, admin
Tiers
Hazard rating for each product
Reviews
Subscribers read and write
Enhanced
An existing product, not a new build

Client not named. Figures describe the type of product, not usage or results.

What did Andolasoft do?

Andolasoft enhanced the subscription database of a pesticide science consultancy. The database gives each pesticide product a hazard tier rating with detailed human and environmental health hazard data behind it, and subscribers can read and write product reviews. Andolasoft added membership management, advanced search and an admin interface. The database itself was already in place.

Background

The client

The client

A pesticide science consultancy

An environmental consulting firm that does research, monitoring and expert consulting on pesticide chemistry and toxicology, including risk assessment and guidance on pesticide regulation and integrated pest management. The client is not named here.

The brief

The need

The need

Keep a subscription product growing

The consultancy already offered a subscription database of pesticide products. We worked with it on enhancements that help members find products and help the consultancy manage the product and its members.

The product

What the database offers

The product

A product evaluation database

A web database of pesticide products. Each product has a hazard tier rating from 1 to 3, with detailed information behind it on human and environmental health hazards, water pollution potential, and environmental fate. Subscribers can also read and write product reviews.

The solution

What we added

Members

Membership management

The consultancy manages its subscribers and their access through the product.

Finding products

Advanced search

Members can search the database in more detail to find the products they are looking for.

Administration

An admin interface

Staff at the consultancy manage the product through an admin interface.

Technology

What it is built with

Technology

Built with

CakePHP, MySQL, AWS and Bootstrap.

Next

Where a database like this can go

Where it can go

More views and more for members

Databases like this tend to grow in a few directions: more views of the data, charts, and ways for members to keep track of the products they use. We scope each addition with the client, one step at a time.

Need a subscription database or member portal?

Tell us what your members need to look up and how you want to manage access, and we will scope a first version. You will hear back from a solutions architect within one business day.

We can sign an NDA before the first technical conversation.