Feature request: PreparedStatement caching at the driver layer

[rhofmeyr]

Hi all,

I have a feature request for enabling PreparedStatement at the driver layer. Modern connection managers, such as HikariCP, refuse to implement PreparedStatement caching, as it can be implemented better at the driver layer (for example, not maintaining a cache per-connection). It would be great if the SQLite JDBC driver could implement this feature.

[gotson]

The postgresql implementation for reference: pgjdbc/pgjdbc#319

[MatteoBax]

This feature would be very useful for increasing performance in applications that frequently execute the same queries.