1. X
  2. ClickHouse
Log inSign up
ClickHouse
4,758 posts
user avatar
ClickHouse
@ClickHouseDB
ClickHouse is the fastest open-source OLAP database โšก Download: clickhouse.com GitHub: clickhou.se/GitHub Slack: clickhouse.com/slack
Bay Area / Amsterdam
clickhouse.com
Joined January 2017
62
Following
18.5K
Followers
AffiliatesAffiliatesRepliesRepliesMediaMedia

New to X?

Sign up now to get your own personalized timeline!

Create account

By signing up, you agree to the Terms of Service and Privacy Policy, including Cookie Use.

TermsยทPrivacyยทCookiesยทAccessibilityยทAds Infoยทยฉ 2026 X Corp.
Don't miss what's happening
People on X are the first to know.
Log inSign up
  • user avatar
    ClickHouse
    @ClickHouseDB
    8h
    Scale-down latency: 30 hours โ†’ 3 hours. We wrote about the two-window approach behind ClickHouse Cloud auto-scaling back in March.
    Smarter Auto-Scaling for ClickHouse: The Two-Window Approach
    Smarter Auto-Scaling for ClickHouse: The Two-Window Approach | ClickHouse
    From clickhouse.com
    1K01K
  • user avatar
    ClickHouse
    @ClickHouseDB
    16h
    ๐Ÿš€ Getting started with ClickHouse? Join our free ClickHouse Fundamentals virtual workshop on July 28 and discover why engineering teams are choosing ClickHouse for real-time analytics and AI applications. Perfect for engineers evaluating ClickHouse or building their first
    1.2K01.2K
  • user avatar
    ClickHouse
    @ClickHouseDB
    Jul 19
    . @picnic promises groceries in a 20-minute window, which only works if the whole operation is visible in real time. clickhou.se/4fdjA7G So they run a Real-Time Insights platform on ClickHouse across 20+ fulfillment centers and 5,000+ trucks, feeding thousands of Grafana
    How Picnic uses ClickHouse for real-time analytics across 20+ fulfillment centers and 1 million unique stores
    How Picnic uses ClickHouse for real-time analytics across 20+ fulfillment centers and 1 million...
    From clickhouse.com
    3.2K03.2K
  • user avatar
    ClickHouse
    @ClickHouseDB
    Jul 17
    Ask ClickHouse for "the best footballer ever" and it returns Lionel Messi. โšฝ Semantic search where ClickHouse calls the embedding model for you: aiEmbed turns text into a vector on insert. Demoed with Ollama and OpenAI, and any OpenAI-compatible provider works.
    clickhouse.com
    Vector embeddings in ClickHouse with Ollama and OpenAI | ClickHouse
    ClickHouse's new `aiEmbed` function generates embeddings directly in SQL โ€” no external pipeline needed. In this video, Mark Needham shows how to use it with both a local Ollama model and OpenAI....
    1.5K01.5K
  • user avatar
    ClickHouse
    @ClickHouseDB
    Jul 17
    Full-text search on object storage needs a different index design than on local disk. 94.5% of tokens appear in โ‰ค6 rows - that's the insight that made it work. We wrote it up in March.
    Building high-performance full-text search for object storage
    Building high-performance full-text search for object storage | ClickHouse
    From clickhouse.com
    1.4K01.4K
  • user avatar
    ClickHouse
    @ClickHouseDB
    Jul 17
    Bangkok ๐Ÿ‡น๐Ÿ‡ญ we're coming to One Bangkok Tower next Thursday! Bangkok OSS & Data Evening: Queries, Code & Community, hosted with LINE MAN Wongnai ๐Ÿ”น ClickHouse in the AI era, with a live AI support agent demo (ARISE by Infinitas) ๐Ÿ”น Scalable, secure data pipelines around
    1.1K01.1K
  • ClickHouse reposted
    user avatar
    Sai Srirampur
    @saisrirampur
    Jul 16
    .Love testimonials like this! Brings a ton of validation to the hard work team has been putting to build the world's fastest and most reliable Postgres service. Thank you @asaiUwU for the kind words and all the feedback during the migration. ๐Ÿ™ @ClickHouseDB
    user avatar
    ClickHouse
    @ClickHouseDB
    Jul 16
    We caught up with @roanakb and @asaiUwU from @TrainyAI, a @ycombinator company, to learn how switching from Amazon RDS to @ClickHouseDB Managed Postgres helped them make their OSS experiment tracker, Pluto, faster and cheaper to run, while bringing it under one unified roof ๐Ÿ‘‡
    6.6K06.6K
  • user avatar
    ClickHouse
    @ClickHouseDB
    Jul 16
    Is ClickHouse winning the observability wars? Charity Majors makes the case in our July newsletter, alongside hypothetical skip indexes in 26.6, a CostBench showdown with Snowflake, and our first virtual hackathon. ๐Ÿ”—
    July 2026 newsletter
    July 2026 newsletter | ClickHouse
    From clickhouse.com
    8540854
  • user avatar
    ClickHouse
    @ClickHouseDB
    Jul 16
    We caught up with @roanakb and @asaiUwU from @TrainyAI, a @ycombinator company, to learn how switching from Amazon RDS to @ClickHouseDB Managed Postgres helped them make their OSS experiment tracker, Pluto, faster and cheaper to run, while bringing it under one unified roof ๐Ÿ‘‡
    Why Trainy migrated from Amazon RDS Postgres to ClickHouse Managed Postgres
    Why Trainy migrated from Amazon RDS Postgres to ClickHouse Managed Postgres | ClickHouse
    From clickhouse.com
    5.1K05.1K
  • user avatar
    ClickHouse
    @ClickHouseDB
    Jul 16
    This Saturday in Delhi NCR ๐Ÿ‡ฎ๐Ÿ‡ณ ClickHouse in the Wild: Architecture Stories from Production ๐Ÿ”น Zykrr on migrating 150M+ rows from PostgreSQL to ClickHouse with zero downtime ๐Ÿ”น T9L on sub-second IoT logging for a distributed solar energy grid ๐Ÿ”น ClickHouse on performance
    9860986
  • user avatar
    ClickHouse
    @ClickHouseDB
    Jul 16
    Whether you're evaluating ClickHouse, building a proof of concept, or already running workloads, join ClickHouse expert Johnny Mirza to ask your questions on architecture, performance, migrations, best practices, or your own use caseโ€”and get expert guidance to help you move
    ClickHouse Open Office & Live AMA
    ClickHouse Open Office & Live AMA | ClickHouse
    From clickhouse.com
    8200820
  • user avatar
    ClickHouse
    @ClickHouseDB
    Jul 15
    16.2 billion rows of Binance tick data. 76 GiB on disk. $1.88/month. Queryable with standard SQL. New post walks through VWAP, OHLC candles, and ASOF JOINs, plus a flash crash analysis showing slippage spike to 260ร— normal in one second.
    Replacing the HDB: ClickHouse for historical ticker data
    Replacing the HDB: ClickHouse for historical ticker data | ClickHouse
    From clickhouse.com
    1.1K01.1K
  • user avatar
    ClickHouse
    @ClickHouseDB
    Jul 15
    ๐Ÿš€ ClickHouse v26.7 Community Call: July 23, 8 AM PDT / 5 PM CEST clickhou.se/4w4hVZ5 Live with Alexey Milovidov: new features, live demos, roadmap sneak peeks, and open Q&A. Users, contributors, and the ClickHouse-curious all welcome ๐Ÿ‘‡
    v26.7 Community Call
    v26.7 Community Call | ClickHouse
    From clickhouse.com
    9420942
  • user avatar
    ClickHouse
    @ClickHouseDB
    Jul 15
    clickhouse/rowbinary is a Node.js reader and writer for ClickHouse's RowBinary format that doubles as an Agent Skill. Instead of calling the library as a black box, a coding agent can read it as a reference implementation and forks it into a parser specialized for your exact
    @clickhouse/rowbinary: when your library is also a parser compiler
    @clickhouse/rowbinary: when your library is also a parser compiler | ClickHouse
    From clickhouse.com
    1.3K01.3K