pradeepchhetri

13 ms·

31.
by pradeepchhetri 3y ago
I enjoy using clickhouse-local for parsing csv files. I generally hit situations where I need custom delimiter and custom parsing rules, I find it handles all of these edge cases very well. Recently I found that if my csv files are compres
32.
by pradeepchhetri 3y ago
I have read your blogs and The Little Go Book. I must say that they are great. Thank you for writing those and keep writing.
33.
by pradeepchhetri 3y ago
Wow I didn't know that snowflake charges on query level. Very good business idea to first create dependency and rip them off once their business grows.
34.
Saving Millions of Dollars by Bin-Packing ClickHouse Pods in AWS EKS(clickhouse.com)
16 points by pradeepchhetri 3y ago|2 comments
35.
by pradeepchhetri 3y ago
Sometime back, I tried using clickhouse-keeper as zookeeper alternative with few other systems like kafka, mesos, solr, Wrote some notes here: https://pradeepchhetri.xyz/clickhousekeeper/
36.
by pradeepchhetri 3y ago
If you are interested in performance aspect of databases, I would recommend watching this great talk [0] from Alexey, ClickHouse Developer, where he talks about various aspects like designing systems by first realising the hardware capabili
37.
by pradeepchhetri 3y ago
I would consider following things before selecting a database offering: - Whether the database vendor is a lock-in. It would be a straight "NO" for me if the database isn't open-source with proper license, since I can't
38.
by pradeepchhetri 3y ago
As an SRE, I used to install one tool for every data format until I came across clickhouse-local. Now I use it for everything. - It works with every data format which I come across in my daily job. It support data formats like Protobuf, Avr
39.
by pradeepchhetri 4y ago
> There are Vitess cutters with petabytes of data. Is it GitHub? Where can I find more details about them? It will be interesting to read more about it.
40.
by pradeepchhetri 4y ago
Well if you need to convert json to parquet to do anything fast, then what is the meaning ? You will end up wasting way more resource in that conversion itself that your benefit is all equalized in the cost of extra storage utilization (sin
41.
by pradeepchhetri 4y ago
You might want to consider checking out ClickHouse which supports many ML functions natively: - stochasticLinearRegression ( https://clickhouse.com/docs/en/sql-reference/aggregate-funct... ) - stochasticLogisti
42.
ClickHouse: A Fast DBMS with Full SQL Join Support(clickhouse.com)
15 points by pradeepchhetri 4y ago|0 comments
43.
Inverted Indices in ClickHouse(clickhouse.com)
28 points by pradeepchhetri 4y ago|2 comments
44.
Query SQLite and PostgreSQL Data Using DuckDB(pradeepchhetri.xyz)
3 points by pradeepchhetri 4y ago|0 comments
45.
Ask HN: Does https://github.com/klauspost/compress returns 502 for you?
3 points by pradeepchhetri 4y ago|3 comments
46.
by pradeepchhetri 4y ago
Good idea, makes sense. Thank you!
47.
by pradeepchhetri 4y ago
The vertamedia clickhouse plugin works perfectly for me. Have you tried opening an issue upstream.
48.
by pradeepchhetri 4y ago
Grafana Labs recently wrote a new clickhouse adapter. https://github.com/grafana/clickhouse-datasource https://grafana.com/blog/2022/05/05/introducing-the-official...
49.
by pradeepchhetri 4y ago
Thank you for your response and going through the blog. I am curious about how to implement 2. ClickHouse as a monitoring agent with the system.asynchronous_log table. Can you share some links around it.
50.
Lesser known features of ClickHouse(pradeepchhetri.xyz)
158 points by pradeepchhetri 4y ago|33 comments
51.
by pradeepchhetri 4y ago
Thank you!
52.
by pradeepchhetri 4y ago
I see you mentioned M3DB throughout the README. Have you looked at VictoriaMetrics ?
53.
Pricing Comparison for Managed Prometheus(victoriametrics.com)
2 points by pradeepchhetri 5y ago|0 comments
54.
Building a Paste Service with ClickHouse(clickhouse.com)
3 points by pradeepchhetri 5y ago|0 comments
55.
by pradeepchhetri 5y ago
Thank you for answering my questions.
56.
by pradeepchhetri 5y ago
Great. Thank you for the response. Curious if you recommend any particular filesystem for running SeaweedFS.
57.
by pradeepchhetri 5y ago
Thank you for SeaweedFS. Curious if you have benchmarked SeaweedFS against LeoFS ( https://github.com/leo-project ) It seems like both have similar motivation.
58.
New Databases to keep an eye on in 2022(pradeepchhetri.xyz)
11 points by pradeepchhetri 5y ago|0 comments
59.
by pradeepchhetri 5y ago
Well, atleast the CPU will be free for doing other things by offloading some work to GPU.
60.
by pradeepchhetri 5y ago
I replaced iTerm with Wezterm 6 months back. It feels lot more lighter and faster. As SRE I need to work a lot on terminal. I tried Alacritty for a while but Alacritty not supporting horizontal and vertical splits was a major setback for me

More ›