Pinned Tweet
Hello!
In case you’re new here, let us introduce ourselves...
We’re Propel, a Serverless ClickHouse platform.
We have:
- A Serverless ClickHouse service that's the easiest way to run ClickHouse at any scale.
- An API layer that exposes any ClickHouse table as an API.
- An open-source embeddable UI library to build data apps.
So, how about you - what brought you here?
🚀 Managing real-time data updates in ClickHouse can be challenging.
But with the ReplacingMergeTree table engine, you can keep your data clean and fresh with ease.
Here’s how: 🧵
1 of 6
Need real-time updates, efficient deduplication, and a way to manage mutable data in ClickHouse?
👉 ReplacingMergeTree is your answer.
5 of 6
Learn how to handle real-time updates without headaches, optimize sorting keys, and more in our latest blog post! 👇
propeldata.com/blog/understa…
6 of 6
🚀 Managing real-time data updates in ClickHouse can be challenging.
But with the ReplacingMergeTree table engine, you can keep your data clean and fresh with ease.
Here’s how: 🧵
1 of 6
Need real-time updates, efficient deduplication, and a way to manage mutable data in ClickHouse?
👉 ReplacingMergeTree is your answer.
5 of 6
Learn how to handle real-time updates without headaches, optimize sorting keys, and more in our latest blog post! 👇
propeldata.com/blog/understa…
6 of 6
💡 ClickHouse Tip of the Day 💡
For time-series data in ClickHouse, put the timestamp last in the ORDER BY clause.
This improves data locality and compression, ensuring better query performance for time-based analytics. ⏰
💡 ClickHouse Tip of the Day 💡
Using ReplacingMergeTree in ClickHouse is ideal for maintaining only the latest version of each record. It's excellent for real-time updates and deduplication.
We had a blast participating in MEGA LAUNCH WEEK with @launchweekdev and 21 other dev tool companies
Here is a recap of an epic week of launches 🧵👇
👉 Day 4: Data Grid React Component
🚢 MEGA Launch Week Day 4!
This one is big!
👉 Open-Source Data Grid React Component
The Data Grid is an open-source React component for easily visualizing data in a table format.
Features you no longer need to build:
◆ Built-in pagination
◆ Ordering and filtering
◆ Automatic column name formatting
◆ Built-in drawer for displaying row or JSON values
◆ Fully themable and customizable
Check out the demo and docs ↓
👉 Day 5: DynamoDB → Propel's ClickHouse
xitter.cf/PropelDataCloud/status…
We're ending the MEGA Launch Week with a bang!
👉 Day 5 Launch: DynamoDB → Propel's ClickHouse
DynamoDB excels as a transactional database, but it's not ideal for analytics involving aggregations and GROUP BY queries.
That's where Propel's DynamoDB connector shines. It allows you to replicate DynamoDB data in real time to Propel's Serverless ClickHouse, enabling advanced analytics that are both fast and cost-effective.
Key features:
◆ Seamless integration with DynamoDB streams
◆ Real-time replication of inserts, updates, and deletes
◆ No infrastructure management needed
◆ No need to pay for expensive ETL tools ❤️


