How to make GraphQL schema for MySQL models?

user_4412843 0
Viewed 8180

I have the following table in mysql.

Users

CREATE TABLE users(
    id INTEGER AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(255) UNIQUE NOT NULL,
    email VARCHAR(255) UNIQUE NOT NULL,
    password VARCHAR(100) NOT NULL,
    created_at TIMESTAMP DEFAULT NOW()
);

and Posts

CREATE TABLE posts(
    id INTEGER AUTO_INCREMENT PRIMARY KEY,
    created_by INTEGER NOT NULL,
    created_at TIMESTAMP DEFAULT NOW(),
    post_title VARCHAR(100) NOT NULL UNIQUE,
    post_body VARCHAR(255) NOT NULL,
    slug VARCHAR(100) NOT NULL UNIQUE,
    FOREIGN KEY (created_by) REFERENCES users(id)
);

I am using nodejs and the mysql npm package. How can I make graphQL schema for the models?

I searched a lot but failed to find any solution to this. Mostly people are using sequelize for this purpose. Is it better than mysql package?

graphql node.js mysql
2 Answers

You can try a new open source tool called SwitchQL (github.com/SwitchQL/SwitchQL). I've been working on the project for a while.

You pass it your connection string and it returns everything you need to run a graphql server on top of an existing database. It also returns Apollo compliant client mutation and queries.

We only support Postgres at the moment, but if you'd like to look into helping us support MySQL let me know!

user_77372230
Related