The best way to host your analytics data is not doing it yourself.  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏  ͏
‍ ‍ ‍ ‍ ‍
SQL For Devs
Make Analytics Fast

Make Analytics Fast Course

Tiger Cloud

Hey, I want to first apologize that the last chapter of my TimescaleDB course took so long. It should have been released four months ago but I had a hand injury that prevented me from working. By now, you've hopefully tinkered on some analytics prototypes with TimescaleDB.

But how will you deploy them? Self-Hosting is a minefield with a ton of things you must do (blocking you from working on more important stuff):

  • Managing Servers (hardening, upgrades, applying security patches)
  • Performance Monitoring (server metrics, PostgreSQL metrics, alerting, knowing how to fix them)
  • Backups (corrupt backups for months when needed can end a business)
  • Availability (zero downtime server management, failover for unreachable servers)

Wouldn't it be better to offload all these tasks to someone else? Tiger Cloud is the managed TimescaleDB offering by the creators of TimescaleDB. So they know the ins and outs of the product and solve for you:

  • Automatic PostgreSQL tuning
  • Automatic TimescaleDB chunk interval tuning
  • Performance Insights to tell you which queries are slow and how their performance was in the past
  • Effortless High Availability setups so your database is always reachable
  • Effortless Read Replicas to increase the number of SELECTs you can do in parallel
  • Dynamic compute resizing to change the machine type without downtime

But the more interesting aspects of Tiger Cloud are the features they've built on-top of their offering that simplify handling with large analytics data:

Kafka Data Connector

Writing every change to TimescaleDB is slow. As you've experienced before, single-row inserts have a very low throughput ceiling so you must batch multiple inserts together. But that is another complex thing to write and tune. When you use Kafka, you can just write all data to it and Tiger Cloud will automatically move it to TimescaleDB for you in the most efficient way possible.

Tiger Cloud Kafka Connector

S3 Data Connector

The S3 Connector can be used if you already have saved the data somewhere and just want to get an efficient way to copy it to TimescaleDB. You periodically export a number of rows to a S3 bucket and Tiger Cloud keeps track of which files must still be copied.

Tiger Cloud S3 Connector

Agentic Workflows

You're not coding everything by hand yourself anymore. With the Tiger Cloud MCP you can let your AI agent spin up forks of your database with all data within milliseconds! Time consuming things of the past like testing many different performance optimizations can now be entirely automated.

Tiger Cloud S3 Connector

Let's jump over to Tiger Cloud and create your account with $1,000 free credits. They will manage your database and you can create a production-ready setup in minutes. Point your AI agent at the course, let it migrate all data overnight and you have a fast database tomorrow when you get your morning coffee.

Storage Management: Tiered Storage

I hope you learned a lot from this course
Tobias

This message was sent to aaa1@niepodam.pl.
If you don't want to receive these emails in the future, you can unsubscribe.