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

Lakefront needs Bun 1.2 or later (it ships TypeScript source, so Node can't run it) and a Postgres for its catalog. The quickstart starts one with a short compose file.

import { open } from "lakefront";

const engine = await open({
  postgres: "postgres://lakefront:lakefront@127.0.0.1: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);

Learn more

• Quickstart
• Fundamentals
• Performance
• API reference
• Changelog

Contributing

See CONTRIBUTING.md for setup and tests, and SECURITY.md to report a vulnerability.

Lakefront is pre-1.0, and a lake written by one version may not open under the next. Apache-2.0.