Viewing profile — usman-m

We built Claudespace to avoid conflicts when running Claude Code alongside our dev flow. It uses git worktrees, remapped ports, and env isolation to spin up multiple local instance…

Curious how you guys use contexts?

Almost. Currently continuous views that contain an ORDER BY or LIMIT clause are not supported.

They work better for non-sliding window queries. Triggers on sliding window queries are much more resource intensive, both for CPU and memory. Essentially, the trigger process has …

Great stuff! For now it seems like this leaves out the job of finding crowd workers. Could it be possible to do something like designing microtasks in MTurk and "stitching" the wor…

Our native implementations of all probabilistic data structures use MurmurHash3, so this isn't a problem. The dumbloom implementation is in no way a good Bloom filter, as the name …

It probably uses a HyperLogLog--the 2% error rate kind of gives it away. Bloom filters approximate set membership queries, HyperLogLogs approximate set cardinality queries. COUNT D…

Oops, it was meant to be: SELECT FROM (SELECT DISTINCT user_id FROM user_actions); You're absolutely right that both those queries will give the same result. I guess I was trying t…

ahachete, I'm not sure if I totally understand your question. Continuous views are consumers for streams. You can think of them as high throughput real-time materialized views. The…

Mostly that. I've also been thinking about how we could incorporate some machine learning algorithms, like online perceptrons.

Not right now, but it's definitely a feature we're thinking about. Awesome--let us know what you think about it!

It's not so much as how different it is from an architectural standpoint as it is about the sheer magnitude of such a feature. All open-source communities have processes which help…