filesql

Running SQL-like queries on files.

Features

Supported:

REPL
Basic SQL expressions.
INSERT clause. (which inserts data into another file)
WHERE clause.
ORDER BY clause. (Only in-memory sorting)
LIMIT clause.

Todo:

GROUP BY clause. (in-memory)
GROUP BY clause. (external storage)
ORDER BY clause. (external storage)
Optimization.
...

Sample

Query countries list top rated by Covid-19 infected cases:

$ target/release/filesql -f testcases/select-top-10-infected-and-calc-death-rate.sql

Outputs:

+---------+--------------+----------------+-----------------+-------------+---------------------+
| country | infected_new | infected_total | recovered_total | death_total | death_rate          |
+---------+--------------+----------------+-----------------+-------------+---------------------+
| 美国    | 92226        | 47314139       | 37311667        | 775104      | 1.638207978380416   |
+---------+--------------+----------------+-----------------+-------------+---------------------+
| 印度    | 11210        | 34355184       | 33741010        | 460788      | 1.341247364589868   |
+---------+--------------+----------------+-----------------+-------------+---------------------+
| 巴西    | 13321        | 21874324       | 21062218        | 609417      | 2.785992380838832   |
+---------+--------------+----------------+-----------------+-------------+---------------------+
| 英国    | 33697        | 9272066        | 7560948         | 141743      | 1.5287099983973367  |
+---------+--------------+----------------+-----------------+-------------+---------------------+
| 乌干达  | 85           | 9126570        | 96878           | 3227        | 0.03535829999660332 |
+---------+--------------+----------------+-----------------+-------------+---------------------+
| 俄罗斯  | 41335        | 8795095        | 7561978         | 246814      | 2.806268721372538   |
+---------+--------------+----------------+-----------------+-------------+---------------------+
| 土耳其  | 28193        | 8206375        | 7680152         | 71927       | 0.8764771290612481  |
+---------+--------------+----------------+-----------------+-------------+---------------------+
| 法国    | 8998         | 7208937        | 6971152         | 117900      | 1.6354699728961426  |
+---------+--------------+----------------+-----------------+-------------+---------------------+
| 伊朗    | 6803         | 5987814        | 5601764         | 127299      | 2.1259678406844302  |
+---------+--------------+----------------+-----------------+-------------+---------------------+
| 阿根廷  | 1271         | 5296188        | 5162713         | 116091      | 2.1919727925066104  |
+---------+--------------+----------------+-----------------+-------------+---------------------+
10 rows selected.

Supported file formats

CSV/TSV

You might also like...

fast & easy CLI and vscode extension specialized to format MySQL INSERT queries.

insertfmt fast & easy CLI specialized to format MySQL INSERT queries. format queries so that they look like a table. NOTE: If you wanna use the VSCode

7 May 2, 2023

TDS 7.2+ (mssql / Microsoft SQL Server) async driver for rust

Tiberius A native Microsoft SQL Server (TDS) client for Rust. Supported SQL Server versions Version Support level Notes 2019 Tested on CI 2017 Tested

189 Dec 25, 2022

Query LDAP and AD with SQL

SQLDAP Ever wanted to query AD or LDAP with SQL like queries ? I'm going to answer this question myself: yes ! Why ? Because I never could remember al

9 Nov 15, 2022

FeOphant - A SQL database server written in Rust and inspired by PostreSQL.

A PostgreSQL inspired SQL database written in Rust.

27 Dec 7, 2022

GlueSQL is a SQL database library written in Rust

GlueSQL is a SQL database library written in Rust. It provides a parser (sqlparser-rs), execution layer, and optional storage (sled) packaged into a single library.

2.1k Jan 8, 2023

Tool to automate the visualisation of UML dependencies from a SQL file

Doteur A simple tool to draw your mysql relations from exports. Help us If you use the tool, and like it, don't forget to add a star to the project on

89 Nov 9, 2022

Fully typed SQL query builder for Rust [deprecated]

What is Deuterium? Deuterium is a fancy SQL builder for Rust. It's designed to provide a DSL to easily build SQL queries in safe and typed way. Like R

169 Nov 20, 2022

Ormlite - An ORM in Rust for developers that love SQL.

ormlite ormlite is an ORM in Rust for developers that love SQL. It provides the following, while staying close to SQL, both in syntax and performance:

28 Jan 1, 2023

Distributed SQL database in Rust, written as a learning project

toyDB Distributed SQL database in Rust, written as a learning project. Most components are built from scratch, including: Raft-based distributed conse