Is there a connection manager you recommend?

[shi-yan]

Is it efficient to create a new connection each time I need to access the database?

Or should I use a connection manager?

Which one should I use? some connection manager projects are not well maintained.

[gwenn]

Is it efficient to create a new connection each time I need to access the database?
Or should I use a connection manager?

It depends on many factors.

Which one should I use? some connection manager projects are not well maintained.

r2d2-sqlite seems to be the most popular one.