Introduction

GraphJin is a service that instantly and without code gives you a high performance and secure GraphQL API. Your GraphQL queries are auto translated into a single fast SQL query. No more spending weeks or months writing backend API code. Just make the query you need and GraphJin will do the rest.

GraphJin has a rich feature set like integrating with your existing Ruby on Rails apps, joining your DB with data from remote APIs, Role and Attribute based access control, Support for JWT tokens, DB migrations, seeding and a lot more.

Features#

Complex nested queries and mutations
Build realtime apps with subscriptions
Instant infinite scroll, feeds, nested comments, etc
Auto learns database tables and relationships
Role and Attribute-based access control
Opaque cursor-based efficient pagination
Full-text search and aggregations
JWT tokens supported (Auth0, etc)
Join database queries with remote REST APIs
Also works with existing Ruby-On-Rails apps
Rails authentication supported (Redis, Memcache, Cookie)
A simple config file
High performance Go codebase
Tiny docker image and low memory requirements
Fuzz tested for security
Database migrations tool
Database seeding tool
Works with Postgres and Yugabyte DB
OpenCensus Support: Zipkin, Prometheus, X-Ray, Stackdriver
Highly scalable and fast

Try the demo app#

# clone the repository
git clone https://github.com/dosco/graphjin

# goto our example ecommerce app
cd examples/webshop

# create, migrate and seed the database
docker-compose run api db:setup

# start the demo
docker-compose up

# try graphql queries on our web ui with auto-complete
open http://localhost:8080

Docker?

This demo requires docker you can either install it using brew or from the docker website https://docs.docker.com/docker-for-mac/install/

GraphQL#

We fully support queries and mutations. For example the below GraphQL query would fetch two products that belong to the current user where the price is greater than 10.

GraphQL Query#

query {
  users {
    id
    email
    picture: avatar
    password
    full_name
    products(limit: 2, where: { price: { gt: 10 } }) {
      id
      name
      description
      price
    }
  }
}

JSON Result#

{
  "data": {
    "users": [
      {
        "id": 1,
        "email": "odilia@west.info",
        "picture": "https://robohash.org/simur.png?size=300x300",
        "full_name": "Edwin Orn",
        "products": [
          {
            "id": 16,
            "name": "Sierra Nevada Style Ale",
            "description": "Belgian Abbey, 92 IBU, 4.7%, 17.4°Blg",
            "price": 16.47
          },
          ...
        ]
      }
    ]
  }
}

Set User ID

In development mode you can use the X-User-ID: 4 header to set a user id so you don't have to worries about cookies etc. This can be set using the HTTP Headers tab at the bottom of the web UI.

GraphQL Mutation#

In another example the below GraphQL mutation would insert a product into the database. The first part of the below example is the variable data and the second half is the GraphQL mutation. For mutations data has to always ben passed as a variable.

{
  "data": {
    "name": "Art of Computer Programming",
    "description": "The Art of Computer Programming (TAOCP) is a comprehensive monograph written by computer scientist Donald Knuth",
    "price": 30.5
  }
}

mutation {
  product(insert: $data) {
    id
    name
  }
}

Built-in GraphQL Editor#

Quickly craft and test your queries with a full-featured GraphQL editor. Auto-complete and schema documentation is automatically available.