search

atlarge-research / AIP

An instrument to combine, unify, and correct (scientific) article meta-data.
10 stars 8 forks source link

PERFORMANCE: Check if migrating to MySQL or PostgreSQL makes sense. #7

Closed lfdversluis closed 3 years ago

lfdversluis commented 4 years ago

We upped the timeout of the database to 120 seconds because concurrent access are tricky in mysqlite. Postgres and mysql are very good with multiple connections, with postgres having the edge. Postgres being open source is also a plus. Check if moving to this database makes sense.

https://www.psycopg.org/ is a good starting point

lfdversluis commented 4 years ago

I am running into access issues again when running AIP on the DAS5, I will migrate to Postgres

lfdversluis commented 4 years ago

postgres is a nightmare to get working on the DAS without root, trying mysql

lfdversluis commented 3 years ago

Everything was updated to postgres in the end. Multi-threaded access etc. are now all doable as well have good performance. Closing this one.