fselect
A command-line tool for finding files with a relaxed SQL-like query syntax.
These buttons open the developer's own site, repository or store listing in a new tab. wares.gg does not host downloads.
1 more ways to get fselect
Package managers
- Chocolatey
choco install fselect
About fselect
fselect finds files using queries written in a SQL-like grammar that is deliberately relaxed and easy to read. It supports complex queries, subqueries for comparing results across several directories, and aggregate functions.
The author notes that it does not aim to fully replace find and ls, but it suits cases where describing the files you want as a query is clearer than chaining find options. It is written in Rust and ships with Bash completion.
Strengths
- Readable SQL-like queries instead of find flags
- Subqueries and aggregate functions
- Can compare results across several directories
Limitations
- Not a complete replacement for find and ls
- Query grammar is SQL-like but not real SQL
Details
- Pricing
- FreeFree and open source, dual licensed under MIT and Apache 2.0.
- License
- MIT OR Apache-2.0
- Developer
- jhspetersson
- Platforms
- Windows, macOS, Linux, Command line
- How it runs
- Downloadable app
- Account
- Not required
- Works offline
- Yes
- Best suited for
- People who find SQL easier to write than find expressions
- Categories
- CLI tools
- Last verified
- Added
- Provenance
- Facts checked against the developer's own pages and store listings, 1 sources on file.
Alternatives to fselect
Compare allSoftware that can replace fselect for an important use case, and what changes if you switch.
fd
Finds files by name without the argument soup that find requires, and it is much faster.
fd uses short name patterns instead of SQL-like queries, respects gitignore by default and runs in parallel, but lacks fselect's aggregate functions and subqueries.
bfs
A breadth-first variant of the UNIX find command that stays compatible with common find versions.
bfs uses the familiar find expression syntax in breadth-first order instead of SQL-like queries, and has no native Windows support mentioned.
plocate
A locate replacement that finds files by name in milliseconds using a trigram posting-list index.
plocate finds files by name from a prebuilt index very quickly, but it is Linux only and cannot query sizes or other attributes like fselect.
Similar software
Related functionality, not necessarily a direct replacement.
ripgrep
Searches a whole directory tree for a pattern in a fraction of the time grep takes, and skips what gitignore says to skip.
erdtree
A multi-threaded command-line tool that shows a directory tree together with disk usage.
tree
A command-line program that lists the contents of directories as an indented tree.
fzf
A fuzzy filter for any list: files, command history, processes, branches, anything you can pipe into it.
pdu (parallel-disk-usage)
A command-line directory tree analyzer that measures disk usage in parallel and prints a size chart.
eza
A replacement for ls with colours, icons, a tree view and Git status in the listing.
