fselect

> Find files with SQL-like queries.

Select full path and size from temporary or config files in a given directory:

fselect size, path from {path/to/directory} where name = {'*.cfg'} or name = {'*.tmp'}

Find square images:

fselect path from {path/to/directory} where width = height

Find old-school rap 320kbps MP3 files:

fselect path from {path/to/directory} where genre = {Rap} and bitrate = {320} and mp3_year lt {2000}

Select only the first 5 results and output as JSON:

fselect size, path from {path/to/directory} limit {5} into json

Use SQL aggregate functions to calculate minimum, maximum and average size of files in a directory:

fselect "{MIN(size), MAX(size), AVG(size), SUM(size), COUNT(*)} from {path/to/directory}"

> This work is licensed under the Creative Commons Attribution 4.0 International License (CC-BY).

-- Response ended

-- Page fetched on Tue May 21 04:46:30 2024