November 2022 Summaries

In November, Hasura introduced new integrations for CockroachDB and Amazon Athena as beta features in Hasura v2.15. Support for Snowflake is also expected soon. The Enterprise GraphQL Conference featured talks from LinkedIn, Optum, and Goldman Sachs on how they use GraphQL to tackle data access challenges. A new video tutorial series was launched on building a full-stack food ordering app with Hasura, Next.js, and Vercel. Hasura is heading to AWS re:Invent in Las Vegas. Product updates include native database integration for CockroachDB, Hasura GraphQL Data Connector for Amazon Athena, two new regions on GCP, enhanced API security with batch limits, action response transforms on console, and more. Community events and content were also shared.

In this blog post, the author discusses new features of Next.js version 13, including Nested Layouts, Data Fetching, Streaming and Suspense, and Client and Server Components. The author demonstrates these features by building a mini e-commerce store using Hasura GraphQL for realtime features such as Streaming Subscriptions. They also cover the setup process for Next.js, GraphQL Code Generator, graphql-request, and nested layouts. Finally, they discuss how to create client components with logic on the browser and integrate them with server components.

This guide demonstrates how to write your own Hasura actions using Netlify functions. It covers the process in three parts: creating a function in an app, defining the functions with logic, and adding the function to Hasura using Actions. The text also explains what Hasura actions and Netlify functions are, as well as their benefits. Additionally, it provides examples of how to handle errors and customize permissions for actions.

Hasura will be attending AWS re:Invent from November 28th to December 2nd in Las Vegas, where they have planned several activities for attendees. These include the Hasura Challenge at the AWS Jam Lounge, a Happy Hour event with partners Cockroach Labs and Launch Darkly, a keynote by Dr. Werner Vogels, bookable demos with Hasura experts, breakout sessions on distributed applications and iOS-native app development, and chalk talks on API security. Attendees can also visit the Hasura booth (#2251) to meet the team and learn about their modern data-access engine for accelerating API and application development.

This article discusses the top serverless PostgreSQL providers. Neon offers a fully-managed serverless Postgres service with benefits such as auto-scaling and branching. Amazon Aurora is another fully-managed serverless database service compatible with Postgres, offering 3X more throughput than base PostgreSQL. Crunchy provides a high-availability Postgres database with disaster recovery and automatic failover. CitusDB extends and transforms the base PostgreSQL into a distributed database, allowing for parallelism and data distribution. Bit.io claims to be the fastest way to get a serverless Postgres database, offering automatic scaling and security features.

CockroachDB and Hasura have released a beta version of Instant GraphQL for CockroachDB in v2.15.0, available in both open source and cloud free versions. The combined solution significantly reduces the time and effort required to build or migrate to a high availability distributed database architecture with an enterprise-grade data access layer that includes GraphQL & REST APIs, Declarative Role Based Authorization, Advanced Security, and Performance features such as rate limiting, allow lists, and caching. CockroachDB is a distributed SQL database built using a strongly-consistent key-value store, while Hasura's intuitive tools and documentation make it easy to set up and connect to CockroachDB. The auto-generated GraphQL schemas and resolvers save time on development and maintenance, as developers no longer need to author more data access APIs or modify the code every time there is a database change.

Amazon Athena's GraphQL Data Connector for Hasura has been released in beta. This integration allows users to query against Amazon Athena using Hasura. Currently, the connector is available for read-only queries and only for Hasura Enterprise Edition (EE) and all Hasura Cloud customers. Once it moves to General Availability (GA), it will be exclusive to EE and Hasura Cloud Enterprise plans. The combination of Hasura and Amazon Athena enables users to analyze unstructured, semi-structured, and structured data stored in S3 using ANSI SQL queries. This integration extends the capabilities of Athena to the entire data tier by providing a seamless GraphQL API for disparate data sources.

Hasura has announced new native database integrations with CockroachDB and Amazon Athena. These additions expand Hasura's instant GraphQL/REST API capabilities to more data sources, helping developers build applications faster. The CockroachDB integration enables users to generate APIs for accessing their CockroachDB data, while the Amazon Athena integration allows users to query and analyze data in Amazon S3 using standard SQL. A Snowflake integration is also expected soon.

PostgreSQL is a popular and reliable open-source relational database management system. psql is an interface that allows users to interact with Postgres databases through the terminal. This article covers essential psql commands and flags, including connecting to a database, listing all available databases, switching between databases, describing tables, listing schemas, viewing user roles, saving query results to files, running commands from files, and quitting psql. Additionally, it introduces Hasura as an option for generating APIs for data access on Postgres.