Welcome to Percona Live Online 2021
Online Open Source Database Conference
Thursday, May 13 • 13:00 - 13:30
GraphJin - The Automagical GraphQL to SQL Compiler

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.

In 2015, Facebook introduced GraphQL, a front-end query framework designed to shield users from the intricacies of the various backends one would find in modern data stacks. As with ORMs before then, most backend code ended up being databases, adding layers of abstraction that ended up being inefficient and required immense investments to scale out for performance.

Additionally, most app developers are not very familiar with SQL and go to great lengths to avoid learning it. This has created several problems like n+1 queries, inefficient queries, minimal use of database features, etc. While Postgres is growing in popularity with this audience the large majority of advanced features like JSON support, Recursive CTE’s, Window functions are never used. Often developers are unfamiliar with even simple features like the various types of JOINS and choose inefficient solutions like multiple queries instead.

GraphJin, an open-source project, was developed to solve this disconnect by putting all the power in the hands of the UI/UX developer and freeing up the backend developer to focus on the truly hard problems and optimize the queries to take full advantage of the advanced features of Postgres.

GraphJin is a compiler written in Go that can convert the GraphQL describing the data needed into a single efficient SQL query optimized for Postgres or MySQL. It discovers the schema and relationship graph of the database to help it build efficient queries and provide the frontend developer an auto-complete enabled GraphQL query builder to quickly fetch the data needed.


avatar for Vikram Rangnekar

Vikram Rangnekar

Founder 42papers.com, 42papers.com
Vikram Rangnekar grew up in Bombay, studied computer science at the University of Delaware. He founded Socialwok a Techcrunch50 startup that was early in the enterprise collaboration space. This led him to Linkedin early in 2010 where he worked on various things from the API platform... Read More →

Thursday May 13, 2021 13:00 - 13:30 EDT
Room #4