💾 Archived View for freeshell.de › tldr › fselect.gmi captured on 2023-07-22 at 17:15:48. Gemini links have been rewritten to link to archived content

-=-=-=-=-=-=-

fselect

Find files with SQL-like queries.

More information.

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}"

Copyright © 2014—present the tldr-pages team and contributors.

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

CC-BY