Skip to content

Configurable SQL injection mechanisms #125

Closed

Description

@wesleykendall

When using pgtrigger.ignore or pgtrigger.schema, variables are inject into the SQL, meaning an additional SQL statement to set variables is prepending before every SQL statement.

The rationale of this original approach was to avoid any extra surprise queries at all costs, especially for users with poor DB latencies. On the other hand, SQL is now prepended with a statement to set a variable, which fills the SQL log and also does add an overhead to every statement (albeit largely negligible)

I'm planning to spin out the SQL injection and variable setting logic into its own library since this approach is used by other libraries. I will make the variable injection configurable in this library, meaning users of pgtrigger will be able to configure how some of these dynamic features work

Activity

  1. locked and limited conversation to collaborators on Aug 27, 2024
  2. converted this issue into a discussion #160 on Aug 27, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions