PostgreSQL Hub
Find all PostgreSQL resources here
Popular Stories
Authorization
GraphQL Authorization with Hasura: How to prevent mutations after a time interval
PostgreSQL
Comparison of Managed PostgreSQL Providers: AWS RDS vs Google Cloud SQL vs Azure PostgreSQL
PostgreSQL
Top PostgreSQL Flavours and Extensions that work with Hasura
PostgreSQL
Things you wish you knew about PostgreSQL for building an app
All Stories
GraphQL
Building a GraphQL to SQL Compiler on Postgres, MS SQL and MySQL
The release of Hasura 2.0 included one of the most exciting features to date - multiple database backends, and in particular, support for our first new backend, Microsoft SQL Server.
On the face of it, this probably seems like a relatively straightforward change.
Postgres
Query hierarchical data structures on Hasura with Postgres ltree
Introducing `ltree` operator support in Hasura
This post introduces support in Hasura 2.0 for queries on hierarchical data structures, with the help of Postgres `ltree` operators. It includes several examples, so we recommend that you create a new project in Hasura Cloud to try them out.
Postgres
Using Postgres for Cron
How to use Postgres and your application server to build a flexible and robust cron system ourselves with a few lines of code!
Postgres
Building a UI for PostgreSQL Database Migrations
In this post we look back at the journey of building a UI for generating database migrations with a focus on ease of use, developer experience, productivity and the design choices we made to build this system.
PostgreSQL
The pros and cons of updatable views in PostgreSQL
In this post, I will cover the following:
What are updatable views,
How Hasura used updatable views,
Key problems with updatable views (from a Hasura point of view) and
Moving away from updatable views
GraphQL
Blazing Fast GraphQL Execution with Query Caching & Postgres Prepared Statements
In this post, we will look at important performance considerations for building apps at scale and how we leveraged PostgreSQL query caching and prepared statements to improve performance.
GraphQL
Build react-static sites using GraphQL on Postgres
Source data from your existing postgres database for your react-static site using GraphQL APIs. Instant setup. Tutorial/boilerplate.
GraphQL
Working with schemaless data using GraphQL on Postgres
Exploit Postgres schemaless JSON types in your GraphQL queries using the open-source Hasura GraphQL Engine.
GraphQL
GraphQL and Tree Data Structures with Postgres on Hasura GraphQL engine
Modelling a tree data structure on postgres and using GraphQL to add and get data from the tree.
Tutorials
The fastest way to get started with Hasura is to try out one of our many online tutorials. It’s free!
