I get data from Oracle every 10 minutes, which I then import into a local MySQL database and use that for my data reporting.
However because of the growth of the simple application I build I'm now looking at building a bigger BI solution.
My only problem is that the data I get in doesn't have a primary id in the database, I import it with mysqlimport and the database tables have MEMORY engine.
So I started a bit in Rails (with beginners knowledge) and got stuck on the primary id part, and rails like a lot of other PHP frameworks assume I will do CRUD.
However for my app, it's all read only.
What do you suggest?
And what do you think is possible?
I'm willing to learn anything new to build an awesome BI tool with this data.
Thank you so much!