fselect

Find files by name

$ fselect name from [/path] where name = '[*.txt]'

$ fselect name, size from [/path] where size > [1g]

$ fselect name from [/path] where ext = '[jpg]'

$ fselect name, modified from [/path] where modified > [yesterday]

$ fselect name, width, height from [/path] where ext = '[png]'

fselect fields from paths [where conditions] [options]

fselect uses SQL-like syntax to find and query files. It treats the filesystem as a database, selecting attributes and filtering by conditions using familiar SQL syntax.
The tool extracts metadata including size, dates, permissions, and for images and audio, dimensions and tags. Aggregation functions like count and sum work on results.
fselect bridges the gap between find's power and SQL's readability.

FIELDS

Columns to output: name, size, modified, ext, width, etc.

Directories to search.

Filter expressions.

Introduce filter conditions.

Sort results.

Limit output count.

Display help information.

Complex queries may be slow on large directories. Some fields require reading file content. SQL syntax has some limitations.

fselect was created to provide an intuitive query language for file searching. It applies database query concepts to filesystem operations for familiar and powerful searches.

find(1), fd(1), locate(1)