Discussion: LowDB and concurrency

[kevinold]

We selected lowdb because of it's easy to install footprint and base of json-server.

The configuration for running Jest tests has been adjusted to run them synchronously (via --runInBand) due to failures when the unit test are run concurrently.

To date, the Cypress API tests have not had an issue.

Our primary goals for a database are:

1. Ensure that we are able to execute real world test case scenarios with zero installation dependencies
2. Retrieve record immediately after save

Given this information, we may need to look to one of the following solutions (or others) to ensure tests can be run asynchronously.

1. Use async/await with the existing lowdb Sync Adapter
2. Investigate/use lowdb's Async Adapter (https://github.com/typicode/lowdb/blob/master/src/adapters/FileAsync.js)
3. Investigate how json-server handles the situation

[amirrustam]

• From lowDB maintainer: how resolve the concurrence problem? typicode/lowdb#11 (comment)

• Regarding the use of fileAsync to handle concurrency

  Please note that if you're developing a local server and don't expect to get concurrent requests, it's often easier to use file-sync storage, which is the default.

  But if you need to avoid blocking requests, you can do so by using file-async storage

[kevinold]

Based on discussions we will revisit if it becomes an issue.