title: Build a BI tool with PHP frameworks / Ruby on Rails
body: <p>I get data from Oracle every 10 minutes, which I then import into a local MySQL database and use that for my data reporting.</p>
  
  <p>However because of the growth of the simple application I build I'm now looking at building a bigger BI solution.</p>
  
  <p>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.</p>
  
  <p>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.</p>
  
  <p>However for my app, it's all read only.</p>
  
  <p>What do you suggest?<br>
  And what do you think is possible?</p>
  
  <p>I'm willing to learn anything new to build an awesome BI tool with this data.</p>
  
  <p>Thank you so much!</p>