DEV Community

Kanishga Subramani profile picture

Kanishga Subramani

404 bio not found

Joined Joined on  github website
Manage ClickHouse® Without SSH with CH-Ops Pro
kanishga_subramani_49ad73 profile

Manage ClickHouse® Without SSH with CH-Ops Pro

#clickhouse #devops #database
1
Comments
7 min read

Want to connect with Kanishga Subramani?

Create an account to connect with Kanishga Subramani. You can also sign in below to proceed if you already have an account.

Create Account
Already have an account? Sign in
CH-Ops: A ClickHouse® Admin Tool Built for Simplicity
kanishga_subramani_49ad73 profile

CH-Ops: A ClickHouse® Admin Tool Built for Simplicity

#clickhouse #devops #analytics #database
Comments 2
8 min read
Native ClickHouse® Backups in CH-Ops: A Practical Guide
kanishga_subramani_49ad73 profile

Native ClickHouse® Backups in CH-Ops: A Practical Guide

#clickhouse #analytics #devops
1
Comments 2
6 min read
CH-Ops Access Control and App-Data Backup
kanishga_subramani_49ad73 profile

CH-Ops Access Control and App-Data Backup

#clickhouse #devops #analytics
1
Comments 2
6 min read
CH-Ops Scheduled Alerts: Know Before Things Break
kanishga_subramani_49ad73 profile

CH-Ops Scheduled Alerts: Know Before Things Break

#devops #clickhouse #database
Comments
4 min read
Search ClickHouse® Logs Without Writing SQL
kanishga_subramani_49ad73 profile

Search ClickHouse® Logs Without Writing SQL

#clickhouse #analytics #devops #database
1
Comments
5 min read
Watch your clusters live on CHOps
kanishga_subramani_49ad73 profile

Watch your clusters live on CHOps

#clickhouse #devops #analytics #database
1
Comments
3 min read
CH-Ops Schema Tools: Visualizer, Indexes & Projections
kanishga_subramani_49ad73 profile

CH-Ops Schema Tools: Visualizer, Indexes & Projections

#clickhouse #devops #database #analytics
1
Comments
7 min read
CHOps Is Now GA: Open-Source Operations for Self-Hosted ClickHouse®
kanishga_subramani_49ad73 profile

CHOps Is Now GA: Open-Source Operations for Self-Hosted ClickHouse®

#clickhouse #database #devops
1
Comments
1 min read
Design a ClickHouse® Table Without Hand-Writing DDL: Schema Studio
kanishga_subramani_49ad73 profile

Design a ClickHouse® Table Without Hand-Writing DDL: Schema Studio

#clickhouse #devops #analytics #database
2
Comments
4 min read
Secure API Key Management: Your AI, Your Choice
kanishga_subramani_49ad73 profile

Secure API Key Management: Your AI, Your Choice

#clickhouse #analytics #database #devops
1
Comments
5 min read
Ask your ClickHouse® database in plain English
kanishga_subramani_49ad73 profile

Ask your ClickHouse® database in plain English

#clickhouse #devops #analytics
1
Comments
6 min read
Debugging Query Performance with Per-Second Metrics
kanishga_subramani_49ad73 profile

Debugging Query Performance with Per-Second Metrics

#clickhouse #analytics #devops
1
Comments
10 min read
Where Did the Time Go? Query Profiler in CHOps
kanishga_subramani_49ad73 profile

Where Did the Time Go? Query Profiler in CHOps

#clickhouse #devops #chops #analytics
1
Comments
7 min read
CHOps SQL Editor: A Complete Guide to Faster ClickHouse® Query Development and Optimization
kanishga_subramani_49ad73 profile

CHOps SQL Editor: A Complete Guide to Faster ClickHouse® Query Development and Optimization

#chops #devops #analytics
Comments
7 min read
ClickHouse® 26.8 LTS Release: What's New and Why It Matters
kanishga_subramani_49ad73 profile

ClickHouse® 26.8 LTS Release: What's New and Why It Matters

#clickhouse #analytics #database #devops
1
Comments
14 min read
Install CH-Ops in 10 Minutes: Docker, Binary, or Source
kanishga_subramani_49ad73 profile

Install CH-Ops in 10 Minutes: Docker, Binary, or Source

#clickhouse #analytics #devops #database
3
Comments
8 min read
Day 100 of #100DaysOfClickHouse: Optimizing Data Lake Queries with ClickHouse® 26.3 LTS
kanishga_subramani_49ad73 profile

