sql-rs

sql-rs: A Neon based brige for the Rust sqlparser-rs

Installing sql-rs

Installing sql-rs requires a supported version of Node and Rust.

You can install the project with npm.

$ npm install sql-rs

This fully installs the project, including installing any dependencies and running the build.

Using sql-rs

Currently you need to manually parse the JSON returned by the parse_sql_to_json_string function. This is because there's currently no easy way to convert all of the Rust sqlparser::ast structs to JavaScript objects.

const { parse_sql_to_json_string } = require('sql-rs')
const sql = "SELECT id, name FROM users WHERE age > 25"
const ast = JSON.parse(parse_sql_to_json_string(sql))

Available Scripts

In the project directory, you can run:

npm install

Installs the project, including running npm run build.

npm build

Builds the Node addon (index.node) from source.

Additional cargo build arguments may be passed to npm build and npm build-* commands. For example, to enable a cargo feature:

npm run build -- --feature=beetle

npm build-debug

Alias for npm build.

npm build-release

Same as npm build but, builds the module with the release profile. Release builds will compile slower, but run faster.

npm test

Runs the unit tests by calling cargo test. You can learn more about adding tests to your Rust code from the Rust book.

Project Layout

The directory structure of this project is:

sql-rs/
├── Cargo.toml
├── README.md
├── index.node
├── package.json
├── src/
|   └── lib.rs
└── target/

Cargo.toml

The Cargo manifest file, which informs the cargo command.

index.node

The Node addon—i.e., a binary Node module—generated by building the project. This is the main module for this package, as dictated by the "main" key in package.json.

Under the hood, a Node addon is a dynamically-linked shared object. The "build" script produces this file by copying it from within the target/ directory, which is where the Rust build produces the shared object.

src/

The directory tree containing the Rust source code for the project.

src/lib.rs

The Rust library's main module.

target/

Binary artifacts generated by the Rust build.

Learn More

To learn more about Neon, see the Neon documentation.

To learn more about Rust, see the Rust documentation.

To learn more about Node, see the Node documentation.