December 2018 Summaries

The article by Sandip in Smashing Magazine provides an insightful guide on building real-time apps using GraphQL Subscriptions with Postgres. It covers the challenges involved and how emerging tooling is addressing them with simple, easy to understand solutions. This post is particularly useful for beginners or those transitioning into fullstack development. The author also discusses the benefits of GraphQL over REST, making it a valuable resource for anyone interested in data products and chatbot frontends.

The Hasura GraphQL Engine has been optimized for performance and scalability. It processes incoming requests through stages such as parsing, validation, conversion to SQL, execution by Postgres, and returning JSON responses. To further improve the performance of GraphQL queries, a recent version of Hasura introduced an API that outputs generated SQL along with the execution plan prepared by Postgres' Explain command. This feature helps identify performance bottlenecks and suggests improvements such as adding indexes to reduce latency. The team plans to make insights from Explain more actionable and possibly automate database admin tasks for developers in future iterations.