I'm looking for a way to browse through some CSV unicode-encoded files. These files have relatively large number of rows (2-3 millions) and 10 columns tops, with columns being numerical, small text fields, dates or single paragraphs of text (total weight: about 300MB per file). I need to apply basic search and filtering (“show only rows where column X has value Y”, “search for this word in this column among the filtered rows”). Ease of use is top priority, as it will be used by inexperienced users.
I don't need to edit those files, just browsing.
Spreadsheets are out — they don't handle that many rows (the best of them have a limit of 1 million rows). I thought of a tool like OpenRefine, but last time I tried to load my example file, it ate 8GB of memory and started swapping before even loading half of the file.
The existing relational database systems I know (OOo Base, Access) have too complex UI to deal with all the complexity of the relational model, which would make using it for a single table a chore for an inexperienced user.
How can I best allow these inexperienced users to browse and filter this data?