jhspetersson/fselect
Fselect
fselect is a command line utility and file metadata query engine that uses SQL-like syntax to filter and find files based on their attributes. It functions as a file system analysis tool capable of selecting files and directories using relational logic, subqueries, and structured data filtering.
The tool distinguishes itself by integrating Git tracking status and branch metadata into the search process while respecting project ignore files. It also includes a specialized media metadata search capability that filters audio and image files by technical properties such as resolution, bitrate, and EXIF tags.
The project covers a broad range of capabilities, including file system forensics through SHA-256 hash inspection and POSIX permission auditing. It supports complex pattern matching with regular expressions and globs, content searching within file bodies and ZIP archives, and the calculation of aggregate statistics like sums and averages across result sets.
Users can execute queries through an interactive read-eval-print loop or export structured results into formats such as CSV and JSON for external reporting.
Features
- File System Querying - Uses a relaxed SQL grammar to filter, select, and sort files and directories based on their attributes.
- Relational File Searching - Provides advanced file system searching using complex SQL queries, boolean logic, and regular expressions.
- Git Status Filters - Filters files based on Git tracking status, current branches, and commit metadata.
- Statistical Aggregators - Computes summary statistics like minimum, maximum, average, and sum for file properties across result sets.
- SQL-like Queries - Translates SQL-like syntax into logical execution plans to filter and select files based on attributes.
- Local File Query Engines - Functions as a high-performance engine for selecting files and directories using relational logic and subqueries.
- Metadata Filtering - Evaluates file properties and technical metadata as relational columns to enable complex search logic.
- File Metadata Filters - Filters files using attributes such as size, MIME type, file hashes, and POSIX ACLs.
- Git-Aware File Listings - Integrates Git tracking status and branch metadata directly into file search and listing results.
- Metadata Integration - Integrates Git tracking status and branch metadata directly into the file search process.
- File System Statistics - Provides capabilities to compute aggregate statistics such as sums and averages across file sets.
- Ignore File Parsers - Respects .gitignore and other ignore-file configurations to exclude files from search results.
- Metadata-Based Media Searches - Filters audio and image files using technical metadata including resolution, bitrate, and EXIF tags.
- Aggregate Calculations - Implements SQL-style aggregation functions to calculate sums, averages, and counts across file result sets.
- Virtual Filesystems - Unifies physical disks, ZIP archives, and web environments into a single virtual directory structure for querying.
- Media Library Managers - Locates images and audio files based on embedded technical metadata like resolution and bitrate.
- File-Type Search Filtering - Identifies files by category, such as images or source code, using boolean shortcuts.
- System File Indexers - Accelerates file discovery by integrating with existing system indexes to avoid expensive recursive directory traversals.
- File Timestamp Filtering - Matches files based on creation, modification, or access timestamps using absolute dates or relative time intervals.
- Regex-Based File Content Searches - Locates files by searching for specific text strings or regular expressions within the file bodies.
- Git Repository Explorers - Allows searching for files within projects while filtering by branch status and commit metadata.
- File Pattern Matching - Finds files using standard globs, SQL-style LIKE patterns, and regular expressions.
- Read-Eval-Print Loops - Features an interactive REPL for executing file queries and navigating directories.
- Media Metadata Filtering - Filters audio and image files using technical metadata such as resolution, bitrate, and EXIF tags.
- Database REPL Shells - Provides an interactive shell for executing SQL-like queries and navigating directories without shell escaping.
- File Hashing Utilities - Calculates SHA-256 checksums to identify duplicate files and verify data integrity.
- POSIX Permission Auditing - Filters files by ownership, mode, SUID bits, sticky bits, POSIX ACLs, and Linux capabilities.
- Local Forensic File Scanning - Performs forensic analysis by calculating SHA-256 hashes and auditing POSIX permissions.
- File Set Relational Comparisons - Compares files across different directories using correlated subqueries and relational operators like IN and EXISTS.
- CLI Utilities - Find replacement with SQL-like syntax.
- Search and Discovery - Find files with SQL-like queries.
- Terminal Productivity - SQL-like file search queries.
- File Management - SQL-like file search utility.
Star history
How this analysis was created: This summary and feature list are AI-generated from collected project material and can contain mistakes. Stars, license and language are imported from GitHub. Inclusion does not mean that we have tested or audited this project. Check the source documentation for any feature you depend on. Learn more on our About page.
