Warning

SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.

Using Prepared Statements

If you are using an older version of SingleStore, or using SingleStore with Audit Logging enabled, SingleStore does not support server-side prepared statements. Instead, many client drivers support a configuration option to allow client-side prepared statements. This configuration option may also be referred to as client-side prepared statement emulation or parameter interpolation. You can use the same code in your application, but change a flag in the client driver configuration. For example:

In the MySQL Connector/J (JDBC) driver, set useServerPrepStmts=false, which is the default configuration.
In MariaDB Connector/J, set useServerPrepStmts=false.
In ODBC, set no_ssps=1.
In the Go MySQL driver, set interpolateParams=true.
In PHP PDO, set PDO::ATTR_EMULATE_PREPARES=TRUE.

In many other databases, server-side prepared statements provide performance advantages, but SingleStore already compiles and caches query plans internally, so SingleStore does not need server-side prepared statements to get most of those performance advantages.

Using Prepared Statements

Was this article helpful?

Was this article helpful?