The most important Hasura newsletter of the year!

[Hasura][Hasura]() Hi there! And just like that, we're at the end of 2021 😲 In this end-of-the-year newsletter, we have curated the biggest features we launched, the videos and blogposts that we produced that were most loved by you all and highlights from the company & our community! If you want to catch up on all the product news from last month, check out [this post](). Let’s get you caught up with all the highlights from 2021! [news.png] 🌐 We’ve grown to 103 people spread across 17 countries! [features.png] ✨ The Hasura GraphQL Engine has reached 24K+ stars on Github 🚀 Hasura has over 400M Docker Pulls - We shipped [Hasura 2.0]()! It is our biggest release in the last few years and it included multiple DB Support, auto-generated REST APIs, Remote Schema Permissions, and many more features. We also added support for BigQuery & SQL Server. - We've also made it easier to connect REST endpoints as data sources! Action Transforms and Event Transforms let you connect REST APIs to Hasura with [low-code simplicity](). - You can find templates, guides, and best practices for connecting data sources to Hasura at the new [Hasura Data Hub](). It includes example Airtable connectors, Firebase Auth examples, email triggers, and more! - You asked - we listened. We've added one of our most requested features: [Inherited Roles]() let you combine permissions from multiple singular roles and make GraphQL queries in Hasura using the new combined role. - We added a whole lot of [security features]() to Hasura Cloud including Node Limit, GraphQL Request Timeout & Disabling GraphQL Introspection per role. - Our two most popular features now go together! Increasing the number of data sources that can be joined using Hasura, you can now create a [remote schema relationship]() from a computed field! - We've achieved [SOC2 Type 2 Certification]() for Hasura Cloud. - Make sure you upgrade to the new [Hasura CLI Config v3](). It comes with improved workflows for users with large metadata and support for multiple data sources. You can now split table.yaml into individual files per table making collaboration and reviews easier! - We also added support for column comparison operators: You can now [compare columns]() across different, related tables in permission boolean expressions. - M1 more thing! The official Hasura docker images are compatible with ARM architecture and run on Apple silicon. You can check out all the product and feature announcements from 2021 [here](). [favs.png] Must-Read Articles Improve your Hasura Workflow - Migrate your Hasura project from [OSS to Hasura Cloud]() with our step-by-step guide. - From [local dev, through staging and to production]() - here’s how to set up your Hasura project through your entire development lifecycle. All thing AuthZ - Restrict GraphQL mutations after a [time interval]() (prevent users from predicting who will win after an event starts). - Use Hasura to build a [google-drive style]() hierarchical auth system. - Model an org-based, team-based or tenant-based [permission system]() in Hasura. And a little AuthN - Create an external AuthN service using [Django Graphene]() and mesh it with Hasura. - If you’re a Next.js dev, here’s how you can [add JWT AuthN]() to your Hasura app with NextAuth. Level-up your Postgres Use - A few things you should know [before you build your app]() with Postgres. - Stop using independent components for cron, [use Postgres instead](). - Here’s how you can add [multiple Postgres dbs]() to Hasura. - We added support for the [Postgres ‘ltree’ Operator](). You can use it for queries on hierarchical data structures in Hasura. - Using JS in your app? Learn how to map [Postgres types to JavaScript types]() via GraphQL and Hasura. - Pick the best [managed Postgres provider]() for your needs. - Here’s a guide to the [different Postgres flavours]() and extensions that work with Hasura and their use-cases. Listicles Galore - We collected a list of our favourite [open-source GraphQL projects]() and [IDE]()s. - If you’re a frontend developer, check out our list of GraphQL resources for [Vue]() & [Next](). The low-down on Low-Code - Here’s an overview of how Hasura fits into the [low-code ecosystem](). - Want to start using Hasura with your favourite low-code tool? We wrote a series of guides on how to build apps using [Notion](), [Bubble](), [Draftbit](), [Retool](), and [Microsoft Power Automate]() with Hasura. How we Engineer @ Hasura - While Hasura is a “GraphQL-to-SQL compiler”, adding support for MS SQL and MySQL came with a lot of technical challenges. Here’s [how we overcame them](). - Continuing with our multiple db story - here’s how [TypeScript’s template literal]() types played a key role in implementing this feature. - We migrated from CircleCI to Buildkite - here’s [what we learnt](). Honorable Mentions - Still not sure about the difference between Hasura, Apollo and Prisma 2? Check out [this explainer](). - How to identify and solve [common GraphQL Errors](). - Our marketing-ops team used Hasura’s recent BigQuery support to [build a realtime lead-to-account matching solution]() with Hasura, Zapier & SalesForce. - We compared the pros and cons of the most popular [FaaS]() or [serverless](). Now, the Videos 🎉We published over 180 videos on [YouTube]() in 2021. Make sure to hit that subscribe button 😉! Workshops - If you work with TypeScript, don’t miss our workshop on [building fullstack apps with NestJS]() - one of our most popular workshops of the year! - Learn how you can apply any schema or metadata changes automatically [with a simple git push]() to a configured branch on a GitHub repo using Hasura Cloud. - Build a powerful backend for your JAMStack apps using [Hasura and Strapi](). Webinars - Use Hasura’s many monitoring & observability features to [debug & analyze query performance](). - Learn how Hasura [optimizes your API’s performance](). - [Secure your GraphQL API]() against injection attacks, DDoS attacks, excessive data exposure, and more. The Community Call - We just wrapped up the [last Community Call]() of 2021. We covered the features I mentioned earlier, along with an early look at what we’re currently working on including streaming subscriptions and public GraphiQL. Keep an eye out for next month’s call [here](), and find all our community calls on this [playlist](). The Data & API Show ⭐ We launched a brand new live-streaming show this year. Join us every Tuesday at 9AM PT on [YouTube](). Highlights - Building Admin interfaces with [React Admin and Hasura](). - Introducing the Hasura [SUPER App](). - Type Safety with [ReScript & GraphQL](). - Catch all the previous episodes [here](). Conference Wrap Up ❤ Our favourite Hasura & GraphQL conference talks from 2021 - Explore the benefits of [federating data services]() to provide a GraphQL API instead of trying to federate across GraphQL services. - Learn how to build an advanced model level [authorization system]() for GraphQL. - Dan Schafer (GraphQL co-founder) joined Tanmai to discuss the [State of GraphQL](). - What does [Schema Stitching]() look like in 2021? - Tanmai sat down with Guillermo Rauch (Vercel’s CEO) to talk about [what enterprises could learn]() from startup tech stacks and dev methodologies. - A look at the role Hasura[plays in the enterprise](). - If you’re an architect building an application with Hasura, check out [this guide.]() - Here’s how we used Hasura to build [Hasura Cloud](). - The Data Mesh has a lot of potential to accelerate developer productivity in Enterprises. Here’s an [introduction to the concept of the Data Mesh]() and all the opportunities GraphQL unlocks within it. - Zhamak Dehghani (Data Mesh founder) joined Tanmai to talk [about GraphQL and the Data Mesh](). [learn.png] 🎉 We added 6 new courses & 2 new languages this year New Frontend Courses - Learn how to use GraphQL with [ReScript]() & [Svelte](). Advanced Hasura - Already familiar with Hasura? This [1-hour course]() will teach you everything you need to know to optimize your application for production. Learn Databases - We’ve created introductory courses for [Postgres](), [SQL Server]() and [MySQL]() for frontend developers interested in building fullstack apps New Languages - Our most popular courses are now available in Mandarin ([GraphQL basics]() & [Hasura basics]()) and Japanese ([GraphQL basics]())! Spanish is coming soon. [community.png] 🚀 Our Discord has grown to 10K+ users. Join them [here]()! ⭐ Over 100 open source contributions ❤ 8 Hasura Users presented at our Monthly Community Call in 2021. Have something to share? Apply [here](). What users are building with Hasura - [Pipe, one of the fastest-growing fintech startups in the world, used Hasura to launch and scale with just 12 engineers](). - [How Cajoo replaced Shopify with Hasura and React in just 4 weeks](). - [MachineMetrics used Hasura to increase dev velocity by 10x](). - [Here’s how Runn migrated from an RoR backend to Hasura](). - [How Hasura is being used to modernize Govt. EdTech in India](). - [The United States House of Representatives modernized a 30-year-old stack with GraphQL, Hasura & .Net](). - [How Nexlab Digitized Daikin Vietnam’s AC servicing business unit using Hasura](). - [Brave Care, a YC-backed healthcare startup, is using Hasura to build and scale rapidly.]() - [Pulley cut development time by 50% with Hasura](). - [Building enterprise apps for McDonald's and Coca-Cola using Vercel & Hasura](). Tools built by our community - [nestjs-hasura]() built by Jesse Carter is a deep integration with Hasura that makes it easy to incorporate business logic and event processing with Hasura. - [qik-trak]() by Chris Nurse applies intuitive names to your tables and relationships and provides a no-touch setup process for automated tracking settings. - [worker-auth-providers]() by Subhendu Kundu is an open-source provider to make authentication easy with workers. It comes with a fast & lightweight script that doesn't require a lot of dependencies. - [fastify-hasura]() is a plugin that makes combining Hasura and Fastify effortless with features like routes for Hasura events, actions, and cron jobs, Fastify decorator over [graphql-request]() to easily request Hasura graphql endpoint, & more! - [next-relay-bridge]() by Daniel Cortes makes it easy to server-side render Next.js pages that rely on Relay data. - Last but not least, [awesome-hasura]() is an excellent collection of Hasura tools, resources and lots more! Articles / Videos published by our community - If someone ever messages you and asks “What is Hasura?” Send them Fireship’s fantastic [1.5 min explainer](). - Samuel Umoren wrote [a blogpost]() on how to handle GraphQL API Authentication using Auth0 with Hasura Actions. - Rudolph Jakob Heuser [explained]() how to implement complex Hasura permissions via Postgres views. [recs.png] The Best Technical Articles We Read This Year We asked the folks at Hasura what the best technical article/video they came across this year was. Here are their answers: Using WebSockets with React Query A well written [tutorial]() on working with Web sockets in React Query, a great front-end utility that pairs really well with Hasura. Suggested by Jesse Martin. How I cut GTA Online loading times by 70% It describes how a single person [solved a problem]() affecting millions of players of a AAA video game, by carefully and methodically profiling reverse engineering the game, finding the issue, and fixing it. All that without access to the source code! At the very least, it gave me some perspective - computers can be understood, and programs can be fixed. Being patient and using a methodological approach is very powerful. Suggested by Gil Mizrahi The Symmetric Interaction Calculus A [mind blowing derivation]() of dual variations of the abstract algorithm and interaction calculus by Victor Maia. Suggested by Lyndon Maydwell. Coding Adventure: Ant and Slime Simulations A very [cool video]() demonstrating some experimental biologically inspired heuristic solutions to the traveling salesman problem. Suggested by Lyndon Maydwell. Individuals matter [This article]() is about how treating people as interchangeable, as if it doesn't matter who is doing what, as if individuals don't matter, is a common mistake in engineering teams' management. I could relate to the article since we always think that any person can take up any kind of work -- we tend to forget that some people are experts at some specific things. Suggested by Shahidh K Muhhammed. Jobs Jobs @ Hasura We are hiring for several roles across engineering, product, marketing, sales and more. Please look at our [careers page]() if you’re interested or know someone who might be. We also have a [jobs channel]() on our Discord server where the community posts relevant job openings in case you’re interested. --------------------------------------------------------------- That’s it from us for 2021. I hope you had a fantastic year and that all your loved ones are keeping safe. Stay tuned… We’ve got big news coming soon!! Best, Rajoshi [GitHub]() [Twitter]() [Discord]() [YouTube]() [LinkedIn]() Hasura, 355 Bryant Street, Suite 403, San Francisco CA 94107 [Unsubscribe]() | [Manage preference]()