Re: Recfile as a backend DB for Ruby on Rails ?

[Jose E. Marchesi]

> Jose,
>
>
> On 2021-12-05 07:31, Philip Rhoades wrote:
>> Jose,
>> 
>> On 2021-12-03 07:12, Philip Rhoades wrote:
>>> Jose,
>>> 
>>> On 2021-12-03 07:00, Jose E. Marchesi wrote:
>>>>> On 2021-12-03 01:53, Jose E. Marchesi wrote:
>>>>>> Hi there.
>>>>>> 
>>>>>>> I like the idea of keeping my personal data files
>>>>>>> Vim-compatible and
>>>>>>> make good use of VOom, VimWiki, etc - so I am thinking I could
>>>>>>> convert
>>>>>>> my Watched Netflix videos text file into a recfile which would
>>>>>>> be more
>>>>>>> convenient for sorting and organising the info etc.  However,
>>>>>>> it would
>>>>>>> be very nice if that recfile could be used as the DB back end of a
>>>>>>> little RoR web program so siblings etc could look at my watched
>>>>>>> list.
>>>>>>> Has anyone already thought of this? - already done some sort of
>>>>>>> gem
>>>>>>> interface?
>>>>>> I have never used ruby, nor Ruby on Rails.
>>>>>> I guess you would need a way to parse recfiles from ruby?
>>>>> 
>>>>> Well Ruby and Rails usually use the Active Record Query Interface:
>>>>>   https://guides.rubyonrails.org/active_record_querying.html
>>>>> I am not sure where AR came from originally but I found this:
>>>>> "Active Record will perform queries on the database for you and
>>>>> is
>>>>> compatible with most database systems, including MySQL, MariaDB,
>>>>> PostgreSQL, and SQLite. Regardless of which database system you're
>>>>> using, the Active Record method format will always be the same."
>>>>> So it seems that a Ruby Gem is needed to allow AR <=> RecFile . .
>>>>> I would really be starting from scratch trying to work out how to
>>>>> create such a gem but I will ask a question on the Rails list to see
>>>>> if anyone thinks it is a good idea . .
>>>> Nice.  Please let us know how it goes.  I would be nice to see 
>>>> support
>>>> for recfiles in that library.
>>> 
>>> I think it would be a great idea for Rails - currently the default for
>>> trivial sites / fun / testing is sqlite but a recfile DB could be very
>>> useful I think!
>>> I will certainly update this list with anything of interest / 
>>> developments . .
>> 
>> No response so far unfortunately:
>> https://discuss.rubyonrails.org/t/anyone-thought-about-doing-a-gem-that-will-allow-the-active-record-interface-to-talk-to-recfiles/79426
>
>
> I got a response! - I will have a look at the recommended link and see
> if I might be up to the coding task . .

Awesome :)
Thanks.