GraphQL API server for a Postgres database?

Hi aha,

I’ll try and provide you with the best options I’ve seen so far:

Digital Ocean’s own tutorial

If you are a looking for a quick integration of GraphQL with PostgreSQL while utilizing Docker, you can take a look at the following DO tutorial : https://www.digitalocean.com/community/tutorials/how-to-manually-set-up-a-prisma-server-on-ubuntu-18-04

The tutorial guides you trough the setup of a Prisma Server on your droplet. It will act as a proxy for your database.

Having said that, before you can actually follow the tutorial and do setup the Prisma server, you’ll need to get ready for it. There are a couple of initial requirements :

An Ubuntu 18.04 server.

Docker installed -

Docker Compose installed

Node.js installed

Now, all this is added to the tutorial however we as people tend to skip some important information, so I believe it’s better to point it out.

The process itself is very well explained in the tutorial itself so it should be no trouble actually following it up.

Another good way to get what you need

If you wish to see a second setup, I’ll suggest checking postgraphile and the github page .

It’s using PostGraphile. PostGraphile pairs PostgreSQL with GraphQL all while providing a simple way to use Docker with it. Again, you have some requirements before actually getting to work but then again it’s inevitable :

• Node v8.6+
• PostgreSQL 9.6+ (officially; but currently works with 9.4+)
• Linux, macOS or Windows

Once you do have them, you can configure PostGraphile with a few quick steps explained in the documentation

Before making a decision, I’ll suggest checking both examples and choosing the one that’s suited for your needs.