Roy Hashimoto

I created a [pull request](https://github.com/modernweb-dev/web/pull/1842) for the docs that adds an example of how to (mis)use the transform hook to send custom HTTP headers.

You can proxy to a REST service: https://modern-web.dev/guides/dev-server/proxy-to-other-servers/ Or you can implement a service in a serve hook: https://modern-web.dev/docs/dev-server/writing-plugins/hooks/#hook-serve

Both IndexedDB and OPFS access handles can be used for persistent SQLite storage in the browser. At the moment it appears that neither is clearly better than the other for...

I can't think of any reason for that much disparity in timings, all things being equal. A good place to start is to check if all things are in fact...

The query plans look pretty close - there are some differences but that could be just reporting changes from the SQLite versions. The first thing I would try is explicitly...

The VFS logs you provided show reads made from temporary files, not the main database (the filename is random, and the reads are 4K blocks). The video shows that reads...

OPFS beats IndexedDB in in raw I/O performance and having a mostly synchronous API, but there are still quite a few reasons a particular application might prefer IndexedDB: * OPFS...

Answers to your questions: 1. That would be one of my guesses. I'm not sure of the best way to monitor available memory in C. 2. I don't know but...

> The error typically takes ~2 days to show up, where the database is used for ~10 queries per minute. Once this error happens, it continues happening for each subsequent...

I can see an error with the repo and the instructions. With a debug wa-sqlite build, I get: > Query (sql: "SELECT * FROM osquery_info") failed: RuntimeError: Aborted(RuntimeError: unreachable). "unreachable"...