Confused new dev here, wondering what practice is best

[abc123455555]

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.

[abc123455555]

Anyone? I could really help with an answer 😥

[Gordon-C]

Hi @abc123455555 

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