May 2023 Summaries

Protex AI, an Ireland-based company, utilizes computer vision to enhance workplace health and safety by enabling proactive decision-making. They build on the Hasura platform while ensuring data privacy through granular role-based authorization. The challenge lies in preventing accidents and fatalities despite ongoing investments in best practices, equipment, and training across various industries. Protex AI's solution analyzes CCTV video feeds to identify predictors of risk without violating privacy laws. Hasura's instant API capabilities have been instrumental in helping Protex AI build fast and focus on its core mission: making the world a safer place.

The text discusses how the company Equi uses Hasura Self-Hosted for its backend service to increase productivity. It explains that managing configuration with multiple developers can be challenging and provides a solution using Docker Compose, a sidecar container called 'hasurawatcher', and inotify scripts. These automations ensure metadata changes from remote are imported and make it easier to export and commit metadata changes. The author also mentions the benefits of this setup for development workflow and emphasizes its importance in building powerful applications with confidence.

This post discusses the use of role-based access control (RBAC) in managing access control for databases, specifically using Hasura's RBAC system with Snowflake data warehouse. RBAC is a security model that controls access to resources based on user roles and their permissions. It offers advantages such as scalability, simplicity, granularity, and flexibility. Hasura's RBAC system provides additional benefits like integrations, ease of use, automation, and performance. The example demonstrates how to set up Hasura Cloud with Snowflake data warehouse using JDBC and RBAC. It involves creating a new project, adding a new data source, tracking the Snowflake tables, setting up RBAC, and testing the GraphQL API. In conclusion, the combination of Hasura Cloud, Snowflake, and JDBC offers an effective way to build scalable, secure, and performant GraphQL APIs on top of a powerful data warehouse. With Hasura's RBAC systems, developers can ensure that their APIs are secure and compliant while providing rich, flexible access to data.

Hasura has announced support for Instant GraphQL APIs on top of MySQL, MariaDB, and Oracle. This enables users to point Hasura to existing or new MySQL databases configured to work with WordPress installations. By leveraging this feature, development teams can use familiar editorial workflow tools while accessing the latest software development trends. With Hasura's support for MySQL, users can now get Instant GraphQL and REST APIs for querying their blog posts and any properties in WordPress. Additionally, they can run WordPress as a Headless CMS, replace plugin-style installations like WPGraphQL with Hasura, configure granular access control rules, join this WordPress data with other databases, and customize the API tailored to developer needs.

Hasura introduces Dynamic Routing for data sources, allowing users to define multiple database connection configurations and routing logic. This feature enables efficient use of databases, better performance, and reduced infrastructure costs. It supports various use cases such as having multiple (database) users, using a per-database multi-tenant model, and advanced routing logic. Dynamic Routing enhances security by allowing control over access to databases on a per-request basis, implementing role-based access control, isolating sensitive data, and integrating with third-party IAM solutions.

Hasura has introduced instant APIs (GraphQL and REST) for MySQL, MariaDB, and Oracle databases with built-in production-ready features. The new data connectors allow users to get an API server running within days by reducing the time taken to build a data access layer that provides an interface between applications and databases. These connectors can be used in various scenarios such as modernizing legacy applications, building new applications on existing data, and combining data from multiple sources. Hasura's data connectors have been tested and validated on several cloud databases, including Amazon RDS, Google Cloud SQL, Digital Ocean, and SkySQL. The company has also implemented features to ensure the security, scalability, and reliability of applications in production.