Running Algorithm on Rails Database

[jackrabbit]

Hi,

So I am currently running an iPhone program that basically draws a lot of statistics from a scientific test. I am storing the results in a Rails backend. I have one cell with the userID, and another cell with all the data in a string such in the format "Statistic1=5, Statistic2=6, etc." (all separate variables are separated by commas) I want to run an algorithm on this data, and output the result. How do I draw the data from the Rails backend into a form that I can play with in C? (aka getting the data, and then breaking up the cell data into a format that I can run an algorithm on it?) Cheers!

[tabstop]

I'm not sure how you ended up in the Game Programming section, unless there's some significant context missing.

In any rate: I'm assuming your Rails is storing some file somewhere (other than your iPhone). Do you know what format that file is in?

[Salem]

Moved (for now).

[Fordy]

It depends on what database rails is using as a backend.

Is there a .yml file with the database adapter details somewhere in the rails app? If so, look what adapter its using and look for a C library for that backend

Could be mysql (MySQL :: MySQL 5.0 Reference Manual :: 19.8 MySQL C API) or sqlite (An Introduction To The SQLite C/C++ Interface) or whatever...

[jackrabbit]

Yes, it's a mysql database (sorry for posting in the game section, it said something about algorithms). How would I go about implementing this library? Sorry, I'm a bit of a noob- if you could point me in the right direction, that would be amazing :-)

[tabstop]

Those red bits in Fordy's post are links, so maybe you should click them.