Day 100 of #100DaysOfClickHouse: Optimizing Data Lake Queries with ClickHouse® 26.3 LTS

#clickhouse #devops #database #analytics
Comments
6 min read
Day 99 - Efficient Random Sampling with system.numbers_mt: Parallel Number Generation in ClickHouse® 26.3
kanishga_subramani_49ad73 profile

Day 99 - Efficient Random Sampling with system.numbers_mt: Parallel Number Generation in ClickHouse® 26.3

#clickhouse #devops #analytics #database
Comments
4 min read
Day 98 of #100DaysOfClickHouse: ClickHouse® 26.3 JOIN Optimization – A Practical Guide to JOIN Types
kanishga_subramani_49ad73 profile

Day 98 of #100DaysOfClickHouse: ClickHouse® 26.3 JOIN Optimization – A Practical Guide to JOIN Types

#clickhouse #devops #analytics #database
Comments
6 min read
Day 97 of #100DaysOfClickHouse: Analyzing Memory Efficiency with Vertical Merges in ClickHouse® 26.3
kanishga_subramani_49ad73 profile

Day 97 of #100DaysOfClickHouse: Analyzing Memory Efficiency with Vertical Merges in ClickHouse® 26.3

#clickhouse #devops #database #analytics
Comments
5 min read
Day 96/100 – Standard SQL Time Functions in ClickHouse® 26.3: Better ANSI SQL Compatibility
kanishga_subramani_49ad73 profile

Day 96/100 – Standard SQL Time Functions in ClickHouse® 26.3: Better ANSI SQL Compatibility

#clickhouse #devops #database #analytics
Comments
4 min read
Day 95/100 – ClickHouse® 26.3 S3 Object Storage Read Enhancements: Faster Data Lake Queries
kanishga_subramani_49ad73 profile

Day 95/100 – ClickHouse® 26.3 S3 Object Storage Read Enhancements: Faster Data Lake Queries

#clickhouse #devops #analytics #database
Comments
5 min read
Day 94/100 – Automated Insert Batching in ClickHouse® 26.3: Higher Throughput with Asynchronous Inserts
kanishga_subramani_49ad73 profile

Day 94/100 – Automated Insert Batching in ClickHouse® 26.3: Higher Throughput with Asynchronous Inserts

#clickhouse #analytics #database #devops
Comments
6 min read
Day 93/100 – New Unicode String Functions in ClickHouse® 26.3: Better Text Search and Normalization
kanishga_subramani_49ad73 profile

Day 93/100 – New Unicode String Functions in ClickHouse® 26.3: Better Text Search and Normalization

#clickhouse #devops #analytics #database
Comments
5 min read
Day 92 of #100DaysOfClickHouse - Read-Only Tables in ClickHouse® 26.3
kanishga_subramani_49ad73 profile

Day 92 of #100DaysOfClickHouse - Read-Only Tables in ClickHouse® 26.3

#clickhouse #devops #analytics #database
2
Comments
4 min read
Day 91 of #100DaysOfClickHouse - Partition Pruning in ClickHouse®
kanishga_subramani_49ad73 profile

Day 91 of #100DaysOfClickHouse - Partition Pruning in ClickHouse®

#clickhouse #devops #analytics #database
Comments
4 min read
Day 90 - Data Loss Warning: Why You Cannot Downgrade from ClickHouse® 26.3
kanishga_subramani_49ad73 profile

Day 90 - Data Loss Warning: Why You Cannot Downgrade from ClickHouse® 26.3

#clickhouse #devops #analytics #database
2
Comments
5 min read
Day 89 - Leveraging WebAssembly (WASM) UDFs in ClickHouse® 26.3
kanishga_subramani_49ad73 profile

Day 89 - Leveraging WebAssembly (WASM) UDFs in ClickHouse® 26.3

#clickhouse #analytics #database #devops
2
Comments
5 min read
Day 88 - Upgrading to ClickHouse® 26.3 LTS: A Step-by-Step Safe Guide
kanishga_subramani_49ad73 profile

Day 88 - Upgrading to ClickHouse® 26.3 LTS: A Step-by-Step Safe Guide

#clickhouse #devops #analytics #database
Comments
5 min read
Day 87 - Standard-Compliant NOT Operator in ClickHouse® 26.3: Breaking Changes Explained
kanishga_subramani_49ad73 profile

