👋New product launches in July! Read our roundup

PostgreSQL

PostgreSQL, is a free and open-source relational database management system emphasizing extensibility and technical standards compliance.

Comparison of Managed PostgreSQL Providers: AWS RDS vs Google Cloud SQL vs Azure PostgreSQL

We’ll be talking about managed Postgres cloud providers and measure them on various parameters like High Availability, Auto Scaling, Versions and Extensions support, Automated Backups, Monitoring and Metrics, Security and finally the costs.

Get monthly product updates

Sign up for full access to our community highlights & new features.

Join Hasura's Technical Writer Program

Turn your ideas into guides, tutorials, reference architectures, and help the larger community of Hasura developers.

Top PostgreSQL Flavours and Extensions that work with Hasura

In this post, we will look at the different flavours and extensions of Postgres that cater to specific use cases and how Hasura supports them natively.

Things you wish you knew about PostgreSQL for building an app

I had posted this question on platforms like Twitter, HackerNews and Reddit and got some interesting responses. In this post, I'm collating a bunch of these discussions to help frontend or full stack developers work better with PostgreSQL for their app.

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.

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.

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!

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.

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

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.

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.

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 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.

Ready to get started?

Start for free on Hasura Cloud or you could contact our sales team for a detailed walk-through on how Hasura may benefit your business.

Get monthly product updates

Sign up for full access to our community highlights, new features, and occasional baby animal gifs! Oh, and we have a strict no-spam rule. ✌️