From a37f86e89dc01f884a1b4474c27c79d5932093a0 Mon Sep 17 00:00:00 2001
From: Jarred Sumner <jarred@jarredsumner.com>
Date: Mon, 16 May 2022 15:46:20 -0700
Subject: `bun:sqlite` (#167)

* :scissors:

* Add the slow version

* draw the rest of the owl

* Fix crash when allocating lots of memory

* [Bun.Transipiler] Support passing objects

* [JS Parser] Support passing objects to macros via Bun.Transpiler

* Update JSSQLStatement.cpp

* Embed SQLite

* Add SQLite to Dockerfile

* [sqlite] Add quick one-off queries without creating a whole object

* [sqlite] Add `columnsCount`, rename raw() to `values()`, remove `rebind`

* Implement `bun:sqlite`

* return null

* Fix updating query

* Update bun.d.ts

* more tests

* Support variadic arguments, write tests and add types

* Update sqlite.d.ts

* Update sqlite.d.ts

* latest

* Implement `Database.loadExtension` and `Database.setCustomSQLite`

* Support `require.resolve`

* [napi] Improve string performance

* [bun.js] Support some of `node:module`

* another test

* [sqlite] Support serialize & deserialize

* [`bun:ffi`] Implement `CFunction` and `linkSymbols`

* [bun.js] Fix crash in `Buffer.from`

* Update sqlite.test.js

* Document linkSymbols

* docs

* Update README.md
---
 bench/sqlite/query.deno.js | 26 ++++++++++++++++++++++++++
 1 file changed, 26 insertions(+)
 create mode 100644 bench/sqlite/query.deno.js

(limited to 'bench/sqlite/query.deno.js')

diff --git a/bench/sqlite/query.deno.js b/bench/sqlite/query.deno.js
new file mode 100644
index 000000000..d3ff0f6f9
--- /dev/null
+++ b/bench/sqlite/query.deno.js
@@ -0,0 +1,26 @@
+import { DB } from "https://deno.land/x/sqlite/mod.ts";
+import { bench, run } from "https://esm.run/mitata";
+const db = new DB("/tmp/northwind.sqlite");
+
+{
+  const sql = db.prepareQuery(`SELECT * FROM "Order"`);
+  bench('SELECT * FROM "Order"', () => {
+    sql.allEntries();
+  });
+}
+
+{
+  const sql = db.prepareQuery(`SELECT * FROM "Product"`);
+  bench('SELECT * FROM "Product"', () => {
+    sql.allEntries();
+  });
+}
+
+{
+  const sql = db.prepareQuery(`SELECT * FROM "OrderDetail"`);
+  bench('SELECT * FROM "OrderDetail"', () => {
+    sql.allEntries();
+  });
+}
+
+run({ json: false });
-- 
cgit v1.2.3