Day 87 - Standard-Compliant NOT Operator in ClickHouse® 26.3: Breaking Changes Explained

#clickhouse #analytics #database #devops
Comments
5 min read
Day 86: Faster Map Key Lookups in ClickHouse® 26.3 with Bucketed Map Serialization
kanishga_subramani_49ad73 profile

Day 86: Faster Map Key Lookups in ClickHouse® 26.3 with Bucketed Map Serialization

#clickhouse #devops #analytics #database
Comments
6 min read
Day 85: Using naturalSortKey() in ClickHouse® to Sort Version Strings, Filenames, and Numeric Text Naturally
kanishga_subramani_49ad73 profile

Day 85: Using naturalSortKey() in ClickHouse® to Sort Version Strings, Filenames, and Numeric Text Naturally

#clickhouse #devops #analytics #database
Comments
5 min read
Day 84: EXPLAIN `pretty=1` and `compact=1` in ClickHouse® 26.3
kanishga_subramani_49ad73 profile

Day 84: EXPLAIN `pretty=1` and `compact=1` in ClickHouse® 26.3

#clickhouse #devops #analytics #database
Comments
6 min read
Day 83 of #100DaysOfClickHouse - JSONExtractString() Now Supports Native JSON in ClickHouse® 26.3
kanishga_subramani_49ad73 profile

Day 83 of #100DaysOfClickHouse - JSONExtractString() Now Supports Native JSON in ClickHouse® 26.3

#clickhouse #devops #database #analytics
1
Comments
4 min read
Day 82: Handling Schema Evolutions in ClickHouse® Distributed Clusters
kanishga_subramani_49ad73 profile

Day 82: Handling Schema Evolutions in ClickHouse® Distributed Clusters

#clickhouse #devops #database #analytics
1
Comments 2
6 min read
Day 81: Custom Compaction Strategies in ClickHouse®: Optimizing Background Merges for Better Performance
kanishga_subramani_49ad73 profile

Day 81: Custom Compaction Strategies in ClickHouse®: Optimizing Background Merges for Better Performance

#clickhouse #devops #analytics #database
Comments
6 min read
Day 80 of #100DaysOfClickHouse: ClickHouse® 26.3 LTS - New Features, Performance Improvements & Upgrade Guide
kanishga_subramani_49ad73 profile

Day 80 of #100DaysOfClickHouse: ClickHouse® 26.3 LTS - New Features, Performance Improvements & Upgrade Guide

#clickhouse #devops #database #analytics
Comments
5 min read
Day 79 – Materialized CTEs in ClickHouse® 26.3
kanishga_subramani_49ad73 profile

Day 79 – Materialized CTEs in ClickHouse® 26.3

#clickhouse #devops #database #dataengineering
Comments
4 min read
Day 78 of #100DaysOfClickHouse: Designing Multi-Tenant Architectures with ClickHouse®
kanishga_subramani_49ad73 profile

Day 78 of #100DaysOfClickHouse: Designing Multi-Tenant Architectures with ClickHouse®

#clickhouse #devops #database #dataengineering
2
Comments 2
5 min read
Day 77 of #100DaysOfClickHouse: Resolving Replication Conflicts in ClickHouse®
kanishga_subramani_49ad73 profile

Day 77 of #100DaysOfClickHouse: Resolving Replication Conflicts in ClickHouse®

#clickhouse #devops #database #dataengineering
1
Comments 2
6 min read
Day 76/100 - Working with ClickHouse® LowCardinality and Enum Types
kanishga_subramani_49ad73 profile

Day 76/100 - Working with ClickHouse® LowCardinality and Enum Types

#clickhouse #devops #database #dataengineering
Comments
5 min read
Day 75/100 - Bypassing the Page Cache for ClickHouse® I/O Operations
kanishga_subramani_49ad73 profile

Day 75/100 - Bypassing the Page Cache for ClickHouse® I/O Operations

#clickhouse #devops #database #dataengineering
Comments
6 min read
Day 74/100 - Cross-Datacenter Replication in ClickHouse®
kanishga_subramani_49ad73 profile

Day 74/100 - Cross-Datacenter Replication in ClickHouse®

#clickhouse #devops #database #dataengineering
Comments
6 min read
Day 73/100 - Using ClickHouse® for Vector Search and AI Workloads
kanishga_subramani_49ad73 profile

Day 73/100 - Using ClickHouse® for Vector Search and AI Workloads

