I have a server running collecting some data, and this was written in Rails. It has a sql-lite db stored on disk. The Rails part is built as a json-RESTful api which talks to iPads, and data were collected there.
Now I need to analyze the data in some tables from the sql-lite db. Let's say I'd like to do some computation on the stored data, for instance the prices my customers pay, and run some fancy algorithms on it.
Then I need to show the results of the computation back in the RESTful api so that on the iPad I could know the results.
I'm thinking of doing this via:
- Use
Python/Matlabor whatever to read thesql-lite db - Do computation there and then insert it back to the
sql-lite dbin a separate table - Create a new endpoint for
Railsto render the new results
I'm wondering is this a good way to do? Can I directly interact with the database created by Rails? If not what would be a better way in this scenario?
Aucun commentaire:
Enregistrer un commentaire