Hacker News new | ask | show | jobs
by aikah 4187 days ago
By the way,is there a solution for windows or linux that would take SQL like queries and allows one to search among files in a computer. Something like :

    SELECT All *.jpg as image FROM /myfolder/** where image.creationDate > yesterday and image.size < 100 and image.filename LIKE TRIP% ;
Then either display the result in a window or as text.

Something that would combine find,grep+pipes into something more "userfriendly".

2 comments

You've just described MacOS X's 10 year old Spotlight feature : http://en.wikipedia.org/wiki/Spotlight_%28software%29
For CLI: Cygwin `find` with the -mtime and -size options?

For GUI: Windows search can do this with the datemodified:* and size:* operators, or just click the Search tab in the Explorer ribbon to see buttons