Databases
-
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 moreRead more... -
Publish SQL-based endpoints on NGINX log analysis
Building a highly scalable log analytics tool with Tinybird and exporting your queries as an API.Read more... -
Low-latency APIs over your BigQuery datasets
BigQuery is not designed (or priced) to withstand hundreds of requests per second. Here is how you can add Tinybird to the mix to productise that data.Read more... -
Querying large CSVs online with SQL
Tinybird lets you query CSVs with hundreds of millions of rows with SQL right from your browserRead more... -
Gain visibility over your asynchronous operations with the latest changes in our Jobs API
Now, you will be also able to see the status of your job queue from the UIRead more... -
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 ClickhouseRead more... -
Enriching Kafka streams for real-time queries
If you are using Kafka to capture large quantities of events or transactional data, you are probably also looking for ways to enrich that data in real-time. Here is how to do it with TinybirdRead more... -
The one cron job that will speed up your analytical queries in Postgres a hundred fold
What do you do when your transactions table in postgres has grown way too big to handle analytical queries? How do you answer business questions when it could take minutes to even get a `SELECT count(*) FROM transactions` going?Read more... -
Real-time analytics API at scale with billions of rows
How to create an analytics API that deals with billions of rows in a matter of minutes.Read more... -
ClickHouse Meetup Madrid videos
Read more...Last April we had the pleasure to host the ClickHouse meetup in Madrid. Altinity’s team normally organize meetups in different cities where local developers talk about their experiences using the technology, to later have a session about the ClickHouse roadmap by Yandex and Altinity. As you might noted already, we are huge fans of ClickHouse (the core of Tinybird Analytics) and it’s awesome to be able to talk to the people behind the technology.
-
Simple and effective time series prediction modeling using Tinybird Analytics
Read more...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) so, as you would expect, it is something every company would love to do. Good news is that there are many methods to do it: from sophisticated Machine Learning algorithms or advanced forecasting libraries like prophet to simpler approaches based on simpler statistical foundations, like the one we describe below.
-
Typical challenges of building your data layer. Things we've learnt from dozens of growing companies
Read more...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. Data has been a key component of any digital product for a long time now, but it hasn’t been until recently that we’ve started to devote significant resources to aggregating and making use of it. Even if you think you are devoting enough energy to data within your organization, most probably you aren’t.