Import CSV in H2 DB of grails

Question

This is a continuation to the question : Grails with CSV (No DB)

I have three CSV files as my backend(in shared drive), which are constantly being updated by the greenplum DB (rows being appended) and I want to import these files in the H2DB (default) of grails and then use these files. The CSV files are 3mb, 30mb and 60 mb in size and the last one has 550,000 rows. These CSV files are updated hourly with new data(appending rows)

The scheduling can be done by Quartz here. Quick questions :

1. Is this feasible? Can H2 DB store this much data? While deploying the app, will the WAR file then store all this data? Will the users not have to install any other DB then when this application is deployed ?

2. Secondly, is it possible to store these files in MongoDB, which can be hosted in one machine and the datasource can be configured to take the data from this machine only?

3. Basically, when the application is deployed, I don't want users to install any thing (except the servlet container like Apache, which I'm guessing is compulsory, or is it not? They should just use the WAR file and run the application. Am I correct/wrong here?

Answer 1

1. Is this feasible? Yes. H2 can stored the data to disk, there is an in-memory mode (see the docs).

2. Is it possible to store these files in MongoDB? Yes... but why would you want to do that?