FastQX

A DataFetch lib written in Rust, works for both Rust and Python. Powered by pyo3 & maturin.

Sources:

• Sql (MsSql/MySql/Postgresql/Sqlite)
• Csv
• Http (Json)

Data Helper:

• owned
• idx

Data Operators:

• apply
• group
• select
• reduce
• fold
• agg
• cum_agg
• compare
• filter
• sort
• position
• merge
• join
• pivot
• melt
• explode
• window
• rolling
• expand
• concat
• combine
• arithmetic

Quick Start for Rust

Data construction:

use fastqx::fqx;

// create a `null` value
let a = fqx!();
println!("{:?}", a);

// create a value
let a = fqx!(1);
println!("{:?}", a);

// create an empty row
let a = fqx!(());
println!("{:?}", a);

// create a row
let a = fqx!(1, "ab", 2.0);
println!("{:?}", a);

// create a data
let a = fqx!(
    (1, "a", 1.1),
    (2, "b", fqx!()),
    (3, "c", 3.3),
    (4, "d", 4.4),
    (5, "e", 5.5),
);
println!("{:?}", a);

Other test cases in Rust:

• Dynamic Sql save & fetch
• Static Sql save & fetch

Quick Start for Python

• Sql query
• Csv read & write
• Data type casting
• Py DataClass conversions
• Pandas DataFrame conversions
• Py Dict conversions
• Py data constructions
• Data slicing
• Http curl
• MsSql connection
• MsSql save & fetch
• Data operation: agg/cum_agg
• Data operation: apply
• Data operation: filter
• Data operation: group
• Data operation: join
• Data operation: merge
• Data operation: reduce
• Postgresql connection
• Postgresql save & fetch
• Sql type
• Data type

Dev

• Install Python dependencies: make devenv-init

• Build Python package: make install