PostgreSQL

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

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.
Praveen Durairaju
Praveen Durairaju
7 min read
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
Phil Freeman
Phil Freeman
5 min read
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.
Praveen Durairaju
Praveen Durairaju
6 min read
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.
Praveen Durairaju
Praveen Durairaju
4 min read
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.
Hasura
Hasura
5 min read
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.
Hasura
Hasura
5 min read
Postgres

Postgres Containment Operators : Part 1 — Introduction

An unofficial guide to JSONB operators in Postgres.
Hasura
Hasura
3 min read