🚀 Vento — PostgreSQL Asset Setup

🛠️ Prerequisites

• - PostgreSQL 13+ running

1️⃣ Configure the DB Provider

✏️ Change Database URL via Settings

• - Edit settings in the Settings tab
  or
  Directly modify:
  data/settings/NAME_OF_THE_SETTING

⚠️ WARNING:
If no database is running or the address (DB_URL) is incorrect, Vento API will break.
To fix:

• - Ensure your database service is up
• - Check your DB_URL
• - Restart Vento (see below)

DB_PROVIDER=postgresql # Default, do not change
DB_URL=postgres://l2c:l2c_dev_pass@localhost:5432/l2c_dev # Local dev example

2️⃣ Restart Vento

yarn kill
yarn dev        # for development

3️⃣ What This Asset Does

• - Registers the postgres provider in protonode
• - On first use, auto-creates KV tables if needed:
  • - entries(id TEXT PRIMARY KEY, data JSONB, created_at BIGINT)
  • - indexTable(name TEXT PRIMARY KEY, value JSONB)
• - If you point to an existing schema/table, it switches to table mode automatically

🐞 Troubleshooting

• -

  ECONNREFUSED 127.0.0.1:5432
  → DB not listening / port not mapped.
  Check Docker ports or service status.

• -

  getaddrinfo ENOTFOUND loc
  → DB not listening / port not mapped.
  Check Docker ports or service status.