Build on blindrange — Node.js

1Install and connect

npm install blindrange

import { connect, UnsupportedError } from "blindrange";

const db = await connect({
  path: process.env.BR_STATE || "/tmp/blindrange-node-quickstart",
  passphrase: "quickstart passphrase",
  bootstrap: [process.env.BR_BOOTSTRAP || "seed.blindrange.dev:7501"],
  networkSecret: process.env.BR_SECRET || "blindrange-public",
});

2Everything is a statement

await db.execute(`CREATE TABLE orders (
  amount   INT BITS 20 BLUR 64,
  day      INT BITS 16 BLUR 16,
  status   TEXT(6) BLUR 16,
  customer STORED
)`);

await db.execute(`INSERT INTO orders (amount, day, status, customer) VALUES
  (450, 201, 'paid', 'cust-001'),
  (120, 205, 'refunded', 'cust-002'),
  (720, 210, 'paid', 'cust-003')`);

console.log(await db.execute(
  `SELECT customer, amount FROM orders WHERE amount BETWEEN 300 AND 800
   ORDER BY amount DESC`));

[ { customer: 'cust-003', amount: 720 },
  { customer: 'cust-001', amount: 450 } ]

Counts and sums come from index metadata — nothing fetched, nothing decrypted, and the sum arrives with its error bar, which is exactly the resolution you traded for privacy:

console.log(await db.execute(`SELECT COUNT(*) FROM orders`));
console.log(await db.execute(`SELECT APPROX SUM(amount) FROM orders`));

[ { count: 3, basis: 'exact-to-leaf' } ]
[ { sum: 1310.5, plus_minus: 96, rows: 3 } ]

await db.execute(`UPDATE orders SET status = 'shipped' WHERE amount = 450`);
await db.execute(`DELETE FROM orders WHERE day > 208`);

3Refusals arrive typed

Everything the engine genuinely cannot do — JOIN, OR, exact SUM(), leading-wildcard LIKE — rejects with UnsupportedError, whose message names why and what to use instead. A boundary is never dressed up as a bug:

try {
  await db.execute(`SELECT SUM(amount) FROM orders`);
} catch (e) {
  if (e instanceof UnsupportedError) console.log("refused:", e.message);
}

The full refusal table, with reasons, is in the SQL guide.

4How this package works, honestly