Uploaded image for project: 'Qt'
  1. Qt
  2. QTBUG-82426

PostgreSQL driver: preparedQueries control

    XMLWordPrintable

    Details

    • Type: Suggestion
    • Status: Need More Info
    • Priority: Not Evaluated
    • Resolution: Incomplete
    • Affects Version/s: 5.14.1
    • Fix Version/s: None
    • Component/s: SQL Support
    • Labels:
      None
    • Platform/s:
      All

      Description

      Hi there,

       

      After having some issues with prepared statements tripping up Qt with PostgreSQL and PGpool, due to frequently lost database connections from mobile phones, I found that the easiest way to stop the hassle was to simply disable "preparedQueriesEnabled" in the driver (see attached "patch").

       

      Now, in case you guys are having a really boring winter day in the future, then I would like to suggest to make preparedQueriesEnabled user-controllable, by adding a little something to the driver, like "driver->preparedQueriesEnabled(true/false)".

       

      In cases like mine, where I do not have to worry about SQL injections or performance penalties, but constantly face unstable database connections, it adds to overall app robustness to be able to turn off prepared statements. Doing so without having to touch the driver code itself would be great. 

       

      Many thanks,

      Holger

        Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            People

            Assignee:
            andysh Andy Shaw
            Reporter:
            Fantail Holger Jahn
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Gerrit Reviews

                There are no open Gerrit changes