← Package directory
Available on winget

Install fselect

Find files with SQL-like queries.

Install with winget
winget install --id fselect.fselect
Upgrade
winget upgrade --id fselect.fselect
Uninstall
winget uninstall --id fselect.fselect

About fselect

Find files with SQL-like queries.

What's new in 0.10.0

- added is_sticky, atime, mtime, ctime, xattr_count and rdev fields - added support for POSIX and Windows ACLs (fields acl, default_acl, has_acl and has_default_acl, functions HAS_ACL_ENTRY, ACL_ENTRY, HAS_DEFAULT_ACL_ENTRY and DEFAULT_ACL_ENTRY) - added support for extended file attributes (fields extattrs and has_extattrs, function HAS_EXTATTR) - support Linux capabilities v2 and v3 - support xattrs on Windows - added many EXIF fields - added datetime functions DAYNAME, DAYOFYEAR, DATE_ADD, DATE_SUB, DATE_DIFF, FROM_UNIXTIME, LAST_DAY - added a parameter to ROUND function - NO_COLOR env var handling is fixed to match the original intent - allow calling zero-arg functions (not only boolean) without parenthesis - a lot of bugs fixed, and stability greatly improved

Read release notes

Version history

Version Updated Notes
0.10.0 Unknown - added is_sticky, atime, mtime, ctime, xattr_count and rdev fields - added support for POSIX and Windows ACLs (fields acl, default_acl, has_acl and has_default_acl, functions HAS_ACL_ENTRY, ACL_ENTRY, HAS_DEFAULT_ACL_EN...
0.9.3 Unknown - improved interactive mode: persistent history, cd and pwd commands - LIMIT now supports offsets with OFFSET keyword or with LIMIT M,N notation - CONTAINS_GREEK function - configurable support for US dates format
0.9.2 Unknown - support subqueries as columns - add PI, FLOOR, CEIL and ROUND functions - improved HTML output formatting - fixed bugs Thanks to @mathrick for another reported issues!
0.9.1 Unknown - complex subqueries which can refer their parent tables #124 - EXISTS / NOT EXISTS operator - CURRENT_TIMESTAMP, CURRENT_TIME functions - filename column (just the name of a file without extension) - improved error repo...
0.9.0 Unknown - subqueries support - bash completion #174 - make checking for hardlinks an optional setting for every search root - new fields exif_exposure_time (or exif_exptime), exif_aperture, exif_shutter_speed, exif_f_number (or...
0.8.12 Unknown - search logic optimized to check files against more lightweight conditions first - supported IN (...list of values...) expression - LEAST and GREATEST functions - LOCATE function - added .awk as a known source code file...
0.8.11 Unknown - bugfixes, including #171 and #172 - added running time measurements for debug mode Thanks again @volodyalipkin for reporting the issues!
0.8.9 Unknown - added ABS, EXP, LN and LOG functions - better support search roots with spaces - fixed various bugs including #150 and #167 Thanks to all contributors and bug reporters! @4censord @paolobarbolini @rickhg12hs 🌃
0.8.6 Unknown - support duration extraction from WAV files - add IS_FONT field for ad hoc font file extensions detection - support .gradle as known source code file extension - add .DJV as another ad hoc known file type
0.8.5 Unknown - added BETWEEN operator #139 - added FORMAT_TIME function #143 - check for updates (optional feature disabled by default) #138 - added mkv duration extractor #140 - added quit and exit commands for interactive mode - ad...
0.8.3 Unknown No notes