norm icon indicating copy to clipboard operation
norm copied to clipboard

[FR] connection pooling

Open lantos1618 opened this issue 6 years ago • 4 comments

I saw that there is this project that has conn pooling https://nimble.directory/pkg/pg also that JohnAD has plans to pull mongodb and conn pooling. Have we got plans for conn pooling for postgress/sqlite?

lantos1618 avatar Nov 13 '19 20:11 lantos1618

No plans so far. Feel free to contribute.

moigagoo avatar Nov 14 '19 05:11 moigagoo

Just saw this issue. I wrote myself a connection pooling package for exactly this: https://github.com/PhilippMDoerner/TinyPool

Could it make sense to use the package in norm? Or possibly just copy paste some of the code as starting point for norm?

PhilippMDoerner avatar Aug 12 '22 20:08 PhilippMDoerner

It would be awesome to support it in Norm. I see the package is compatible with Nim stdlib's DbConn type, so it shouldn't be too hard to use.

moigagoo avatar Aug 15 '22 10:08 moigagoo

In that case my first approach would likely be copy pasting the code into norm, modifying it to better integrate with norm's logging and swapping out the std/db_* libs with ndb/sqlite and ndb/postgres. Sound good?

PhilippMDoerner avatar Aug 15 '22 19:08 PhilippMDoerner

nice one moigagoo

lantos1618 avatar Oct 19 '22 15:10 lantos1618