3 ms·
"The only think I feel is missing is traditional SQL syntax." Presumes everything is relational? I notice the mention of 'advanced database' technology joins,
by bootload 12y ago
"The only think I feel is missing is traditional SQL syntax."
Presumes everything is relational? I notice the mention of 'advanced database' technology joins, and then I notice this example:
$ recsel -e "Dob >> '31 July 1994' && Dob << '01 August 1998'" -p Name,Email acquaintances.rec
So yeah, I sort of agree, what is the standard unified search language? Is it as easy to learn, use as SQL?
"can't compare with SQLLite."
I'd agree with you on JSON/YAML but SQLLite does one thing each of these format/tools do not, converts "readable" text to binary. Text is good for smaller, less structured data. There maybe good reasons to not want it locked up.
There is one area I didn't see in the docs that would make SQLLite to be really useful. A two-way bridge allowing an export/import of the recutils formats allowing both search via SQL, yet maintaining the text format data.