FRESH

Hacker News

Stoolap/Node: A Native Node.js Driver That's Surprisingly Fast

27 points by murat3ok

by dspillett

1 subcomments

> But notice the pattern: SQLite’s wins are on simple, single-row operations where both databases are already sub-millisecond. Stoolap’s wins are on the analytical and complex queries where the difference is 10x to 100x+.
So for a great many workloads, particularly multi-user, SQLite will be faster overall, as most application workloads will have many simple single/few row lookup operations per single/few row update operations, and an order of magnitude less complex analytical queries.
But this should be much faster for genuine analytical operations, and better suited to them due to support for things like temporal storage and queries.
Basically the age-old distinction between optimising for OLTP or OLAP operations.

by ramon156

1 subcomments

I would like to see the actual test harness. A 100x improvement is do-able (you're trimming features basically) but I would like to see how you tested it

by z3t4

2 subcomments

I dont think the micro benchmarks are fair, as it really doesn't matter if something takes 0.01 ms or 0.001 ms even if its 10x faster.

by pdyc

0 subcomment

interesting, github says works for both olap+oltp but it was for go, does the same apply to rust as well? I want to try it in browser is wasm available somewhere or is there any plan to support it? [Edit] looks like it is available for browser here https://stoolap.io/playground/ i will be trying it with my product this weekend, excited to see how it goes.

by tekkk

0 subcomment

But what is stoolap's binary size? Specifically, WASM size? wa-sqlite is 1.2 MBs.

by ramon156

1 subcomments

Blog post written with an LLM, a project that went Go -> Rust -> Node? Also, is it really native? Does it not bind to your already built Rust tool?
I guess I'm a bit confused but don't want to read AI fuzz further

by ignoramous

0 subcomment

> No serialization overhead. Just your Node.js process talking directly ... through native bindings.
NAPI-RS has no serialisation overhead?

by petesergeant

1 subcomments

Stoolap looks pretty interesting, anyone want to share their experience of using it?