solved

The highest praise a user interface can receive is to be called intuitive. The users don’t have to think about how to use the interface, they just execute the task at hand. What’s not to like about that? It is a worthy goal, but one that should be approached with caution. Triggering an intuitive response […]

GraphQL was created in 2012 and open-sourced by Facebook in 2015 to relieve issues with the interfaces of the time, particularly for mobile devices with limited or flaky internet connections. Now managed by a foundation, GraphQL continues to provide an interface that allows making a single call that aggregates statically typed data from multiple resources […]

In the first post of this series, we explained why you absolutely need to use jsonb columns in the PostgreSQL tables right now, and mildly chided you if you aren’t already. In the second post of this series, we demonstrated how to use triggers and constraints to make one read/write table with JSON data and […]

In Part 1 we explained why you absolutely need JSONb columns in your PostgreSQL tables, and how they simplify the expression of complex data, including complex references and relationships. In this article, we’ll dive deeper into ways to use tables with JSONb columns, discussing constraints and triggers to guarantee data integrity, and show how to […]