title: Inserting thousands of records to Postgresql with RoR
body: <p>I will be creating an app which will receive for instance 100.000 XML records daily via API. My programming language will be Ruby on Rails and I am thinking of using Postgresql along with Amazon's RDS.</p>
  
  <p>Then I will save these info to my database and send (POST) these data (via XML/API) to another web platform. </p>
  
  <p>My question is, what is the best way to handle these kind of data? Do you think Amazon RDS is enough? or should I use some any other database rather than Postgresql?</p>
  
  <p>Thank you </p>
  
  <p><strong>EDIT:</strong></p>
  
  <p>I'am assuming the 100.000 XML data will be coming during the day between 10:00am - 10:00pm. This is from 1 customer. When the number of customer increases, I will need to scale. Because the operation will be like that; </p>
  
  <ol>
  <li>XML data comes to my app. </li>
  <li>I will save those data to my database (postgresql) </li>
  <li>Then I will post those data to some other app. </li>
  </ol>
  
  <p>At the beginning I can use Amazon's RDS with maybe 1 instance. But then I have to scale the app. I would like to create the database structure for the future scenario. </p>
  
  <p>What would you recommend ? What tools should I use with RDS? </p>
  
  <p>I am also thinking to differentiate between my UI (website) and API which means I will set up my UI in another server and API to another server. In the UI part I will have user auth, search users etc. </p>