Loading...
FileQL AmrDeveloper
Use this command to install FileQL:
winget install --id=amrdeveloper.fileql -e A tool that allow you to run SQL-like query on local files
FileQL is a tool designed to enable SQL-like querying on local files, providing an alternative to traditional database operations. It allows users to perform complex file analysis and manipulation using familiar SQL syntax.
Key Features:
- Supports SQL-like queries for selecting, counting, filtering, and aggregating file data
- Enables DISTINCT operations to identify unique parent folders
- Offers CHILDREN_COUNT functionality to determine directory child counts
- Provides pagination support for managing large result sets
Audience & Benefit:
Ideal for developers, data analysts, and system administrators who need to analyze or manage local files without relying on a database. FileQL offers efficient file management capabilities through familiar SQL syntax.
FileQL can be installed via winget.
README
FileQL - File Query Language
FileQL is a tool that allow you to run SQL-like query on local files instead of database files using the GitQL SDK.
Samples
Note that all Keywords in FileQL are case-insensitive, similar to SQL.
SELECT 1
SELECT 1 + 2
SELECT LEN("File Query Language")
SELECT "One" IN ("One", "Two", "Three")
SELECT "File Query Language" LIKE "%Query%"
SELECT * FROM files
SELECT COUNT(path) from files
SELECT DISTINCT parent AS folders FROM files
SELECT CHILDREN_COUNT(parent) FROM files
Files table structure
| Name | Type | Description |
|---|---|---|
| path | Text | File path |
| parent | Text | File parent path |
| extension | Text | Extension of the file |
| is_dir | Boolean | True if it's a directory |
| is_file | Boolean | True if it's a file |
| size | Integer | Size of the file |
Files QL Functions
| Name | Parameters | Return | Description |
|---|---|---|---|
| FILES_COUNT | Text | Integer | Number of children for directory or 0 if it's not valid path |
Download or Install
- Install from Cargo.io
cargo install fileql