Overview
Mathesar is an open source software project to help users store, organise, visualise, and collaborate on data. Mathesar's goal is to provide an intuitive user experience for non-technical users. Mathesar directly operates on PostgreSQL databases, which gives it the flexibility to be interoperable with thousands of other existing tools and applications.
Problem statement
Mathesar needed a design spec for formula columns. Formula columns are the type of columns in database that are either generated using other columns or static numbers processed via a formula. These columns are basically for users to derive at certain conclusions or visualise the patterns using simple math formulas.
My contributions
I single handedly worked on the spec. I was able to get a lot of context by available documentation and some help from Mathesar's senior designer. Building a spec and getting it reviewed is done through Github. This involved a lot of independent design which pushed me to brainstorm variety of possibilities and edge cases.
