Can I use a text file as my database in ROR?

Question

I would like to use a delimited text file (xml / csv, etc.) as a database replacement in Ruby on Rails. Solutions?

(This is a class requirement, I'd rather use a database if I had a choice.)

I perfectly parse the data and send it to a text file.

Answer 1

The best way, probably, is to use the ActiveModel API and create your methods that parse your files accordingly.

ActiveModel ActiveRelation, , ( . ) Yehuda API ActiveModel

Answer 2

SQLite? .

• .
• , .
• . .
• ACID, .. ..

Answer 3

MySQL CSV. , , - .

I have never set up a Rails project this way, and I don’t know how this will happen, but it looks like it is possible.

HSQLDB seems to work by saving data to disk as an SQL script that creates your database. It records the changes in memory and the log file, and when you close it, it re-creates one SQL script. I myself have not used this myself.

HSQLDB is not one of the supported databases in Rails. I do not know what it will take to add support for the new database.