How to connect graphql server to postgres database?
up vote
0
down vote
favorite
This is myposgres.sql file in my project directory:
CREATE TABLE client (
cli_id serial PRIMARY KEY,
cli_name text NOT NULL,
cli_birthyear smallint NOT NULL
);
CREATE TABLE product (
pro_id serial PRIMARY KEY,
pro_ean text UNIQUE NOT NULL,
pro_name text NOT NULL,
pro_description text NOT NULL,
pro_weight_g smallint NOT NULL
);
CREATE TABLE command (
com_id serial PRIMARY KEY,
com_number text UNIQUE NOT NULL,
cli_id integer NOT NULL REFERENCES client
);
CREATE TABLE command_line (
lin_id serial PRIMARY KEY,
com_id integer NOT NULL REFERENCES command,
pro_id integer NOT NULL REFERENCES product,
lin_quantity smallint NOT NULL
);
Now, how do I use this file to connect the postges database to graphql? And how query postgres database using graphql?
postgresql graphql
asked Nov 21 at 12:26
Tejas
427
add a comment |
up vote
0
down vote
favorite
This is myposgres.sql file in my project directory:
CREATE TABLE client (
cli_id serial PRIMARY KEY,
cli_name text NOT NULL,
cli_birthyear smallint NOT NULL
);
CREATE TABLE product (
pro_id serial PRIMARY KEY,
pro_ean text UNIQUE NOT NULL,
pro_name text NOT NULL,
pro_description text NOT NULL,
pro_weight_g smallint NOT NULL
);
CREATE TABLE command (
com_id serial PRIMARY KEY,
com_number text UNIQUE NOT NULL,
cli_id integer NOT NULL REFERENCES client
);
CREATE TABLE command_line (
lin_id serial PRIMARY KEY,
com_id integer NOT NULL REFERENCES command,
pro_id integer NOT NULL REFERENCES product,
lin_quantity smallint NOT NULL
);
Now, how do I use this file to connect the postges database to graphql? And how query postgres database using graphql?
postgresql graphql
asked Nov 21 at 12:26
Tejas
427
You need to write a program to do that. GraphQL and SQL are different things and PostgreSQL doesn't (and shouldn't) provide a GraphQL interface to its data store.
– David Maze
Nov 23 at 3:24
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
This is myposgres.sql file in my project directory:
CREATE TABLE client (
cli_id serial PRIMARY KEY,
cli_name text NOT NULL,
cli_birthyear smallint NOT NULL
);
CREATE TABLE product (
pro_id serial PRIMARY KEY,
pro_ean text UNIQUE NOT NULL,
pro_name text NOT NULL,
pro_description text NOT NULL,
pro_weight_g smallint NOT NULL
);
CREATE TABLE command (
com_id serial PRIMARY KEY,
com_number text UNIQUE NOT NULL,
cli_id integer NOT NULL REFERENCES client
);
CREATE TABLE command_line (
lin_id serial PRIMARY KEY,
com_id integer NOT NULL REFERENCES command,
pro_id integer NOT NULL REFERENCES product,
lin_quantity smallint NOT NULL
);
Now, how do I use this file to connect the postges database to graphql? And how query postgres database using graphql?
postgresql graphql
asked Nov 21 at 12:26
Tejas
427
This is myposgres.sql file in my project directory:
CREATE TABLE client (
cli_id serial PRIMARY KEY,
cli_name text NOT NULL,
cli_birthyear smallint NOT NULL
);
CREATE TABLE product (
pro_id serial PRIMARY KEY,
pro_ean text UNIQUE NOT NULL,
pro_name text NOT NULL,
pro_description text NOT NULL,
pro_weight_g smallint NOT NULL
);
CREATE TABLE command (
com_id serial PRIMARY KEY,
com_number text UNIQUE NOT NULL,
cli_id integer NOT NULL REFERENCES client
);
CREATE TABLE command_line (
lin_id serial PRIMARY KEY,
com_id integer NOT NULL REFERENCES command,
pro_id integer NOT NULL REFERENCES product,
lin_quantity smallint NOT NULL
);
Now, how do I use this file to connect the postges database to graphql? And how query postgres database using graphql?
postgresql graphql
postgresql graphql
asked Nov 21 at 12:26
Tejas
427
asked Nov 21 at 12:26
Tejas
427
asked Nov 21 at 12:26
Tejas
427
asked Nov 21 at 12:26
Tejas
427
asked Nov 21 at 12:26
Tejas
427
427
You need to write a program to do that. GraphQL and SQL are different things and PostgreSQL doesn't (and shouldn't) provide a GraphQL interface to its data store.
– David Maze
Nov 23 at 3:24
add a comment |
You need to write a program to do that. GraphQL and SQL are different things and PostgreSQL doesn't (and shouldn't) provide a GraphQL interface to its data store.
– David Maze
Nov 23 at 3:24
You need to write a program to do that. GraphQL and SQL are different things and PostgreSQL doesn't (and shouldn't) provide a GraphQL interface to its data store.
– David Maze
Nov 23 at 3:24
You need to write a program to do that. GraphQL and SQL are different things and PostgreSQL doesn't (and shouldn't) provide a GraphQL interface to its data store.
– David Maze
Nov 23 at 3:24
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53412007%2fhow-to-connect-graphql-server-to-postgres-database%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
You need to write a program to do that. GraphQL and SQL are different things and PostgreSQL doesn't (and shouldn't) provide a GraphQL interface to its data store.
– David Maze
Nov 23 at 3:24