| description | Install the Lix JavaScript SDK, write a file, inspect its history, and undo a change. |
|---|
This guide creates an in-memory Lix repository, writes a file, reads its history, and undoes the latest change.
npm install @lix-js/sdkimport { openLix } from "@lix-js/sdk";
const lix = await openLix();
await lix.execute("INSERT INTO lix_file (path, content) VALUES ($1, $2)", [
"/hello.txt",
new TextEncoder().encode("Hello"),
]);
await lix.execute("UPDATE lix_file SET content = $1 WHERE path = $2", [
new TextEncoder().encode("Hello from Lix"),
"/hello.txt",
]);Lix records both writes automatically. You do not need to create commits.
execute() runs one statement. To run several statements atomically, pass an
array of statements to lix.executeBatch(). Do not concatenate SQL into one
script string.
const history = await lix.execute(
`SELECT diff_type, from_path, to_path, lixcol_to_commit_id, lixcol_position
FROM lix_history('lix_file')
WHERE from_path = $1 OR to_path = $1
ORDER BY lixcol_position`,
["/hello.txt"],
);
for (const row of history.rows) {
console.log(row.diff_type, row.from_path, row.to_path);
}Position 0 is the head commit. Higher positions walk back through the
first-parent chain. Read file bytes with lix_as_of at an event endpoint.
await lix.undo();
await lix.close();The repository is in memory and disappears when the process ends. Continue with Storage to save it locally or connect to a server.
