Swift Project

SpeakEasel Database

Using custom software to create JSON objects for Realm Swift & MongoDB Atlas

Industry:

Technology

Platform:

MacOS

Location:

USA

PROJECT OVERVIEW

SUMMARY

While developing the language learning app SpeakEasel, I realized that I needed a custom solution to create documents for our database

A custom software built for SpeakEasel’s database management, crafted to reduce human error in the creation of JSON objects for Realm & MongoDB Atlas.

Every individual word within SpeakEasel requires it’s own document, which contains 5-15 different data points. Many of these must be handwritten, or otherwise require a human to create the data sets.

This database software automates JSON object creation, and has several built in features to catch human errors as they happen.

As a solo developer taking on a large project, this was essential for SpeakEasel development. My time had been bottlenecked handwriting (and correcting) documents for our database, which took away time from the actual app itself. Although it was a large time investment to create dedicated software for our database, the return on my available time has been tenfold.

FEATURES

01/

Created user data funnels, so that there could be no mismatching data categories

02/

Automated data creation where possible, such as the counters associated with nouns (i.e. a herd of buffalo)

03/

Added auto-detection of common typing errors, such as including conjugations for verb stems (i.e. writing 食べる instead of 食べ)

04/

Developed a human-centric way to conceptualize data creation, particularly for the creation of sentence documents

05/

Automatic hiragana to romaji transliteration, with notification to the user when there is a risk automation error (i.e. は can transliterate to ha or wa, depending on context)

06/

Responsive object completion checklist. Users can only submit for the JSON object to be completed when all required fields have been entered, and the requirements are adaptive to what the user selects

MY ROLE

Developer. A solo project from concept to creation.

RESPONSIBILITIES

💭 Design Thinking Process

🧐 Research

🌱 Usability Studies

💻 Data Architecture

☕︎ Full-stack Development

💡 Database Creation & Management