kashav/fsql
Fsql
fsql is a command line interface tool that provides a SQL-like query language for finding files and directories on a local disk. It functions as a filesystem query engine, allowing users to isolate files by executing structured statements against metadata instead of using standard command line flags.
The tool features an interactive read-eval-print loop that supports multi-line queries and recursive subqueries, where the results of nested search operations serve as criteria for outer queries. Search scopes are configurable through the resolution of absolute paths, relative paths, environment variables, and glob patterns.
The system applies algebraic operators, regular expressions, and logical filters to file attributes such as hash, size, and modification time. It includes data transformation utilities to format these attributes into human-readable timestamps and standardized size units.
Features
- SQL-like Queries - Translates structured SQL-like text queries into an internal representation for filtering filesystem metadata.
- Filesystem Query Languages - Implements a SQL-like query language for discovering files and directories based on metadata and attributes.
- Interactive Data Querying Tools - Provides a terminal-based interface for querying, filtering, and exploring structured filesystem data in real-time.
- Filesystem Metadata Filtering - Provides filtering based on filesystem attributes such as file size, modification date, and directory depth.
- Filesystem Querying - Implements a structured query language for executing complex searches and subqueries against local file attributes.
- SQL Metadata Search - Locates files and folders by executing SQL-like statements against filesystem metadata.
- File Management CLI Tools - Provides a command-line tool for isolating files based on algebraic operators, regular expressions, and system properties.
- Complex Filesystem Filtering - Isolates files using complex logical operators and regular expressions applied to properties like size and hash.
- Read-Eval-Print Loops - Maintains an interactive session that accepts multi-line queries for immediate execution against the local disk.
- SQL Command Line Interfaces - Offers a terminal-based interface for finding files and directories using a SQL-inspired query language.
- File Search by Attribute - Locates files by applying algebraic operators and regular expressions to attributes like size and modification time.
- Interactive Read-Eval-Print Loops - Ships a read-eval-print loop environment for running multi-line filesystem queries without standard shell input.
- Filesystem Discovery Utilities - Locates specific files and directories on a local disk using advanced filters and attribute-based queries.
- Filesystem Path Scopes - Provides flexible search scope configuration using absolute paths, relative paths, environment variables, and glob patterns.
- Subquery Execution - Evaluates nested filter clauses by using the results of inner search operations as criteria for outer queries.
- Nested Subquery Integration - Enables the execution of nested queries within filter clauses to refine search results based on other search outputs.
- Glob Pattern Resolvers - Expands search scopes by resolving environment variables and wildcards into concrete filesystem directory lists.
- Local Filesystem Explorers - Provides an interactive tool for navigating and refining file searches on the local directory structure.
