PostgreSQL is an open source object-relational database management system.
Changelog
7 versions
v2.2.0
Latest
- Query: Added Async Mode for long-running queries exceeding the standard timeout.
- Async Mode uses the PostgreSQL dblink extension to run queries in a background session.
- Async job state is persisted in MongoDB (pgAsyncJobs collection), surviving Appmixer restarts.
- Added plugin.js with background polling and cleanup jobs for async query management.
- Table dropdowns (CreateRow, DeleteRow, UpdateRow, ListColumns) changed to typeahead text inputs so a table name can be entered manually when the source call fails.
- Query: output port options are now generated without an auth account (ignoreAuth) — they are static and need no database access.
- ListTables, ListColumns: documented the output port payload with a JSON schema (array of catalog rows with examples).
- Async Mode hardening for multi-node deployments: atomic result-delivery claim (no duplicate delivery after stale-job takeover), unique job index (no double query start), read-only enforced server-side via default_transaction_read_only on the dblink session, stale-job recovery skips stopped flows, and result rows are no longer persisted in the job document (avoids the 16MB BSON limit).
- Async Mode now supports the Stream to file output type: the result is streamed into a CSV file in platform storage and only the File ID is delivered, so arbitrarily large result sets are safe.
v2.1.1
- Added output examples to component schemas.
v2.1.0
- Fixed SQL injection vulnerabilities in ListColumns, CreateRow, UpdateRow, and DeleteRow components.
- Removed operators: 'BETWEEN' and 'NOT BETWEEN' from UpdateRow and DeleteRow components.
v2.0.1
- Fix: Query component - release connection after query execution.
v2.0.0
- CreateRow: poolSize configuration removed.
- All components support table schemas.
- DB connections are optimized and reused.
- New connector configuration: pool_statement_timeout, pool_query_timeout, pool_lock_timeout, pool_application_name, pool_connectionTimeoutMillis, pool_idleTimeoutMillis, pool_max, pool_allowExitOnIdle.
- Driver updated to the latest version.
- Added DeleteRow, UpdateRow and Query components.
v1.0.2
- Password input changed to type password.
- Postgres lib upgraded to the newest version.
v1.0.0
- Initial version
Authentication
| Type | Details |
|---|---|
| API Key |
User (text)
Database User
Host (text)
Database Host
Port (text)
Database Port
Database (text)
Name of your database
Password (password)
Password
|
