East Node IO
I/O platform functions for the East language on Node.js. Enables East programs to interact with databases, cloud storage, file transfers, and data formats.
Quick Start
import { East, StringType, NullType } from "@elaraai/east";
import { SQL, Storage } from "@elaraai/east-node-io";
const queryDatabase = East.function([StringType], NullType, ($, userId) => {
const config = $.let({
host: "localhost",
port: 5432n,
database: "myapp",
user: "postgres",
password: "secret",
ssl: East.variant('none', null),
maxConnections: East.variant('none', null),
});
const conn = $.let(SQL.Postgres.connect(config));
$(SQL.Postgres.query(conn, "SELECT * FROM users WHERE id = $1", [East.variant("Integer", 42n)]));
$(SQL.Postgres.close(conn));
});
// Compile with specific module Implementation
const compiled = East.compileAsync(queryDatabase.toIR(), SQL.Postgres.Implementation);
await compiled("user123");
Decision Tree: Which Module to Use
Task → What do you need?
│
├─ SQL Database
│ ├─ SQL.SQLite (embedded, placeholder: ?)
│ │ └─ .connect(), .query(), .select(), .close()
│ ├─ SQL.Postgres (placeholder: $1, $2, ...)
│ │ └─ .connect(), .query(), .select(), .close()
│ ├─ SQL.MySQL (placeholder: ?)
│ │ └─ .connect(), .query(), .select(), .close()
│ └─ SQL.Access (read-only, .mdb/.accdb)
│ └─ .open(), .tables(), .query(), .close()
│
├─ NoSQL Database
│ ├─ NoSQL.Redis (key-value cache)
│ │ └─ .connect(), .get(), .set(), .setex(), .del(), .close()
│ └─ NoSQL.MongoDB (document store)
│ └─ .connect(), .insertOne(), .findOne(), .find(), .updateOne(), .deleteOne(), .close()
│
├─ Storage.S3 (S3-compatible object storage)
│ └─ .putObject(), .getObject(), .deleteObject(), .headObject(), .listObjects(), .presignUrl()
│
├─ Transfer (file transfers)
│ ├─ Transfer.FTP
│ │ └─ .connect(), .put(), .get(), .list(), .delete(), .close()
│ └─ Transfer.SFTP
│ └─ .connect(), .put(), .get(), .list(), .delete(), .close()
│
├─ Format (file parsing)
│ ├─ Format.XLSX (Excel spreadsheets)
│ │ └─ .read(), .write(), .info()
│ └─ Format.XML
│ └─ .parse(), .serialize()
│
└─ Compression
├─ Compression.Gzip (single file)
│ └─ .compress(), .decompress()
├─ Compression.Zip (archive)
│ └─ .compress(), .decompress()
└─ Compression.Tar (archive)
└─ .create(), .extract()
Compiling East Programs
Use specific module implementations:
// Single module
const compiled = East.compileAsync(myFunction.toIR(), SQL.Postgres.Implementation);
// Multiple modules
const compiled = East.compileAsync(
myFunction.toIR(),
[...SQL.Postgres.Implementation, ...Storage.S3.Implementation]
);
Reference Documentation
- API Reference - Complete function signatures, types, and arguments for all modules
- Examples - Working code examples by use case
Available Modules
| Module |
Import |
Purpose |
| SQL.SQLite |
import { SQL } from "@elaraai/east-node-io" |
SQLite database (placeholder: ?) |
| SQL.Postgres |
import { SQL } from "@elaraai/east-node-io" |
PostgreSQL database (placeholder: $1, $2) |
| SQL.MySQL |
import { SQL } from "@elaraai/east-node-io" |
MySQL database (placeholder: ?) |
| SQL.Access |
import { SQL } from "@elaraai/east-node-io" |
Microsoft Access database (read-only, .mdb/.accdb) |
| Storage.S3 |
import { Storage } from "@elaraai/east-node-io" |
S3 and S3-compatible storage |
| Transfer.FTP |
import { Transfer } from "@elaraai/east-node-io" |
FTP file transfers |
| Transfer.SFTP |
import { Transfer } from "@elaraai/east-node-io" |
SFTP file transfers |
| NoSQL.Redis |
import { NoSQL } from "@elaraai/east-node-io" |
Redis key-value store |
| NoSQL.MongoDB |
import { NoSQL } from "@elaraai/east-node-io" |
MongoDB document database |
| Format.XLSX |
import { Format } from "@elaraai/east-node-io" |
Excel spreadsheet parsing |
| Format.XML |
import { Format } from "@elaraai/east-node-io" |
XML parsing and serialization |
| Compression.Gzip |
import { Compression } from "@elaraai/east-node-io" |
Gzip compression |
| Compression.Zip |
import { Compression } from "@elaraai/east-node-io" |
ZIP archive creation/extraction |
| Compression.Tar |
import { Compression } from "@elaraai/east-node-io" |
TAR archive creation/extraction |
Accessing Types
import { SQL, Storage, NoSQL, Format } from "@elaraai/east-node-io";
// Access types via Module.SubModule.Types.TypeName
const postgresConfig = SQL.Postgres.Types.Config;
const sqlResult = SQL.Postgres.Types.Result;
const s3Config = Storage.S3.Types.Config;
const redisConfig = NoSQL.Redis.Types.Config;
const xlsxSheet = Format.XLSX.Types.Sheet;
Connection Pattern
All connection-based modules follow the same pattern:
// 1. Create config
const config = $.let({ /* connection options */ });
// 2. Connect
const conn = $.let(Module.connect(config));
// 3. Perform operations
$(Module.operation(conn, ...args));
// 4. Close connection
$(Module.close(conn));
1---2name: east-node-io3description: I/O platform functions for the East language on Node.js. Use when writing East programs that need SQL databases (SQLite, PostgreSQL, MySQL), NoSQL databases (Redis, MongoDB), S3 storage, file transfers (FTP, SFTP), file format parsing (XLSX, XML), or compression (Gzip, Zip, Tar). Triggers for: (1) Writing East programs with @elaraai/east-node-io, (2) Database operations with SQL.SQLite, SQL.Postgres, SQL.MySQL, NoSQL.Redis, NoSQL.MongoDB, (3) Cloud storage with Storage.S3, (4) File transfers with Transfer.FTP, Transfer.SFTP, (5) Format parsing with Format.XLSX, Format.XML, (6) Compression with Compression.Gzip, Compression.Zip, Compression.Tar.4---56# East Node IO78I/O platform functions for the East language on Node.js. Enables East programs to interact with databases, cloud storage, file transfers, and data formats.910## Quick Start1112```typescript13import { East, StringType, NullType } from "@elaraai/east";14import { SQL, Storage } from "@elaraai/east-node-io";1516const queryDatabase = East.function([StringType], NullType, ($, userId) => {17 const config = $.let({18 host: "localhost",19 port: 5432n,20 database: "myapp",21 user: "postgres",22 password: "secret",23 ssl: East.variant('none', null),24 maxConnections: East.variant('none', null),25 });2627 const conn = $.let(SQL.Postgres.connect(config));28 $(SQL.Postgres.query(conn, "SELECT * FROM users WHERE id = $1", [East.variant("Integer", 42n)]));29 $(SQL.Postgres.close(conn));30});3132// Compile with specific module Implementation33const compiled = East.compileAsync(queryDatabase.toIR(), SQL.Postgres.Implementation);34await compiled("user123");35```3637## Decision Tree: Which Module to Use3839```40Task → What do you need?41 │42 ├─ SQL Database43 │ ├─ SQL.SQLite (embedded, placeholder: ?)44 │ │ └─ .connect(), .query(), .select(), .close()45 │ ├─ SQL.Postgres (placeholder: $1, $2, ...)46 │ │ └─ .connect(), .query(), .select(), .close()47 │ ├─ SQL.MySQL (placeholder: ?)48 │ │ └─ .connect(), .query(), .select(), .close()49 │ └─ SQL.Access (read-only, .mdb/.accdb)50 │ └─ .open(), .tables(), .query(), .close()51 │52 ├─ NoSQL Database53 │ ├─ NoSQL.Redis (key-value cache)54 │ │ └─ .connect(), .get(), .set(), .setex(), .del(), .close()55 │ └─ NoSQL.MongoDB (document store)56 │ └─ .connect(), .insertOne(), .findOne(), .find(), .updateOne(), .deleteOne(), .close()57 │58 ├─ Storage.S3 (S3-compatible object storage)59 │ └─ .putObject(), .getObject(), .deleteObject(), .headObject(), .listObjects(), .presignUrl()60 │61 ├─ Transfer (file transfers)62 │ ├─ Transfer.FTP63 │ │ └─ .connect(), .put(), .get(), .list(), .delete(), .close()64 │ └─ Transfer.SFTP65 │ └─ .connect(), .put(), .get(), .list(), .delete(), .close()66 │67 ├─ Format (file parsing)68 │ ├─ Format.XLSX (Excel spreadsheets)69 │ │ └─ .read(), .write(), .info()70 │ └─ Format.XML71 │ └─ .parse(), .serialize()72 │73 └─ Compression74 ├─ Compression.Gzip (single file)75 │ └─ .compress(), .decompress()76 ├─ Compression.Zip (archive)77 │ └─ .compress(), .decompress()78 └─ Compression.Tar (archive)79 └─ .create(), .extract()80```8182## Compiling East Programs8384**Use specific module implementations:**85```typescript86// Single module87const compiled = East.compileAsync(myFunction.toIR(), SQL.Postgres.Implementation);8889// Multiple modules90const compiled = East.compileAsync(91 myFunction.toIR(),92 [...SQL.Postgres.Implementation, ...Storage.S3.Implementation]93);94```9596## Reference Documentation9798- **[API Reference](./reference/api.md)** - Complete function signatures, types, and arguments for all modules99- **[Examples](./reference/examples.md)** - Working code examples by use case100101## Available Modules102103| Module | Import | Purpose |104|--------|--------|---------|105| SQL.SQLite | `import { SQL } from "@elaraai/east-node-io"` | SQLite database (placeholder: `?`) |106| SQL.Postgres | `import { SQL } from "@elaraai/east-node-io"` | PostgreSQL database (placeholder: `$1`, `$2`) |107| SQL.MySQL | `import { SQL } from "@elaraai/east-node-io"` | MySQL database (placeholder: `?`) |108| SQL.Access | `import { SQL } from "@elaraai/east-node-io"` | Microsoft Access database (read-only, .mdb/.accdb) |109| Storage.S3 | `import { Storage } from "@elaraai/east-node-io"` | S3 and S3-compatible storage |110| Transfer.FTP | `import { Transfer } from "@elaraai/east-node-io"` | FTP file transfers |111| Transfer.SFTP | `import { Transfer } from "@elaraai/east-node-io"` | SFTP file transfers |112| NoSQL.Redis | `import { NoSQL } from "@elaraai/east-node-io"` | Redis key-value store |113| NoSQL.MongoDB | `import { NoSQL } from "@elaraai/east-node-io"` | MongoDB document database |114| Format.XLSX | `import { Format } from "@elaraai/east-node-io"` | Excel spreadsheet parsing |115| Format.XML | `import { Format } from "@elaraai/east-node-io"` | XML parsing and serialization |116| Compression.Gzip | `import { Compression } from "@elaraai/east-node-io"` | Gzip compression |117| Compression.Zip | `import { Compression } from "@elaraai/east-node-io"` | ZIP archive creation/extraction |118| Compression.Tar | `import { Compression } from "@elaraai/east-node-io"` | TAR archive creation/extraction |119120## Accessing Types121122```typescript123import { SQL, Storage, NoSQL, Format } from "@elaraai/east-node-io";124125// Access types via Module.SubModule.Types.TypeName126const postgresConfig = SQL.Postgres.Types.Config;127const sqlResult = SQL.Postgres.Types.Result;128const s3Config = Storage.S3.Types.Config;129const redisConfig = NoSQL.Redis.Types.Config;130const xlsxSheet = Format.XLSX.Types.Sheet;131```132133## Connection Pattern134135All connection-based modules follow the same pattern:136137```typescript138// 1. Create config139const config = $.let({ /* connection options */ });140141// 2. Connect142const conn = $.let(Module.connect(config));143144// 3. Perform operations145$(Module.operation(conn, ...args));146147// 4. Close connection148$(Module.close(conn));149```