search

compbiocore / qcdb

QC Database
0 stars 1 forks source link

sometime in the future: sqlalchemy connections? #7

Closed JRWallace closed 5 years ago

JRWallace commented 5 years ago

sqlalchemy needs a persistent connection -- is this an issue? We might need to maintain a pool of connections so that several users can query and use the database at the same time without slowing each other down. Do we want an implementation that allows for several concurrent connections?

JRWallace commented 5 years ago

Can sqlalchemy have several concurrent connections? If it does, we can continue w sqlalchemy -- if it doesn't, we need to find a new implementation.

mcmcgrath13 commented 5 years ago

@JRWallace @aguang is this still an issue? The API pools connections to the DB, I don't think this is an issue if two people are running QCDB locally

aguang commented 5 years ago

@mcmcgrath13 if you don't think it's an issue with the way the API is set up then yeah we can close