zX41ZdbW

19 ms·

1. 241.▲
   by zX41ZdbW 2y ago

   The article should acknowledge that averaging is better to be performed in a perceptually uniform color space. Examples: - https://github.com/ClickHouse/ClickHouse/pull/60391/files - https://g
2. 242.▲
   by zX41ZdbW 2y ago

   > pedestrians like me generally don’t have access to Intel’s’ AMX-enabled hardware. The cost-of-entry for Intel’s Sapphire Rapids chips is pretty steep too. Maybe some day it will be ubiquitous in consumer-hardware and share a similar st
3. 243.▲
   by zX41ZdbW 2y ago

   There is chdb: https://clickhouse.com/docs/en/chdb - a library with embedded ClickHouse - the usage is similar to duckdb, but with all ClickHouse features and performance.
4. 244.▲
   by zX41ZdbW 2y ago

   This is really great! I can suggest more ideas that will be easy to add: - a spark line or heat map of upvotes for every thread: https://github.com/ClickHouse/ClickHouse/issues/59020 - a built-in SQL editor f
5. 245.▲
   by zX41ZdbW 2y ago

   This? https://podcasts.apple.com/us/podcast/lennys-podcast-product...
6. 246.▲
   by zX41ZdbW 2y ago

   Maybe this? https://podcasts.apple.com/us/podcast/lennys-podcast-product...
7. 247.▲
   by zX41ZdbW 2y ago

   Probably here: https://podcasts.apple.com/us/podcast/lennys-podcast-product...
8. 248.▲
   by zX41ZdbW 2y ago

   Maybe https://reversedns.space/ will be interesting - I created this visualization for fun, and the scripts/details/source code is available.
9. 249.▲
   by zX41ZdbW 2y ago

   In ClickHouse you can do INSERT INTO table FORMAT JSONEachRow {"key": 123} It works with all other formats as well. Plus, it is designed in a way so you can make an INSERT query and stream the data, e.g.: clickhouse
10. 250.▲
    by zX41ZdbW 2y ago

    Yes, the backend is https://github.com/ClickHouse/ClickHouse/ It has no front-end (everything is served by the database itself). The HTML page: https://github.com/ClickHouse/ClickHouse/bl
11. 251.▲
    by zX41ZdbW 2y ago

    It will be good to add "Programming Language Checklist" to the references: https://www.mcmillen.dev/language_checklist.html
12. 252.▲
    by zX41ZdbW 2y ago

    Here is the list of recent flagged/dead stories, ordered by rating, that they managed to accumulate: https://play.clickhouse.com/play?user=play#U0VMRUNUIGlkLCB0a... Here is the list of recent flagged/dead stories:
13. 253.▲
    by zX41ZdbW 2y ago

    ClickHouse is more widely used than Pinot or Druid based on any possible metric. If you try to install any of the latter, it will be apparent why. (They are poor in usability).
14. 254.▲
    by zX41ZdbW 2y ago

    I also found that BMP with ZSTD outperforms PNG while developing https://adsb.exposed/ (it streams raw RGBA over HTTP with Content-Encoding: zstd)
15. 255.▲
    by zX41ZdbW 2y ago

    A few corrections to the article. 1. ClickHouse is not a new technology — it has been open-source since 2016 and in development since 2009. 2. ClickHouse can do all three use cases: historical and real-time data, distributed and local proce
16. 256.▲
    by zX41ZdbW 2y ago

    Thank you for the link! I've recently created a small service on this topic: https://reversedns.space/ It visualizes the IPv4 space based on reverse DNS responses.
17. 257.▲
    by zX41ZdbW 2y ago

    Minio is fairly easy to setup locally or in CI. We use it for CI in ClickHouse, for example: https://github.com/ClickHouse/ClickHouse/blob/master/docker/...
18. 258.▲
    by zX41ZdbW 2y ago

    The first example is not convincing: lsp\ "prin" It has two problems: - it's unclear why "prin", not "print"; - the usage of backslash looks scary. Subsequent examples are also not good: bea
19. 259.▲
    by zX41ZdbW 2y ago

    A correction to the article. It mentions Warehouse BigQuery, Snowflake, Clickhouse ≥1s Minutes For ClickHouse, it should be: read latency <= 100ms, write latency <= 1s. Logging, real-time analytics, and RAG are also suitable
20. 260.▲
    by zX41ZdbW 2y ago

    ZooKeeper or ClickHouse Keeper, Etcd, Consul.
21. 261.▲
    by zX41ZdbW 2y ago

    But the scan quality is subpar. Example: > For belter safekecping Russta’s $2¢4,000,000 collection of crown jewels, probably (he finesl array of gems ever assem- bled at one tle https://play.clickhouse.com/play?user=play#
22. 262.▲
    by zX41ZdbW 2y ago

    Also uploaded it to the public playground for queries: https://play.clickhouse.com/play?user=play#U0VMRUNUIHllYXIsI...
23. 263.▲
    by zX41ZdbW 2y ago

    First look at the data: https://pastila.nl/?05ee30a0/be7f1715c7de106b95cccd9385a6c2e... TLDR: it makes sense :)
24. 264.▲
    by zX41ZdbW 2y ago

    oO08 iIlL1| g9qCGQ ~-+=> I use it here: https://alexey-milovidov.github.io/font-selector/ (in the "Textarea" examples).
25. 265.▲
    by zX41ZdbW 2y ago

    Potentially affected. No problem for now, per the linked blog post.
26. 266.▲
    by zX41ZdbW 2y ago

    The list of affected websites, just in case: https://pastila.nl/?000882d6/bed25fdc842914abbc89e528012a961...
27. 267.▲
    by zX41ZdbW 2y ago

    The number of websites is decreasing, which is good: clickhouse-cloud :) SELECT date, count() FROM minicrawl_processed WHERE arrayExists(x -> x LIKE '%polyfill.io%', external_scripts_domains) AND date >= now() - INTERV
28. 268.▲
    by zX41ZdbW 2y ago

    I checked, and here are the top domains that are still using Polyfill.io as of today: https://pastila.nl/?00008b47/8a0d821be418cdd5003a2d620d76589... However, theguardian.com is using it from its own domain, which is s
29. 269.▲
    by zX41ZdbW 2y ago

    I have an example of a database hosted on GitHub: https://github.com/ClickHouse/web-tables-demo Which you can query anywhere using a ClickHouse local database engine. When you do a query, it downloads only the required
30. 270.▲
    by zX41ZdbW 2y ago

    I tried https://shell.duckdb.org/ , but it was a very rough experience. The "delete" button does not work. The "home" button inserts a whitespace. Pasting with "Ctrl+v" also does not work. Every