نکته سریع: Numeromancy، WebAssembly و SingleStoreDB Cloud

CREATE DATABASE IF NOT EXISTS numeromancy;

git clone https://github.com/singlestore-labs/numeromancy

mysql = "22.2.0"

mysql = "23.0.1"

wit-bindgen-rust = { git = "https://github.com/bytecodealliance/wit-bindgen.git" }

wit-bindgen-rust = { git = "https://github.com/bytecodealliance/wit-bindgen.git", rev = "60e3c5b41e616fee239304d92128e117dd9be0a7" }

cargo build --target wasm32-wasi --release

export SINGLESTOREDB_CONNSTRING="mysql://admin:<password>@<host>:3306/numeromancy"

pushwasm --force $SINGLESTOREDB_CONNSTRING --wit ./problem/interface.wit ./target/wasm32-wasi/release/numeromancy_problem.wasm log_regression_infer

pushwasm --force $SINGLESTOREDB_CONNSTRING --wit ./problem/interface.wit ./target/wasm32-wasi/release/numeromancy_problem.wasm log_regression_cost

pushwasm --force $SINGLESTOREDB_CONNSTRING --wit ./problem/interface.wit ./target/wasm32-wasi/release/numeromancy_problem.wasm log_regression_gradient

pushwasm --force $SINGLESTOREDB_CONNSTRING --wit ./problem/interface.wit ./target/wasm32-wasi/release/numeromancy_problem.wasm log_regression_hessian

pushwasm --force $SINGLESTOREDB_CONNSTRING --wit ./problem/interface.wit ./target/wasm32-wasi/release/numeromancy_problem.wasm vec_pack_f64

pushwasm --force $SINGLESTOREDB_CONNSTRING --wit ./problem/interface.wit ./target/wasm32-wasi/release/numeromancy_problem.wasm vec_unpack_f64

[database]
host = "<host>"
port = 3306
user = "admin"
password = "<password>"
database = "cancer_remission"

mysql -u admin -h <host> -P 3306 --default-auth=mysql_native_password -p<password> --local-infile < setup.sql

cargo run --release -p numeromancy-driver

sudo apt install gfortran

ArgminResult:
    param (best):  [58.0382598807061, 24.661290504279627, 19.29324847057158, -19.600904904829974, 3.895979130291112, 0.1510635568225436, -87.43343650294993], shape=[7], strides=[1], layout=CFcf (0xf), const ndim=1
    cost (best):   10.875326142858473
    iters (best):  43
    iters (total): 44
    termination: No change in cost function value
    time:        Some(3.396346349s)

USE cancer_remmission;

SELECT * FROM cancer_remission_confusion();

+---------------+----------------+----------------+---------------+
| true_positive | false_negative | false_positive | true_negative |
+---------------+----------------+----------------+---------------+
|             5 |              4 |              3 |            15 |
+---------------+----------------+----------------+---------------+

SELECT cell, smear, infil, li, blast, temp,
    cancer_remission_infer([1, cell, smear, infil, li, blast, temp]) AS predicted_remission
FROM cancer_remission;

+------+-------+-------+------+-------+-------+--------------------------+
| cell | smear | infil | li   | blast | temp  | predicted_remission      |
+------+-------+-------+------+-------+-------+--------------------------+
|    1 |  0.87 |  0.87 |  0.7 | 1.053 | 0.986 |       0.2908573450870292 |
|  0.9 |  0.75 |  0.68 |  1.3 | 0.519 |  0.98 |       0.6970204491139145 |
| 0.95 |  0.97 |  0.92 |    1 |  1.23 | 0.992 |      0.37658295782152706 |
|  0.5 |  0.44 |  0.22 |  0.6 | 0.114 |  0.99 |    0.0000638724834693532 |
|    1 |  0.63 |  0.63 |  1.1 | 1.072 | 0.986 |       0.6778427646783881 |
|    1 |  0.58 |  0.58 |    1 | 0.531 | 1.002 |      0.24768453374925065 |
| 0.95 |  0.87 |  0.83 |  1.9 | 1.354 |  1.02 |       0.6005257295293988 |
|    1 |  0.45 |  0.45 |  0.8 | 0.322 | 0.999 |      0.16527765831402835 |
| 0.95 |  0.36 |  0.34 |  0.5 |     0 | 1.038 |    0.0008578955974432781 |
| 0.85 |  0.39 |  0.33 |  0.7 | 0.279 | 0.988 |     0.027693373668109336 |
|    1 |   0.9 |   0.9 |  1.1 | 1.037 |  0.99 |       0.5758566835834648 |
|    1 |  0.84 |  0.84 |  1.9 | 2.064 |  1.02 |       0.7257507508234508 |
|    1 |  0.75 |  0.75 |    1 | 1.322 | 1.004 |      0.22816935123559853 |
|    1 |  0.33 |  0.33 |  0.4 | 0.176 |  1.01 |     0.015910019504605355 |
| 0.95 |  0.32 |   0.3 |  1.6 | 0.886 | 0.988 |       0.8510965609291663 |
|    1 |  0.69 |  0.69 |  0.9 | 0.398 | 0.986 |       0.4611791818041166 |
|  0.9 |  0.36 |  0.32 |  1.4 |  0.74 | 0.992 |      0.43509086962553895 |
|  0.8 |  0.88 |   0.7 |  0.8 | 0.176 | 0.982 |      0.15557254876835122 |
|  0.7 |  0.76 |  0.53 |  1.2 | 0.146 | 0.982 |      0.16982726822480884 |
| 0.65 |  0.42 |  0.27 |  0.5 | 0.114 | 1.014 |  0.000054717346377588746 |
|  0.8 |  0.83 |  0.66 |  1.9 |   1.1 | 0.996 |        0.790661732185965 |
|    1 |  0.65 |  0.65 |  0.6 | 0.519 | 0.982 |      0.28007865692320666 |
|  0.8 |  0.46 |  0.37 |  0.4 |  0.38 | 1.006 |    0.0009554334533287413 |
|  0.2 |  0.39 |  0.08 |  0.8 | 0.114 |  0.99 | 0.0000005052130574394507 |
|  0.9 |  0.93 |  0.84 |  0.6 | 1.591 |  1.02 |     0.007444604052869717 |
|    1 |   0.6 |   0.6 |  1.7 | 0.964 |  0.99 |       0.9384652733591272 |
|    1 |  0.73 |  0.73 |  0.7 | 0.398 | 0.986 |      0.27946870781343947 |
+------+-------+-------+------+-------+-------+--------------------------+