lakefront

Lakefront property for your lakehouse.

Lakefront is an HTAP engine for TypeScript on Bun. Writes commit durably to Postgres, reads come from per-board DuckDB replicas, and the same data answers both point lookups and analytical queries, with no ETL pipeline in between.

Documentation: lakefront.folsomintelligence.com

Install

bun add lakefront

Requires Bun 1.2 or later. The package ships TypeScript source, so Node can't run it. You also need a Postgres for the catalog; the quickstart starts one with a short compose file.

import { open } from "lakefront";

const engine = await open({
  postgres: "postgres://lakefront:[email protected]:5432/lakefront",
  data: "./data",
});

await engine.insertMany("tasks", [{ id: "task-1", title: "Ship the thing" }]);

const read = (await engine.query("tasks", "SELECT id, title FROM {{table}}")).unwrap("read");
console.log(read.result.rows);

Links

• Quickstart
• API reference
• Changelog
• Repository

Apache-2.0.