@chistadata profile picture
ChistaDATA Inc. @chistadata

Building #OpenSource Real-Time Analytics on #ClickHouse #ChistaDATADBaaS #ClickHouseSupport #DataAnalytics #ColumnStore #BigData #ML #AI #Analytics #Data #Tech

Joined June 2021
  • Tweets 454
  • Following 919
  • Followers 186
256 Photos and videos
ChistaDATA Inc. retweeted
Michael
@mgrczyk
15 Nov 2024
Replying to @deedydas
I had a candidate do a very simple linked list question (find and remove a node) entirely via C template metaprogramming. We made an offer but he turned us down saying the work would be too boring
6
8
414
90,846
ChistaDATA Inc. retweeted
Deedy
@deedydas
15 Nov 2024
For non programmers, SQL (structured query language) is usually used to get data in and out of tables. Few people know it can be used as a full feature programming language and have the skill to do it. It's like asking someone to take a picture and they draw a photorealistic one in pencil.
42
65
5,167
391,353
ChistaDATA Inc. retweeted
MinervaDB@WebScaleDBA
15 Nov 2024
Using strace to troubleshoot #MySQL performance issues can be highly effective, especially for diagnosing low-level system calls and pinpointing issues like excessive I/O, network delays, and file access bottlenecks. strace captures and logs system calls made by a process, which helps you understand MySQL's interactions with the operating system. #MySQLPerformance @MinervaDB #dba zurl.co/6jaj
2
1
57
chistadata.com/tune-clickhou… How to Tune #ClickHouse for Performance immediately after Installation #DBATips #SQLTips #BigDATA #Analytics

Tuning ClickHouse for Performance after Installation | ChistaDATA

Explore our detailed runbook to tune ClickHouse and the Linux server for optimal query performance right after installation.

chistadata.com
1
50
zurl.co/iwgT How do you implement row-level security in MariaDB? #MariaDB #DBATips #OpenSource #DBA #DataSecurity
26
lnkd.in/gMDWfG5R How Long-Running Queries Negatively Influence PostgreSQL Execution Plans and Database Performance? hashtag#PostgreSQL hashtag#DBA hashtag#SQL hashtag#OpenSource hashtag#PostgreSQLTips

LinkedIn

This link will take you to a page that’s not on LinkedIn

lnkd.in
20
zurl.co/fKPL Implementing an Oracle RMAN-Like Backup and Recovery Toolkit for ClickHouse #ClickHouse #OLAP #SQL #SQLTips #DBA #Analytics #ColumnStore #RealTimeAnalytics #Oracle #RMAN
38
Use tools like Apache Avro or Protobuf to handle schema changes seamlessly in your data pipeline, ensuring backward compatibility. #SchemaManagement #DataPipelines #BigData #AI #ML #DataScience

ALT coding internet security GIF by Matthew Butler
29
Reduce disk I/O bottlenecks by using compression and partitioning in your data pipelines. This speeds up data ingestion and processing! #DataEngineering #BigData #IOPerformance

ALT Axolittles Bike GIF
23
ChistaDATA Inc. retweeted
Data Enthusiast@CodeDrivenData
2 Oct 2024
Projections in ClickHouse are a powerful feature designed to optimize query performance by precomputing and storing the results of specific queries or aggregations. #ChistaDATA @chistadata chistadata.com/performance-t…

ClickHouse Projections for Query Optimization | ChistaDATA Blog

In this post, we explore how projections with one or multiple columns can be used to enhance query performance in ClickHouse.

chistadata.com
2
2
42
zurl.co/fOof Achieving Real-time Analytics with ChistaDATA's ClickHouse #ClickHouse #OLAP #SQL #SQLTips #DBA #Analytics #ColumnStore #RealTimeAnalytics
18
zurl.co/Ilpx Addressing #Kafka Partition Imbalance @chistadata @ChistaData #DataScience #DataScientist #OLAP #AI #ML #BigDATA #Analyics #RealTimeAnalytics #ClickHouse
63
zurl.co/RDn9 Understanding ClickHouse MergeTree #ClickHouse #OLAP #SQL #SQLTips #DBA #Analytics #ColumnStore #RealTimeAnalytics
22
Great episode! 🎙️ Excited to hear how AI is transforming customer experiences at the contact center level. Looking forward to the future of #TheNewCX with @Five9 and how #AI will continue driving innovation. 🔥 #CXNation #AIForCX Tuning in now! 🎧
Trina DeHerrera@TrinaD925
17 Sep 2024
Replying to @Five9
@Five9 CTO and Head of AI, @jdrosen2, joined @MaribelLopez on "The AI with Maribel Lopez" podcast. They shared insights on the future of #TheNewCX, the impact #AI is having on the contact center experience today, and what's possible. Tune in: #CXNation livesocial.seismic.com/t6zUC…
5
Exciting move towards transparency and collaboration! 👏 Open-source public service code fosters innovation, accountability, and community-driven improvements. Hope more countries follow Switzerland's and Bulgaria's example! 🌍 #OpenSource #DigitalSovereignty #TechForGood
Tom Smykowski@tomaszs2
17 Sep 2024
🇨🇭 Switzerland Goes Open Source: Switzerland mandates public service code to be open-sourced, following Bulgaria’s lead. The EMBAG law promotes transparency, allowing free use and distribution, with some security exceptions. #OpenSource #Switzerland #PublicServices
1
22
zurl.co/B4Av Enhancing ClickHouse Performance: Strategic Insights on Partitioning #ClickHouse #OLAP #SQL #SQLTips #DBA #Analytics #ColumnStore #RealTimeAnalytics
19
zurl.co/H9bz Why Delta Updates Are Not Recommended in OLAP Databases #ClickHouse #OLAP #SQL #SQLTips #DBA #Analytics #ColumnStore #RealTimeAnalytics
14
zurl.co/4mwl Mastering Performance Tuning in ClickHouse: Tips for Inspecting Statistics Objects #ClickHouse #OLAP #SQL #SQLTips #DBA #Analytics #ColumnStore #RealTimeAnalytics
1
33
zurl.co/hSxg Implementing a High-Performance 3-Node ClickHouse Cluster with ClickHouse Keeper for Read-Write Splitting and TTL-Based Archiving #ClickHouse #OLAP #SQL #SQLTips #DBA #Analytics #ColumnStore #RealTimeAnalytics
21
Vectorized query engines drastically accelerate #AI and #ML workloads by processing data in SIMD (Single Instruction, Multiple Data) fashion. This parallelism enables high-throughput, low-latency computations, crucial for large-scale #DataScience tasks and real-time analytics. 🚀 #BigData #DeepLearning #HPC #MachineLearning #AIResearch

ALT Coding Artificial Intelligence GIF by Butlerm

1
26
more replies
With distributed processing, ClickHouse scales horizontally to handle petabytes of data while maintaining low-latency responses. Scale your real-time analytics effortlessly! 🏗️ #ClickHouse #Scalability #DistributedSystems #RealTimeData
1
14
ClickHouse’s built-in compression algorithms, like LZ4, reduce storage footprint without sacrificing query speed. Handle large datasets efficiently and cost-effectively. 💾 #ClickHouse #Compression #BigData #DataEfficiency
23
Load more