3 ms·
The only think I feel is missing is traditional SQL syntax. This makes it much harder to use as a drop-in replacement where someone would actually otherwise use
by falcolas 12y ago
The only think I feel is missing is traditional SQL syntax. This makes it much harder to use as a drop-in replacement where someone would actually otherwise use the competitors mentioned on their homepage.
I think its real competition is SQLLite and JSON / YAML, and it definitely has some benefits over the text formats, it can't compare with SQLLite.
- mhuffman 12y agoThere are applications that let you query structured text with SQL. For example, https://github.com/dinedal/textql https://github.com/dinedal/textql there are others as well.
- networked 12y agoThere is a lot of tools of this kind [1] but nearly all of them work with CSV or other delimiter-separated data. What made recutils stand out for me is that it has tools to modify files in place, not just select data from them, and its file format is different. The rec format is interesting because it is a specification for what others have used before without one. It seems quite readable and does not suffer from the ",,,,,," problem of CSV. [1] Here's the list of ones I have run into so far: * https://github.com/harelba/q https://github.com/harelba/q * https://github.com/tobimensch/termsql https://github.com/tobimensch/termsql * https://github.com/samuel/squawk https://github.com/samuel/squawk * https://github.com/tjunier/sqawk https://github.com/tjunier/sqawk I've also written one: https://github.com/dbohdan/sqawk https://github.com/dbohdan/sqawk. It turned out I wasn't the only one to come up with the name.
- 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.