ChistaDATA Inc.

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

[ChistaDATA Inc. @chistadata]

@nick_white @deedydas Using a recursive SQL CTE for BFS in a graph traversal? That’s next-level SQL wizardry! 🚀 Not your everyday use case, but a testament to the versatility of SQL. Props to them for thinking outside the box! 👏 #SQL #GraphTraversal #DataEngineering

[Michael @mgrczyk]

@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

[Deedy @deedydas]

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.

[MinervaDB @WebScaleDBA]

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
https://t.co/MbGYSBEfcN

[ChistaDATA Inc. @chistadata]

https://t.co/DMc7DNlydP How to Tune #ClickHouse for Performance immediately after Installation #DBATips #SQLTips #BigDATA #Analytics

[ChistaDATA Inc. @chistadata]

https://t.co/nEjSeeInBY
How do you implement row-level security in MariaDB? #MariaDB #DBATips #OpenSource #DBA #DataSecurity

[ChistaDATA Inc. @chistadata]

https://t.co/MUG8pf8ZjN How Long-Running Queries Negatively Influence PostgreSQL Execution Plans and Database Performance?
hashtag#PostgreSQL hashtag#DBA hashtag#SQL hashtag#OpenSource hashtag#PostgreSQLTips

[ChistaDATA Inc. @chistadata]

https://t.co/jVo2XJonDa
Implementing an Oracle RMAN-Like Backup and Recovery Toolkit for ClickHouse
#ClickHouse #OLAP #SQL #SQLTips #DBA #Analytics #ColumnStore #RealTimeAnalytics #Oracle #RMAN

[ChistaDATA Inc. @chistadata]

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

[ChistaDATA Inc. @chistadata]

Reduce disk I/O bottlenecks by using compression and partitioning in your data pipelines. This speeds up data ingestion and processing! #DataEngineering #BigData #IOPerformance

[Data Enthusiast @CodeDrivenData]

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 https://t.co/6bdaHXS5Ir

[ChistaDATA Inc. @chistadata]

https://t.co/Q2m1KN4Wg4 Achieving Real-time Analytics with ChistaDATA's ClickHouse
#ClickHouse #OLAP #SQL #SQLTips #DBA #Analytics #ColumnStore #RealTimeAnalytics

[ChistaDATA Inc. @chistadata]

https://t.co/z0QyDvNytu Addressing #Kafka Partition Imbalance @chistadata @ChistaData
#DataScience #DataScientist #OLAP #AI #ML #BigDATA #Analyics #RealTimeAnalytics #ClickHouse

[ChistaDATA Inc. @chistadata]

https://t.co/nkj2dkpDON Understanding ClickHouse MergeTree
#ClickHouse #OLAP #SQL #SQLTips #DBA #Analytics #ColumnStore #RealTimeAnalytics

[ChistaDATA Inc. @chistadata]

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]

@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 https://t.co/szBR6yrMkc

[ChistaDATA Inc. @chistadata]

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]

🇨🇭 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

[ChistaDATA Inc. @chistadata]

https://t.co/0ogCxzAf4p
Enhancing ClickHouse Performance: Strategic Insights on Partitioning
#ClickHouse #OLAP #SQL #SQLTips #DBA #Analytics #ColumnStore #RealTimeAnalytics

[ChistaDATA Inc. @chistadata]

https://t.co/EAktk1lOl5 Why Delta Updates Are Not Recommended in OLAP Databases
#ClickHouse #OLAP #SQL #SQLTips #DBA #Analytics #ColumnStore #RealTimeAnalytics

[ChistaDATA Inc. @chistadata]

https://t.co/dXvseAoOfV
Mastering Performance Tuning in ClickHouse: Tips for Inspecting Statistics Objects
#ClickHouse #OLAP #SQL #SQLTips #DBA #Analytics #ColumnStore #RealTimeAnalytics

[ChistaDATA Inc. @chistadata]

https://t.co/OuuqPLBh6o 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