Viewing profile — matthewnourse

All the best with the stabilizing, please add me to your beta users list whenever you're ready :).

Sounds cool, can you share a link/download ?

So James & Paul, are your needs covered by Custora or one of the other services? Or is there something more that one or both of you need?

Thanks for taking the time to look over the tests in such detail! MySQL's EXPLAIN output says that it's using the indexes. PostgreSQL's EXPLAIN output says that it's _not_ (and fro…

They work as expected for English. They "work" for languages with characters outside the English set, but they order based on ASCII byte values rather than the order expected by na…

It streams the dataset into memory 256K (more for longer rows) at a time. It doesn't load the whole dataset into RAM unless it must eg for a join, sort or grouping. I don't current…

Cool, thanks! Will alter and re-run in a few minutes. r17 supports only UTF8 strings but compares with strcmp/strcasecmp/memcmp depending on the situation. Would you like a differe…

r17 doesn't run on Windows, and I don't have any plans to make it work on Windows at this time. Apart from that niggle, I agree...more bakeoffs needed. There's not much statistical…

I hear you, and I would have preferred to use the SQL (or any other well-understood) syntax. Some of the reasons are: 1) I want the query writer to be in complete control over what…

Sure, here it is: name | current_setting -----------------------+------------------------------------------------------------------------------------------------------------- versi…

[re fail] my main goal is to find out if r17 is "generally useful" for other people doing data mining, _not_ to pull the wool over any eyes. What would you like to see done differe…

I agree that it would be disingenuous to base "faster" on load+index+query. I'm basing it on the query times alone. I would like very much to base it on load+index+query 'cause the…

Yes, right now they are one and the same.

R17 is a data mining language that's a cross between SQL and Bash. For example this SELECT username, COUNT(1) AS num FROM users GROUP BY username ORDER BY num; is roughly equivalen…

Syntactically it's a cross between UNIX shell script and SQL and it's got some nice performance/scalability characteristics. Am very keen to hear the collective HN wisdom about it.…

Sounds great! Even better if you can squeeze in another run. For me, consistency is the key...whatever I can keep doing consistently is the most helpful. For legs the best things I…

I'd love to see where the crossover point is on different architectures...especially when the size of the collection is just over the CPU's L1 cache size. I wonder if the vector's …