10-10-2022 20:24
10-10-2022 20:24
Let's say I want to store user's data on a SQL database and can receive HTTP Post notification and store API response. What practice would be most simple? I have read similar stuffs and they be using Heroku with PostgreSQL. I apologize if the question is too simple, I'm new to all this.
10-11-2022 21:33
10-11-2022 21:33
Anyone? I could really help with an answer 😥
10-17-2022 12:57
10-17-2022 12:57
The Fitbit Web API response is in JSON. How the data is stored in the database is really up to you and what you consider simple. And there are so many options available. Some databases support inserting a JSON document. Or you may want to parse the output inserting the data elements into into individual columns. Some applications have native integration with the database, or you may want to write code inserting the data using a native database API or JDBC driver.
I know this answer probably doesn't help much. Maybe start with the application that is pulling the data from Fitbit and see what options are available for that tool.
Gordon