Metadata
- Source
- KETTLE-81
- Type
- New Feature
- Priority
- Major
- Status
- Open
- Resolution
- N/A
- Assignee
- Antranig Basman
- Reporter
- Antranig Basman
- Created
2020-02-03T08:47:04.931-0500 - Updated
2020-02-03T08:47:04.931-0500 - Versions
- N/A
- Fixed Versions
- N/A
- Component
- N/A
Description
As our communities switch back towards SQL-based persistence, especially involving PostgreSQL, we need to widen our hierarachy of supported DataSource configurations to include SQL variants. This will be a light abstraction over the existing parameterised query system described in https://node-postgres.com/features/queries , transparent connection pooling, together with some basic support for transactions.
We need to think further about an issue which has been arising from time to time with DataSource design, where the "get" and "set" legs are asymmetric or perhaps the "get" leg is even nonexistent - this is much more common with RESTless designs such as SQL.