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

[Philip Rhoades]

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 . .

Regards,

Phil.

--
Philip Rhoades

PO Box 896
Cowra  NSW  2794
Australia
E-mail:  phil@pricom.com.au