absurd-sql

absurd-sql copied to clipboard

Hello, I've enabled Discussions and all general questions/discussions should happen there, not here. I will close issues that don't have a specific technical problem they are addressing. I've also posted...

jlongster

Split the async fs interface, indexedDB, and sqlite-specific code

8

Hello ! This is very useful work you have been doing here. If I understand well, this repository contains both the `Atomic` and Shared Array Buffer logic required to provide...

lovasoa

My application's domain logic is already in a web-worker; is the additional worker abstraction necessary in this case? Is there a trick to using absurd-sql in this manner? I'm unable...

AdventureBeard

WAL Mode

1

Awesome work! I was playing around with the SQLite VFS mechanism myself [back in February](https://github.com/antimatter15/sqlite-vfs-js)— But I hadn't thought of your clever `Atomics.wait` approach. In the blog post, you mention:...

antimatter15

IDB name is undefined

6

I am using the latest version of the absurd-sql + your sql.js (0.0.53). When I do this: main: ```typescript function init() { let worker = new Worker( new URL('./SqlNotesRepository.worker.js', import.meta.url),...

quolpr

Alternate solution for sync IDB calls in Safari?

5

Hi! Congrats for this project! It has the potential of a game changer. I was actually having the same idea after reading [hosting-sqlite-databases-on-github-pages](https://phiresky.github.io/blog/2021/hosting-sqlite-databases-on-github-pages/) earlier this summer. But ideas are one...

dfahlander

Multiple Windows (Safari and WKWebView)

2

First congratulations to your genius approach. It looks promising to solve many issues I face in my projects. Thanks for sharing this solution! In particular for Safari and WKWebView I...

holtwick

IDB benchmark would probably be faster with `getAll()`

4

Hey, this is an awesome project and really technically impressive. Hats off! Just wanted to point out that [the IDB benchmark for summing each item](https://github.com/jlongster/absurd-sql/blob/74af8d5005c4c668b8117e55acfe1499056fdca7/src/examples/bench/queries-raw-idb.js#L46-L71) would probably be faster using...

nolanlawson

Call for help: webkitFileSystem backed

3

I have already written a backend using `webkitFileSystem`: https://gist.github.com/jlongster/ec00ddbb47b4b29897ab5939b8e32fbe I did it somewhat naively though. It's _way_ slower because I don't know how to do bulk reads/writes. I can't find...

jlongster

The change counter in the sqlite header isn't *always* updated

3

I see "Once we’ve grabbed a readwrite transaction, we can read some bytes from the file which represent SQLite’s “change counter”. If that counter is the same as what we...

pkhuong