#clickhouse #devops #database #dataengineering
Comments
5 min read
Day 72 - ClickHouse® Internals: How the Query Analyzer Works
kanishga_subramani_49ad73 profile

Day 72 - ClickHouse® Internals: How the Query Analyzer Works

#devops #clickhouse #analytics #database
Comments
4 min read
Day 71 - Advanced Partitioning Strategies for Petabyte-Scale Tables
kanishga_subramani_49ad73 profile

Day 71 - Advanced Partitioning Strategies for Petabyte-Scale Tables

#clickhouse #devops #database #analytics
Comments
4 min read
Day 70- Extending ClickHouse® with C++ UDFs
kanishga_subramani_49ad73 profile

Day 70- Extending ClickHouse® with C++ UDFs

#clickhouse #devops #database #analytics
Comments
6 min read
Day 69 - Anatomy of a ClickHouse® Vertical Merge
kanishga_subramani_49ad73 profile

Day 69 - Anatomy of a ClickHouse® Vertical Merge

#clickhouse #database #analytics #devops
Comments
7 min read
Day 68 of #100DaysOfClickHouse: Benchmarking ClickHouse® – Tools and Methodologies for Reliable Performance Testing
kanishga_subramani_49ad73 profile

Day 68 of #100DaysOfClickHouse: Benchmarking ClickHouse® – Tools and Methodologies for Reliable Performance Testing

#clickhouse #devops #database #analytics
1
Comments
5 min read
Day 67 of #100DaysOfClickHouse: Securing ClickHouse® with SSL/TLS and LDAP Authentication
kanishga_subramani_49ad73 profile

Day 67 of #100DaysOfClickHouse: Securing ClickHouse® with SSL/TLS and LDAP Authentication

#clickhouse #devops #database #dataengineering
Comments
5 min read
Day 66/100 - ClickHouse Keeper vs ZooKeeper: Migration and Benchmarks
kanishga_subramani_49ad73 profile

Day 66/100 - ClickHouse Keeper vs ZooKeeper: Migration and Benchmarks

#clickhouse #devops #database #dataengineering
Comments
6 min read
Day 65/100 - Implementing Exact-Once Semantics with ClickHouse® and Kafka
kanishga_subramani_49ad73 profile

Day 65/100 - Implementing Exact-Once Semantics with ClickHouse® and Kafka

#clickhouse #devops #database #dataengineering
Comments
6 min read
Day 64: ClickHouse® Query Cache – Configuration, Best Practices, and Common Pitfalls
kanishga_subramani_49ad73 profile

Day 64: ClickHouse® Query Cache – Configuration, Best Practices, and Common Pitfalls

#clickhouse #devops #analytics #database
Comments
5 min read
Day 63: Advanced ClickHouse® Dictionaries – Integrating External Data Sources for Faster Lookups
kanishga_subramani_49ad73 profile

Day 63: Advanced ClickHouse® Dictionaries – Integrating External Data Sources for Faster Lookups

#clickhouse #devops #database #analytics
1
Comments 1
5 min read
Day 62: Writing Custom ClickHouse® User-Defined Functions (UDFs) for Cleaner, Reusable SQL
kanishga_subramani_49ad73 profile

Day 62: Writing Custom ClickHouse® User-Defined Functions (UDFs) for Cleaner, Reusable SQL

#clickhouse #devops #database #dataengineering
5
Comments
6 min read
Day 61: Tuning ClickHouse® for Low-Latency Queries
kanishga_subramani_49ad73 profile

Day 61: Tuning ClickHouse® for Low-Latency Queries

#clickhouse #devops #database #analytics
Comments
4 min read
Day 60: ClickHouse® Query Profiling – Finding Performance Bottlenecks
kanishga_subramani_49ad73 profile

Day 60: ClickHouse® Query Profiling – Finding Performance Bottlenecks

#clickhouse #devops #analytics #database
Comments
4 min read
Day 59: High Availability (HA) and Disaster Recovery (DR) in ClickHouse®
kanishga_subramani_49ad73 profile

Day 59: High Availability (HA) and Disaster Recovery (DR) in ClickHouse®

#clickhouse #analytics #database #devops
Comments
6 min read
Day 58 - Optimizing ClickHouse® for High-Throughput Inserts
kanishga_subramani_49ad73 profile

Day 58 - Optimizing ClickHouse® for High-Throughput Inserts

#clickhouse #devops #analytics #database
Comments
5 min read
loading...