Sobes.tech
Senior

Situational question: the product team wants to implement integration via db-link with direct SELECTs instead of a normal adapter. What are your actions?

sobes.tech AI

Answer from AI

If the product team proposes integration via db-link with direct SELECT queries instead of using a proper adapter, my actions would be:

  1. Understand the motivation: find out why this approach was chosen — perhaps it's faster, simpler, or due to constraints.

  2. Assess the risks:

    • Direct SELECTs via db-link can lead to performance issues, especially with large data volumes.
    • Difficulties with support, debugging, and scaling.
    • Loss of control over transactions and data integrity.
  3. Suggest alternatives: explain the benefits of using an adapter — centralized logic, caching, error handling, security.

  4. Demonstration: if possible, show a prototype or example of how the adapter solves problems more efficiently and safely.

  5. Compromise: if the team insists, propose a hybrid approach or limit the use of db-link to small, infrequent queries.

  6. Documentation: record the decision and associated risks for future support.

Overall, it's important not just to refuse but to explain the technical reasons and suggest optimal solutions, considering business goals and constraints.