Tips on how to modify database records rather than generating new ones

Question

Tips on how to modify database records rather than generating new ones

Currently, my team is developing a web application that utilizes wearables to monitor vital parameters. As part of our integration testing, we are using a Fitbit device. The app itself is built with Angular and JavaScript, while the database is hosted on Cloudant. I am seeking advice on how to maintain updated database entries in a general sense. Specifically, I would like to gather wearable data every two hours and update an existing entry for the same day instead of creating duplicates.

At this point, I have considered two potential solutions:

Storing today's data, including the entry's ID, in a variable to be updated periodically, resetting it at midnight.
Prior to each update, retrieving all entries and checking for one matching today's date. If found, updating that existing entry; otherwise, creating a new one.

I'm not entirely satisfied with these options and would appreciate any guidance or alternative approaches.

Thank you in advance.

javascript angularjs cloudant fitbit

Answer 1

Answer №1

When working with Cloudant/CouchDB, updating existing documents can lead to conflicts. A better approach for scenarios like "IoT" applications is to create a new document for each sample and use a view to organize the data. Your documents could follow this structure:

{
   "timestamp": "2016-12-01T13:25:02.000Z",
   "type": "pressure",
   "value": 110.0
}

To materialize the data, you can utilize a design document that emits the data in a specific format:

function(doc) {
    if (doc && doc.timestamp && doc.value && doc.type) {
        var ts = Date.parse(doc.timestamp);
        emit([doc.type, ts], doc.value);
    }
}

For more information, check out:

Answer 2

When working with Cloudant/CouchDB, updating existing documents can lead to conflicts. A better approach for scenarios like "IoT" applications is to create a new document for each sample and use a view to organize the data. Your documents could follow this structure:

{
   "timestamp": "2016-12-01T13:25:02.000Z",
   "type": "pressure",
   "value": 110.0
}

To materialize the data, you can utilize a design document that emits the data in a specific format:

function(doc) {
    if (doc && doc.timestamp && doc.value && doc.type) {
        var ts = Date.parse(doc.timestamp);
        emit([doc.type, ts], doc.value);
    }
}

For more information, check out:

Tips on how to modify database records rather than generating new ones

Answer №1

Similar questions

watchify with gulp requires two saves to update modifications

Purging data when no input is detected in React.js

I'm looking for recommendations on database management systems that are compatible with Node.js. Can

Can a key event be activated on the DOM Window using Javascript or JQuery?

Understanding the extent of testing coverage in a project using karma and webpack

Give GetElementsByClassName a shot

Navigating with Vue Router in a Nuxt JS vuex Store

What is the best way to determine when the context value has been established?

Using Selenium WebDriver in JavaScript to Extract Text from an Array

The Keyup Filter in the FromEvent function is malfunctioning and not behaving as anticipated

The error message popping up reads as follows: "TypeError: _this2.setState cannot

Using jQuery to handle multiple AJAX XML requests

Bring in typings from a package with an alternate title

Understanding Restangular with Typescript can be challenging, especially when dealing with a 'restangularized' response object

Transitioning from Jquery to vanilla JavaScript or transforming Jquery code into pseudo code

When AJAX is invoked, the HTML content fails to display within a div

Making changes to an AngularJS property updates the value of an HTML attribute

Animating a background image to slide in from the bottom to the top using CSS transition

merge two structures to create a unified entity

Embed script tags into static HTML files served by a Node.js server