1
2
3
4
5
6
7
8
9
10
11
12
13
import { Statement } from "https://esm.town/v/postpostscript/sqliteBuilder";
import { sqlitePublic } from "https://esm.town/v/postpostscript/sqlitePublic";
const start = performance.now();
console.log(
await sqlitePublic.batch([
Statement`SELECT * FROM authIdExampleComments_comment`,
Statement`DELETE FROM authIdExampleComments_comment`,
Statement`INSERT INTO authIdExampleComments_comment VALUES (${"test"}, ${"ing"}, ${"this"}, 1)`,
Statement`SELECT * FROM authIdExampleComments_comment`,
]),
);
console.log("took", performance.now() - start, "ms");
1
2
3
4
5
6
7
8
9
10
11
12
13
import { Statement } from "https://esm.town/v/postpostscript/sqliteBuilder";
import { sqlitePublic } from "https://esm.town/v/postpostscript/sqlitePublic";
const start = performance.now();
console.log(
await sqlitePublic.batch([
Statement`SELECT * FROM authIdExampleComments_comment`,
Statement`DELETE FROM authIdExampleComments_comment`,
Statement`INSERT INTO authIdExampleComments_comment VALUES (${"test"}, ${"ing"}, ${"this"}, 1)`,
Statement`SELECT * FROM authIdExampleComments_comment`,
]),
);
console.log("took", performance.now() - start, "ms");