fselect

fselect

TLDR

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']
copy

Find square images

>_ fselect path from [path/to/directory] where width = height
copy

Find old-school rap 320kbps MP3 files

>_ fselect path from [path/to/directory] where genre = [Rap] and bitrate = [320] and mp3_year lt [2000]
copy

Select only the first 5 results and output as JSON

>_ fselect size, path from [path/to/directory] limit [5] into json
copy

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]"
copy

Copied to clipboard
free 100$ digital ocean credit