Timescale Newsletter Roundup: February 2022
In this month’s newsletter edition, we’re bringing you some product updates ✨ including two new storage autoscaling for multi-node services in Timescale Cloud! Now, you can forget about full disks also in your multi-node clusters. We also released a new version of Promscale with significant performance improvements and TimescaleDB 2.6 🔥
But this edition is also packed with new content! For example, Developer Advocate Ryan Booz explains how to retrieve the most recent record in PostgreSQL using different methods, a blog post that has already become a community favorite! But if you prefer a read on observability, you can also learn how to integrate Timescale Cloud with Promscale in a Kubernetes environment.
The last week in February, we shared our Series C fundraising announcement, led by Tiger Global alongside all existing investors: Benchmark, New Enterprise Associates, Redpoint Ventures, Icon Ventures, and Two Sigma Ventures. With this funding, Timescale is now valued at over $1 billion! 🐯 🦄
One more thing: if you like crypto and good user stories, check out our latest Developer Q&A, where TradingStrategy presents how they built a data stack for crypto quant trading using TimescaleDB.
We’re on a mission to teach the world about time-series data, supporting and growing communities around the world. And, sharing educational resources as broadly as possible is one way to do just that.
Here’s a snapshot of the content we shared with our readers this month (subscribe to get updates straight to your inbox).
Product updates & announcements
[Big announcement] Year of the Tiger: $110 million to build the future of data for developers worldwide
We had fantastic news to announce this week: we raised $110 million in our Series C, led by Tiger Global alongside all existing investors (Benchmark, New Enterprise Associates, Redpoint Ventures, Icon Ventures, and Two Sigma Ventures). This is the year of the tiger!
- 👉 Read the announcement blog post.
- 🧵 Catch all the highlights in the Twitter thread.
- 🎧 Listen to this audio conversation with our co-founders Mike Freedman and Ajay Kulkarni.
[New!] Introducing our new Timescale Community Forum
We've been deliberately low key about our brand new Timescale community forum, but it's time to be loud and proud! Yes, the talking is over; we're excited to announce the launch of our community forum. If you've been lurking in Slack but longing for a more traditional, long-form channel for discussions about TimescaleDB, Promscale, PostgreSQL, observability, and data-intensive applications then we have your back! Sign up and start a conversation!
- 👉 Sign up and start a conversation!
- 💬 We're still chatting away in Slack for your real-time questions and suggestions. If you want to keep an eye on the forum action, though, head to Slack and subscribe to the #latest-forum-topics channel.
- 📘 Read our announcement blog post.
[Product update] TimescaleDB 2.6
We released a new version of TimescaleDB 🔥 including top requested features by our community: compression for continuous aggregates, and the experimental support for timezones in continuous aggregates! Now, you can compress your continuous aggregates to boost your storage savings even more. 💸 Plus, you can use
time_bucket_ng in your continuous aggregates, which gives you the ability to bucket by months, years, and timezones.
- ✍️ Read our blog post to learn more about TimesaleDB 2.6.
- 📺 Check out this demo to see how everything works in action.
- 📚 See the release notes for a complete list of changes.
[Product update] Autoscaling is now available for multi-node services in Timescale Cloud
Say goodbye to full disks! You can now enable storage autoscaling in your multi-node services. For multi-node services, autoscaling works separately for the access and data nodes. If your access node and/or data nodes reach 95% capacity, they will be autoscaled to the next available storage plan. Plus, you can set up different autoscaling limits for access and data nodes to make sure your bill remains under control.
- 🔎 Check out our docs to learn more about this feature.
- 📘 Want a deeper dive? Read our blog posts on autoscaling and multi-node.
[Product update] Promscale 0.10.0
We also released a new version of Promscale, including improvements in the Prometheus metrics system and many bug fixes. We also announced that we’ll be dropping support for Timescale 1.x and for running Promscale without the promscale_extension, a Postgres extension containing important support functions that improve the performance of Promscale.
- 📚 Read the release notes for the complete list of changes.
- 👉 Check out our docs for instructions on how to install Promscale.
[Product update] Promscale 0.9
We released a new version of Promscale, including significant CPU performance improvements for start-up and data ingest, improved compression, and metrics instrumentation for the embedded OpenTelemetry gRPC server.
- 📚 See the release notes for a complete list of changes.
- 🔥 New to Promscale? You can install it using tobs, our CLI tool.
New technical content, videos & tutorials
[Developer Q&A] How Trading Strategy built a data stack for quant trading
In this blog post, our friends from Trading Strategy share how they’ve set up their data stack to ingest, integrate, and analyze data about thousands of crypto assets and smart contracts to power their decentralized investment service.
[Time-series fun] Store k6 metrics in TimescaleDB and visualize with Grafana
This tutorial sends k6 metrics to TimescaleDB for scalable long-term storage, analytics, and easy querying with SQL. (k6)
[Watchlist] What more can I learn from my OpenTelemetry traces? DoK Talks #115
Promscale Engineer John Pruitt blew our minds during his stream with Data on Kubernetes Community by showing us how deep you can get by combining traces and SQL! Watch his talk to learn how to build powerful Grafana dashboards using OpenTelemetry traces, giving you a level of insights into your systems that you probably haven't seen before.
[Watchlist] Timescale talks from PGConf NYC 2021
The recordings from PGConf NYC 2021 sessions are now available to watch on-demand on YouTube! Check them out below:
- 📺 Teaching elephants to fish by Ryan Booz.
- 📺 Managing PostgreSQL changes for the Agile DBA by Ryan Booz.
- 📺 How PostgreSQL aggregates work and how to create and use custom aggregates effectively by David Kohn.
[Watchlist] Deploy a full CNCF-based observability stack in under 5 minutes with tobs (CNCF on-demand webinar)
In this collaboration with our friends from the CNCF, Vineeth Pothulapati from the Promscale team explains how you can set up a full open source observability stack in your Kubernetes cluster (including Prometheus, OpenTelemetry, Grafana, Jaeger…) in a few minutes.
[Podcast] Kubernetes Observability using Promscale and tobs
Vineeth Pothulapati joined Kubernetes Bytes to chat about observability! They covered why observability is booming right now, which are the three pillars of o11y, and how the CNCF tools (like Prometheus and OpenTelemety) can help you get started with your observability practice.
New #remote-friendly events & community
Virtual – Timescale virtual monthly Office Hours (April 5)
If you haven’t joined our monthly sessions yet, now’s your chance! Office Hours are always different, topics ranging from best ways to integrate with third-party tools to musings on open-source technology. No matter what, they are always chock-full of expert advice, community projects... and fun!
- 🗓 Reserve your spot for the upcoming session.
- 💬 If you can’t join but have a question, reach out to our engineering team on Slack!
[Virtual event] Timescale Community Day (March 31)
Join in on the fun for Timescale Community Day – a jam-packed live stream event to learn about all things time-series, PostgreSQL, TImescaleDB, Promscale, and more. You'll have the opportunity to connect with Timescale community members, get expert tips, and much more!
- 📆 Save the date!
- 📧 Subscribe to receive event updates (we promise not to spam you).
- 📺 Watch last year's Community Day on our YouTube any time!
TimescaleDB tips, reading list & more
How to build TimescaleDB on Docker
Did you try to build TimescaleDB in Docker, but found the experience a bit challenging? 👀 This new blog post lays out everything you need to know about building TimescaleDB on Docker, including step-by-step instructions and best practices.
Learn OpenTelemetry tracing with this lightweight microservices demo
We often talk about how much OpenTelemetry traces can help you troubleshoot your systems, but there’s nothing like learning by doing… So we’ve built a lightweight, easy-to-deploy microservices demo instrumented with OpenTelemetry tracing! 💥 You’ll have it up and running in 5 minutes using docker-compose, including Jaeger and Grafana. The demo also comes with 6 pre-built Grafana dashboards so you can immediately explore your traces.
- ✍️ Read the blog post to get an in-depth overview of the demo and the Grafana dashboards. We also dive deep into the SQL we used to build them!
- 💻 See this repo to access the demo (including the dashboards).
Select the most recent record (of many items) with PostgreSQL
Get five methods for retrieving the most recent data for each item in your PostgreSQL database quickly and efficiently.
How to turn Timescale Cloud into an observability backend with Promscale
Want to integrate Timescale Cloud and Promscale in Kubernetes? Read our latest blog post to learn how to integrate a full observability stack with Timescale Cloud, also covering how to configure Prometheus, Grafana, and Jaeger for Promscale.
And, lastly, if you know someone who'd like to join our team – or learn more about life on Team Timescale 🐯 – we're currently hiring across all teams (and 100% remote). Check out our careers page to view all of our open positions.