Building #OpenSource Real-Time Analytics on #ClickHouse #ChistaDATADBaaS #ClickHouseSupport #DataAnalytics #ColumnStore #BigData #ML #AI #Analytics #Data #Tech
San Francisco Bay Area
Joined June 2021
- Tweets454
- Following918
- Followers184
- Likes61
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
ChistaDATA Inc. retweeted
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.
ChistaDATA Inc. retweeted
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
chistadata.com/tune-clickhou… How to Tune #ClickHouse for Performance immediately after Installation #DBATips #SQLTips #BigDATA #Analytics
zurl.co/iwgT
How do you implement row-level security in MariaDB? #MariaDB #DBATips #OpenSource #DBA #DataSecurity
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
zurl.co/fKPL
Implementing an Oracle RMAN-Like Backup and Recovery Toolkit for ClickHouse
#ClickHouse #OLAP #SQL #SQLTips #DBA #Analytics #ColumnStore #RealTimeAnalytics #Oracle #RMAN
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
Reduce disk I/O bottlenecks by using compression and partitioning in your data pipelines. This speeds up data ingestion and processing! #DataEngineering #BigData #IOPerformance
ChistaDATA Inc. retweeted
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…
zurl.co/fOof Achieving Real-time Analytics with ChistaDATA's ClickHouse
#ClickHouse #OLAP #SQL #SQLTips #DBA #Analytics #ColumnStore #RealTimeAnalytics
zurl.co/Ilpx Addressing #Kafka Partition Imbalance @chistadata @ChistaData
#DataScience #DataScientist #OLAP #AI #ML #BigDATA #Analyics #RealTimeAnalytics #ClickHouse
zurl.co/RDn9 Understanding ClickHouse MergeTree
#ClickHouse #OLAP #SQL #SQLTips #DBA #Analytics #ColumnStore #RealTimeAnalytics
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
🇨🇭 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
zurl.co/B4Av
Enhancing ClickHouse Performance: Strategic Insights on Partitioning
#ClickHouse #OLAP #SQL #SQLTips #DBA #Analytics #ColumnStore #RealTimeAnalytics
zurl.co/H9bz Why Delta Updates Are Not Recommended in OLAP Databases
#ClickHouse #OLAP #SQL #SQLTips #DBA #Analytics #ColumnStore #RealTimeAnalytics
zurl.co/4mwl
Mastering Performance Tuning in ClickHouse: Tips for Inspecting Statistics Objects
#ClickHouse #OLAP #SQL #SQLTips #DBA #Analytics #ColumnStore #RealTimeAnalytics
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
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