2020-02-12
1983
#graphql#postgresql
Austin Roy Omondi
13931
Feb 12, 2020 ⋅ 7 min read

Intro to Postgres + GraphQL with PostGraphile

Austin Roy Omondi Live long and prosper 👌

Recent posts:

Gemini CLI tutorial — Will it replace Windsurf and Cursor?

Gemini CLI tutorial — Will it replace Windsurf and Cursor?

Discover how to use Gemini CLI, Google’s new open-source AI agent that brings Gemini directly to your terminal.

Chizaram Ken
Jul 10, 2025 ⋅ 8 min read
React & TypeScript: 10 Patterns For Writing Better Code

React & TypeScript: 10 patterns for writing better code

This article explores several proven patterns for writing safer, cleaner, and more readable code in React and TypeScript.

Peter Aideloje
Jul 10, 2025 ⋅ 11 min read
A Guide To Wrapper Vs. Container Classes In CSS

A guide to wrapper vs. container classes in CSS

A breakdown of the wrapper and container CSS classes, how they’re used in real-world code, and when it makes sense to use one over the other.

Temitope Oyedele
Jul 7, 2025 ⋅ 10 min read
Stagehand and Gemini logos on a gradient background symbolizing AI web automation

How to build a web-based AI agent with Stagehand and Gemini

This guide walks you through creating a web UI for an AI agent that browses, clicks, and extracts info from websites powered by Stagehand and Gemini.

Elijah Asaolu
Jul 4, 2025 ⋅ 8 min read
View all posts

3 Replies to "Intro to Postgres + GraphQL with PostGraphile"

  1. Hi Austin, Thanks for this!
    I just wanted to let you know that I found this useful but you could add something in there to let people know that they should use `-s “test_schema”` to be able to see the schema in graphiql. I got stuck on this part for a bit but then after reading the postgraphile –help I was able to figure out that I should need to use `postgraphile -s “test_schema” -c “postgres:///testdb”`
    Keep up the good work!
    -Dana

  2. I got the same error as Dana Z, I corrected it but then I am getting ‘permission denied for schema “test_schema”‘. Can somebody help?

  3. I too has the schema issue. Below is the entire command I used to start up postgraphile:

    postgraphile -s test_schema -c “postgresql://:@localhost:5432/testdb”

    The username I specified was one that I created in the database…I gave this user “login” and “superuser” privileges (Not recommended for production systems!).

    Then on the test_schema properties page, click the security tab and grant all privileges to this new user.

    I know it’s a year later, but HTH!

Leave a Reply