juffalow / express-graphql-example Goto Github PK

View Code? Open in Web Editor NEW

247.0 8.0 74.0 1.01 MB

Example project how to use Express and GraphQL

Home Page: https://graphql.juffalow.com/graphql

License: MIT License

JavaScript 1.34% TypeScript 97.42% Dockerfile 1.24%

nodejs graphql express example-project knexjs typescript sql

express-graphql-example's Introduction

Express, GraphQL example

How to run the project using Docker

docker-compose up --build

Open GraphiQL in your browser http://localhost:3010/graphql

How to run the project

Install dependencies:

yarn

# or using npm

npm install

Create src/config.ts or rename src/config.example.js and update file with your credentials:

export default {
  port: 3010,
  database: {
    type: 'mysql',
    connection: {
      database : '',
      host : '',
      password : '',
      user : '',
    },
    /*
     * Migrations run on every start of the application.
     * If you initialized the database manually (from the database.sql file),
     * you don't need this.
     */
    migrations: {
      directory: __dirname + '/migrations',
    },
  },
};

Run the project:

yarn start

# or using npm

npm start

Open GraphiQL in your browser http://localhost:3010/graphql

Examples

You can find example queries in EXAMPLES.md.

Old version

Here is a link to an old version, that used sequelize and did not use connections:

1.4.0

Here is a link to older version, that did not use typescript, and used buildSchema method and graphql schema file:

2.0.0

Here is a link to older version, that used typescript version 4.x and graphql-express package to handle GrahpQL requests:

3.3.0

License

MIT license

express-graphql-example's People

Contributors

Stargazers

Watchers

Forkers

nrvnujd humfricz mkristofcak softden2006 rchvalbo herrkessler necrodevz wei-studio mirazmamun stam victorkemboi thinkingmik davinaleong sunnysidesounds leihuagh gkopylovdev darkrift umeriftikhar thinking123 tanfrank rubcovsa theshaneyu iam-hussain kenjimakuda as7dev chetanmunegowda hemanthkodandarama repl-hemanth-kodandarama repl-anand-bidwalkar tomybudiman redxawn shihkaihung sudhierk kunal-mandalia nithincs20 eric-hc markheramis jweiwu hoangnx30 hninhninaye123 4lexvav mori-heidari dylandaviddavies rico157 hbechar pietgk jakubbt nakrish12 p-mohamed-elsawy doctoritcoder amanullah28 anshuljain30 lipej yuricplus therealthor kenneth-huang santoshstha mido0258 vigorpush kupara creativecutezealot zheng-dao silvesterwali stefanozuca thanhtrungvo8401 knaeckekami sergeykadiyevskiy iamalextodoran r0b0k baaaaark vanhoaltw marimuthu-raja neeravgg

express-graphql-example's Issues

Create version 2

What to change:

variable names ( last_name => lastName )
change pagination ( to use edges and nodes )
add permissions ( public user / admin )

Add JWT auth

Add basic auth functionality. Any user can read the data - query authors and quotes but only logged in user can add new author / use mutations.

Improve queries

Because of #13 now it always loads everything from the database, even if it is not requested. This can be optimized also.

How to Improve Performance?

Hey, Thanks a lot for the wonderful project.
But I have some reservations, hope you could address them.

query{
  authors{
    name
    last_name
      quotes{
        id
        quote
      }
  }
}

Query like above will have performance issues, since numerous requests are made to the Database.
Example:

Executing (default): SELECT [id], [name], [last_name] FROM [author] AS [author];
Executing (default): SELECT [id], [name], [last_name] FROM [author] AS [author];
Executing (default): SELECT [id], [name], [last_name] FROM [author] AS [author];
Executing (default): SELECT [id], [name], [last_name] FROM [author] AS [author];
Executing (default): SELECT [id], [author_id], [quote] FROM [quote] AS [quote] WHERE [quote].[author_id] = 1;
Executing (default): SELECT [id], [author_id], [quote] FROM [quote] AS [quote] WHERE [quote].[author_id] = 2;
Executing (default): SELECT [id], [author_id], [quote] FROM [quote] AS [quote] WHERE [quote].[author_id] = 3;
Executing (default): SELECT [id], [author_id], [quote] FROM [quote] AS [quote] WHERE [quote].[author_id] = 4;
Executing (default): SELECT [id], [author_id], [quote] FROM [quote] AS [quote] WHERE [quote].[author_id] = 5;
Executing (default): SELECT [id], [author_id], [quote] FROM [quote] AS [quote] WHERE [quote].[author_id] = 6;

So, rather than querying DB once, n+1 requests are made.
One to retrieve all the users and n to retrieve quotes for each of the author.
Do you have any recommendations how to improve that and minimize the number of SQL round-trips?

Any examples to use the filter on authors' query

Tried

{
authors(filter: {name: "Bill"}) {
id
last_name
name
}
}

Got the error:

{
"errors": [
{
"message": "Invalid value { name: 'Bill' }",
"locations": [
{
"line": 2,
"column": 3
}
],
"path": [
"authors"
]
}
],
"data": {
"authors": null
}
}

Thanks for help with this very good example application.

{
"errors": [
{
"message": "Cannot read property 'forEach' of undefined",
"locations": [
{
"line": 2,
"column": 3
}
],
"path": [
"createAuthor"
]
}
],
"data": {
"createAuthor": null
}
}