Retrace: Ideas Portal

Retrace combines several tools every development team needs, but we are always open to fresh new ideas.  Please submit your feature request/idea for Retrace below.

Support collecting and showing SQL parameters in traces, like Prefix does

I understand there are security issues, but we are OK with them. We want to be able to enable seeing the parameters.

  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Dec 13 2017
  • Attach files
  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    15 Sep 05:09pm

    Support directed me here when I asked if this was possible. I understand the security concerns, but this would be extremely beneficial. Maybe an option that can be enabled in your account to even record the data at all, but then have it so query parameters are hidden by default and you have to click to view the parameters. You'd probably want to encrypt the data on your end, for PCI compliance (just in case there was credit card information)... maybe an optional security key a client could upload (public key) so nobody on Stackify's side could decrypt it, but a client could download the encrypted SQL query and decrypt it on their end. There may be a browser extension that lets you do it inside the browser too. You could keep your sanitized SQL queries the way you have now, but store the optional encrypted full queries in another table.

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    16 Sep, 2019 07:01am

    I think this is "fundamental" when it comes to reproducing SQL traces from production. It should be possible to globally turn it on or, considering security, turn it on for selected queries or request.

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    5 Jul, 2019 03:08pm

    indeed as different parameters could different results in terms of load times.