🚧
A React app communicating with a Postgresql database Using Urql and Postgraphile's API generation.
.+------+ +------+ +------+ +------+.
.' | .'| /| /| |\ |\ |`. | `.
+---+--+' | +-+----+ | | +----+-+ | `+--+---+
| | | | | | | | | | | | | | | |
| React| <-> graphql.js| <-> Postgraphile <-> Postgresql
|.' | .' |/ |/ \| \| `. | `. |
+------+' +------ \ +------+ `+------+
\
\ +------+
|\ |\
| +----+-+
| | | |
.Github API
\| \|
+------+
- Postgresql
- react-postgraphile
git clone https://github.com/skvale/react-postgraphile
Start Postgres
# for MacOS
brew services start postgres
# or
# postgres -D /usr/local/var/postgres
Create a database:
createdb react_postgraphile
Populate it
psql -f database/create.sql -d react_postgraphile
Start Postgraphile to create a Graphql layer over the created database
yarn run postgraphile
You can check your Graphql out at localhost:5000/graphql
Generate the Types from the running schema
yarn run types:gen
Run the React app in a new terminal
yarn start