In this guide, we are going to cover how to get Graphweaver and PostgreSQL connected.
Before we dive in, let’s make sure that you have PostgreSQL, Node.js version 18 or greater, and pnpm
version 8 or greater installed on your local machine.
Once they are installed, we can get started.
The first step is to make sure that we have the configuration settings correct in PostgreSQL. For this guide, we are going to assume that you have PostgreSQL running locally on port 5432
.
If you have it running on another port, then remember to change this in the Graphweaver configuration below.
Next, you are going to need a user in PostgreSQL that we can use when connecting from Graphweaver. For this guide, we are going to assume that you have a user postgres
with an empty password.
Here are the settings that we will need:
postgres
''
5432
Next, let’s setup a database to use as an example.
For this guide, we are going to create a database with a single table. We will be using a number of the PostgreSQL command line tools to create the DB, create a user table and seed it with some data.
Don’t worry if you prefer to use a GUI when setting up the DB - as long as the names match you can use any tool you need.