← 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.2

- support plocate and Everything #98 - added word_count, char_count, encoding, has_bom, line_ending fields - added git-related fields - added blksize, atime_nsec, mtime_nsec, ctime_nsec fields - added symlink_target and is_broken_symlink fields - support extattrs and acl fields on Windows - support metadata extraction for FLAC, Ogg Vorbis, Opus, and several other formats - added mp3_comment, mp3_track, and mp3_disc fields - added .qml to the known source file extensions - optimized number of syscalls #175 - fixed bugs related to grouping and subqueries Thanks to @akneni and @dsully for raising the issues that inspired these new feature ideas!

Read release notes

Version history

Version Updated Notes
0.10.2 Unknown - support plocate and Everything #98 - added word_count, char_count, encoding, has_bom, line_ending fields - added git-related fields - added blksize, atime_nsec, mtime_nsec, ctime_nsec fields - added symlink_target and...
0.10.1 Unknown - support subqueries in the FROM clause - support positional GROUP BY - support EXTRACT and DATE_TRUNC functions - parse "t" and "f" as truthy values - fixed panic when parsing invalid datetimes #184 - optimized release...
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