Load a database from the server

Jump to bottom Edit New page

Ophir LOJKINE edited this page Jan 29, 2021 · 3 revisions

Here is how to load a database from your server using fetch, and open it with sql.js

const sqlPromise = initSqlJs({
  locateFile: file => `https://path/to/your/dist/folder/dist/${file}`
});
const dataPromise = fetch("/path/to/databse.sqlite").then(res => res.arrayBuffer());
const [SQL, buf] = await Promise.all([sqlPromise, dataPromise])
const db = new SQL.Database(new Uint8Array(buf));

2w