views:

620

answers:

1

I have a C application using the MySQL library for database access.

Is there a standard way to implement database connection pooling for such an application? The C connector doesn't appear to support it.

+1  A: 

SQL Relay looks like it can be used to do this, amongst many other useful things, such as

  • client-side caching
  • load-balancing across database instances
  • translating between different database access APIs

If the MySQL library is dynamically linked this can be done without recompiling the application.

However, the mailing list suggests SQL Relay may not be fully ready for production use.

Kieran Tully
Comments on experience with SQL Relay, and other suggestions welcome!
Kieran Tully