Building In Public Featured How to scale a real-time data platform Tinybird is an enterprise-grade data platform with large customers processing huge amounts of data. Learn how we scale to support their use cases.
ClickHouse Adding JOIN support for parallel replicas on ClickHouse We recently introduced a pull request to ClickHouse that enables simple JOIN support for parallel replicas on ClickHouse. The solution may be simple and naive, but the ceiling for performance on distributed queries just got WAY higher.
Our Beliefs When you should use columnar databases and not Postgres, MySQL, or MongoDB Row-oriented, OLTP databases aren't ideal application DBs when you know you'll need to run analytics on lots of data. Choose a column-oriented OLAP instead.
Our Beliefs The hard parts of building data systems with high concurrency Here are 8 things to think about when you're trying to scale in realtime.
Tech Spatial Indexing aids Finding which Polygons contain a Point Speed up your queries by using a spatial index to select fewer polygons before testing if a point is inside a polygon.
Data 101 Starting with Kafka I just want to share my thoughts on Kafka after using it for a few months, always from a practical point of view. I don’t know anything more than the basics ...
ClickHouse ClickHouse tips #3: the transform function Using the transform function to join two tables when joinGet is not available.
ClickHouse Clickhouse, Open Source and Tinybird We are hiring full-time Clickhouse Developers. Find out why we contribute to Open Source (ClickHouse) and why we want to contribute much more.
Tech Publish SQL-based endpoints on NGINX log analysis Building a highly scalable log analytics tool with Tinybird and exporting your queries as an API.
ClickHouse Clickhouse Tips #1: Calculating Aggregations After a Given Date Tips and recipes to learn how to make the most of ClickHouse, curated weekly by the Tinybird team.
Product Product design: how our SaaS integrates with git Analytics data projects are code and code should be in a repo.
Building In Public How we processed 12 trillion rows during Black Friday In this post we explain the data architecture, infrastructure and how we scale our real-time analytics service with ClickHouse.
What We're Reading The Fremen – What our team is reading If you want to know how to work with new or limited resources, find a population that’s used to not having many alternatives.
What We're Reading Getting real – What our team is reading The best software has a vision. The best software takes sides. When someone uses software, they’re not just looking for features.
What We're Reading New ideas often emerge or are developed in response to extreme needs arising during a social crisis – What our team is reading World War II, for example, forced innovation or accelerated development and commercialization of the jet engine, pressurized aircraft cabins, helicopters, at...
What We're Reading The most sophisticated piece of software ever written – What our team is reading What is the most sophisticated piece of software ever written?
What We're Reading The Guns of August – What our team is reading Why the birds are the world's best engineers
What We're Reading A high production rate solves many ills – What our team is reading If you have a high production rate, you have a high iteration rate. For pretty much any technology whatsoever, progress is a function of iteration.
What We're Reading Facebook rewrites their messenger application using 20 year old techniques – What our team is reading Kids learn to make good decisions by making decisions, not by following directions
What We're Reading Memory bandwith Napkin Math and more readings from our team members Real-Time APIs and ETLs, how Github deals with database migrations, memory bandwidth math and more: most interesting articles coming from our flock
Product Try out Tinybird's closed beta Working with large amounts of data is challenging, but we believe it should not be complex. Everybody is waking up to data and its possibilities. We constant...
ClickHouse ClickHouse Meetup Madrid videos Last April we had the pleasure to host the ClickHouse meetup in Madrid.
Tech Simple Time Series Prediction Modeling Using Tinybird Time series predictions are one of the most common use cases you can find. Predicting the future, enables you to get ready for it (and act accordingly).
Data 101 Typical Challenges of Building Your Data Layer When you start a digital product you usually put your data in a database. It does not matter if it is a simple text file, an excel spreadsheet or a managed Postgres instance on the cloud, your data always lives somewhere.
