Home

doix-db-postgresql is a doix-db plugin for the PostgreSQL DBMS.

tl;dr

Add a DbPoolPg instance to your Application's pools.

That's it. Now, for a pool named 'db' (like one in our example), this.db will appear to be a corresponding DbClient:

const one = await this.db.getscalar (`SELECT 1`)

Reference

• General purpose:
  • DbClientPg — main API
  • DbPoolPg — connections pool
  • DbLangPg — SQL generator
• Notifications relatad:
  • DbListenerPg — notifications listener
    • DbServicePg — translates notifications into Jobs
    • DbQueuesRouterPg — invokes queue checking processes
    • DbNotificationPg — single notification
• Helper:
  • DbTableXformerPg — a helper class for reading DB metainformation