Graph-Based Ceramics

The article discusses the challenges of managing ceramic glazes and combinations in a kiln and the author's journey in developing an app to streamline this process. Initially considering Firebase for its ease of use, the author ultimately opts for a graph-based database like Instant due to its ability to handle complex relationships between glazes, combinations, and ceramic pieces more efficiently. The article delves into the technical aspects of data modeling using SQL in Supabase and Postgres, highlighting the benefits and drawbacks of each approach. It also touches upon the advantages of Firebase in terms of optimistic updates, real-time subscriptions, and offline support, which are crucial for mobile applications. The comparison concludes with the exploration of Instant's InstaQL querying language, which simplifies data retrieval and management without the need for complex configurations.