zX41ZdbW

24 ms·

361.
by zX41ZdbW 3y ago
Thank you! You saved me :) Although it is non-obvious, which AST fragments are considered valid and which are not.
362.
by zX41ZdbW 3y ago
It's strange, but I cannot make it work. I did this: cargo install ast-grep Then I'm searching in my code with: $ sg --pattern 'catch (...) { $$$ARGS }' --lang c++ ./Server/TCPHandler.cpp
363.
by zX41ZdbW 3y ago
You can export the whole dataset as described here: https://github.com/ClickHouse/ClickHouse/issues/29693 Or query one of the preloaded datasets: https://play.clickhouse.com/play?user=play#U0V
364.
by zX41ZdbW 3y ago
It isn't fast. For example, when I opened https://ayllu-forge.org/projects/ayllu/log , it took around three seconds.
365.
by zX41ZdbW 3y ago
I'm also interested in this topic (since I was 17 and didn't lose interest in twenty years). Recently, I've created a hobby project - the atlas of the Internet: https://reversedns.space/ I'm posting here
366.
by zX41ZdbW 3y ago
I did a similar tool a few years ago: https://github.com/ClickHouse/ClickHouse/tree/master/program... Its idea is to avoid custom models for various data (email, first name, address), but to create model
367.
by zX41ZdbW 3y ago
The article does not use LSH as it is typically used. Typically, LSH is for low dimensions - you split the space to cells by the hash value, use the hash value as an index, and look up one to a few values for every key (so you have some ove
368.
by zX41ZdbW 3y ago
The list of the most popular Fortran repositories on GitHub: https://play.clickhouse.com/play?user=play#U0VMRUNUICdodHRwc... WRF is one of the most notable...
369.
by zX41ZdbW 3y ago
> What if there was a way to take some SQL's logical plan and turn it into a physical plan that uses compute resources from a pool This is how ClickHouse works on a cluster. For example, writing the same query as SELECT sum(si
370.
by zX41ZdbW 3y ago
The same query takes only 1.4 seconds on my server, so I assume that the query does not read all 8 GB.
371.
by zX41ZdbW 3y ago
It is already the public instance: https://play.clickhouse.com/play?user=play
372.
by zX41ZdbW 3y ago
Another interesting thing - find friends on GitHub using the intersection between stars you've gave: https://ghe.clickhouse.tech/#finding-friends-through-countin...
373.
by zX41ZdbW 3y ago
This: https://play.clickhouse.com/play?user=play#U0VMRUNUIGJpbihzZ...
374.
by zX41ZdbW 3y ago
Recently, I was interested in analyzing network traffic and network infrastructure. I will be happy to find any datasets related to: - network connectivity, latency, and routing; - uptime and speed monitoring; - background traffic and Inter
375.
by zX41ZdbW 3y ago
You can run ClickHouse cluster across multiple datacenters. It will survive the failure of a single datacenter while being available for writes and reads, and the failure of two out of three datacenters while being available for reads. It w
376.
by zX41ZdbW 3y ago
It is a different scenario. A large number of point queries, not like analytics on top of a large amount of data. Not a good fit for ClickHouse.
377.
by zX41ZdbW 3y ago
I've implemented the same approach (non-parametric), and it worked well to speed up the search on my experiment with 384-dimensional embeddings of 30 million Hacker News comments. I presented it in my talk, where you can see the speed
378.
by zX41ZdbW 3y ago
In my opinion, `GETPUBLICSUFFIXDOMAINONLY` looks uglier than the corresponding function `cutToFirstSignificantSubdomain` in ClickHouse: https://clickhouse.com/docs/en/sql-reference/functions/url-f...
379.
by zX41ZdbW 3y ago
Good article, and thanks Maksim for the contribution!
380.
by zX41ZdbW 3y ago
It has click artifacts in my browser (Firefox). PS. I've recently implemented an FM / additive / modular synthesizer entirely in SQL: https://github.com/ClickHouse/NoiSQL
381.
by zX41ZdbW 3y ago
Schema inference for nested JSON objects is a feature of ClickHouse 23.9. I've made a video about it: https://www.youtube.com/watch?v=yS8YU-rBpMM&t=1846s
382.
Fuzzing: Practical Approaches in ClickHouse(presentations.clickhouse.com)
5 points by zX41ZdbW 3y ago|1 comments
383.
by zX41ZdbW 3y ago
We've recently made a similar thing for databases: https://github.com/ClickHouse/web-tables-demo It downloads the database on demand and optionally caches on the client side: https://presentations.click
384.
by zX41ZdbW 3y ago
Interesting, looks like it is just DataFusion engine for Spark. There is a similar project: https://github.com/oap-project/gluten - it brings ClickHouse as an engine to Spark.
385.
by zX41ZdbW 3y ago
I like writing useless software because its use, if any, will exceed initial expectations. Examples: https://reversedns.space/ https://github.com/ClickHouse/NoiSQL https://pastila.nl/
386.
by zX41ZdbW 3y ago
Good article on this topic: https://quantum5.ca/2023/10/10/what-i-wish-i-knew-when-i-got... Recently, I've created an interactive map of all IPv4 addresses, PTAL: https://reversedns.space&#x2F
387.
by zX41ZdbW 3y ago
We are using a fuzzing method in ClickHouse that involves sending signals to random threads: https://github.com/ClickHouse/ClickHouse/blob/master/src/Com... We immediately found bugs in many depende
388.
Show HN: Interactive Internet Map(reversedns.space)
5 points by zX41ZdbW 3y ago|0 comments
389.
by zX41ZdbW 3y ago
Unquoted alias without the AS keyword cannot be named FROM.
390.
by zX41ZdbW 3y ago
ClickHouse has no reserved keywords, e.g. SELECT SELECT FROM FROM is a valid query.

More ›