ilyabo · March 10, 2024 19:35
diff --git a/index.html b/index.html
 <!DOCTYPE html>
 <html lang="en">
  <head>
    <meta charset="UTF-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1.0" />
    <title>Document</title>
  </head>
  <body>
    <script>
      const getDb = async () => {
        const duckdb = window.duckdbduckdbWasm;
        // @ts-ignore
        if (window._db) return window._db;
        const JSDELIVR_BUNDLES = duckdb.getJsDelivrBundles();

        // Select a bundle based on browser checks
        const bundle = await duckdb.selectBundle(JSDELIVR_BUNDLES);

        const worker_url = URL.createObjectURL(
          new Blob([`importScripts("${bundle.mainWorker}");`], {
            type: 'text/javascript',
          })
        );

        // Instantiate the asynchronus version of DuckDB-wasm
        const worker = new Worker(worker_url);
        // const logger = null //new duckdb.ConsoleLogger();
        const logger = new duckdb.ConsoleLogger();
        const db = new duckdb.AsyncDuckDB(logger, worker);
        await db.instantiate(bundle.mainModule, bundle.pthreadWorker);
        URL.revokeObjectURL(worker_url);
        window._db = db;
        return db;
      };
    </script>
    <script type="module">
      import * as duckdbduckdbWasm from 'https://cdn.jsdelivr.net/npm/@duckdb/[email protected]/+esm';
      window.duckdbduckdbWasm = duckdbduckdbWasm;
      getDb().then(async (db) => {
        // Create a new connection
        const conn = await db.connect();
        // Prepare query
        const query = `select '24:01:01'::time`;
        const stmt = await conn.prepare(query);
        // ... and run the query with materialized results
        document.write(
          '<pre>' +
            'Query: ' +
            query +
            '\n\nResult: ' +
            JSON.stringify((await stmt.query()).toArray()) +
            '<pre>'
        );
      });
    </script>
  </body>
 </html>
	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="UTF-8" />
	<meta name="viewport" content="width=device-width, initial-scale=1.0" />
	<title>Document</title>
	</head>
	<body>
	<script>
	const getDb = async () => {
	const duckdb = window.duckdbduckdbWasm;
	// @ts-ignore
	if (window._db) return window._db;
	const JSDELIVR_BUNDLES = duckdb.getJsDelivrBundles();

	// Select a bundle based on browser checks
	const bundle = await duckdb.selectBundle(JSDELIVR_BUNDLES);

	const worker_url = URL.createObjectURL(
	new Blob([`importScripts("${bundle.mainWorker}");`], {
	type: 'text/javascript',
	})
	);

	// Instantiate the asynchronus version of DuckDB-wasm
	const worker = new Worker(worker_url);
	// const logger = null //new duckdb.ConsoleLogger();
	const logger = new duckdb.ConsoleLogger();
	const db = new duckdb.AsyncDuckDB(logger, worker);
	await db.instantiate(bundle.mainModule, bundle.pthreadWorker);
	URL.revokeObjectURL(worker_url);
	window._db = db;
	return db;
	};
	</script>
	<script type="module">
	import * as duckdbduckdbWasm from 'https://cdn.jsdelivr.net/npm/@duckdb/[email protected]/+esm';
	window.duckdbduckdbWasm = duckdbduckdbWasm;
	getDb().then(async (db) => {
	// Create a new connection
	const conn = await db.connect();
	// Prepare query
	const query = `select '24:01:01'::time`;
	const stmt = await conn.prepare(query);
	// ... and run the query with materialized results
	document.write(
	'<pre>' +
	'Query: ' +
	query +
	'\n\nResult: ' +
	JSON.stringify((await stmt.query()).toArray()) +
	'<pre>'
	);
	});
	</script>
	</body>
	</html>