Timescale Newsletter Roundup: July 2021
In this edition, we’re sharing a cornucopia of new resources to help you do more with your data - including ways to get started with TimescaleDB hyperfunctions, analyze intraday stock performance, and the latest updates from Promscale. In addition, we’re sharing details on the TimescaleDB 2.3.1 release, and new talk recordings (and demos!). Finally, we round out the list with a few of our favorite PostgreSQL and time-series resources and awesome technical content from community members.
We’re always releasing new features, creating new documentation and tutorials, and hosting virtual sessions to help developers do amazing things with their data. And, to make it easy for our community members to discover and get the resources they need to power their projects, teams, or business with analytics, we round up our favorite new pieces in our biweekly newsletter.
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
[Product update #1]: TimescaleDB 2.3.1 release >>
We just released TimescaleDB 2.3.1, which contains the new ability to safely downgrade versions of TimescaleDB and various bug fixes since the TimescaleDB 2.3 release.
- 🔎 See the full release notes for details about all new features and improvements.
- 👉 See our upgrade docs to get started.
- 🐥 Read our Twitter thread for the release highlights of this release.
[Product update #2]: New SQL functions to simplify working with time-series data in PostgreSQL >>
Earlier this month, we announced the release of TimescaleDB hyperfunctions, a series of SQL functions within TimescaleDB that make it easier to manipulate and analyze time-series data in PostgreSQL with fewer lines of code.
- 👉 Read the blog post for more on hyperfunctions and why we built them.
- 🗂 Explore the roadmap on GitHub for in-progress and future hyperfunctions.
- 🐥 See the Twitter thread for a summary of the new features.
- 🔎 Visit docs to get started with hyperfunctions.
Promscale 0.5, released earlier this month, includes performance improvements for faster ingest and querying of data. We’ve also added support for saving and retrieving metric metadata information from Prometheus and improved the observability of Promscale itself, as well as various bug fixes.
- ✨ See our release notes for full details.
- 🖥 Follow our getting started with Promscale tutorial for installation instructions, sample PromQL and SQL queries, and more.
- 📺 Watch the Promscale 101 YouTube playlist for step-by-step demos and best practices.
New technical content, videos & tutorials
Performing analysis on time-series data often involves using aggregate functions that become slower over time, as you amass more and more data. In this video, Developer Advocate, Ryan Booz explains what continuous aggregates are, how they work and help you speed up your aggregate queries, and how they compare to PostgreSQL materialized views.
- 👉 Get an at-a-glance continuous aggregates overview.
- ▶️ Watch the explainer to see continuous aggregates in action.
- 🔥 Check out the playlist for tips on continuous aggregates refresh policies, and more.
[Watchlist #2]: Panel discussion: The future of data in a cloud-native world >>
Watch Timescale CEO, Ajay Kulkarni, and other industry leaders discuss strategies and key considerations for managing vast amounts of data in a cloud-native world.
[Watchlist #3]: The State of Postgres: Insights from surveying 400+ developers >>
Replay Avthar's talk from the Postgres Vision 2021, where he breaks down the most interesting results from the State of PostgreSQL 2021 report. Watch the talk to learn key findings from the 2nd annual survey, summaries of developer sentiment about Postgres, as well as recommendations for how to make the community even more welcoming and helpful to new developers.
- ▶️ Watch the recording to learn more about the State of PostgreSQL 2021 report.
- 📃 Check out the State of PostgreSQL 2021 site to see full findings and download anonymous source data.
[Watchlist #4]: Visualizing TimescaleDB compression status in real-time with Hasura >>
Timescale Developer Advocate, Jonatas Paganini shows you how to combine GraphQL, TimescaleDB, and Hasura to monitor the health of your database, see compression stats, and beyond.
- ▶️ Watch the 10-minute demo-packed lightning talk.
- 👉 Follow this tutorial to build your custom TimescaleDB dashboard.
[Watchlist #5]: Leveraging RDBMS for Prometheus >>
Replay Vineeth's talk from Kubernetes Community Days Bengaluru where he covers reasons for adopting relational database systems (RDBMS) for observability time-series data, how TimescaleDB and Promscale handle high-velocity data, and beyond.
[Time-series fun]: Analyze historical intraday stock data >>
In this new tutorial, we tackle one of the most common uses for time-series data: collecting and analyzing intraday securities information. You’ll collect stock data, store it in TimescaleDB, and get 8 SQL queries to jumpstart your analysis.
- 💰 See our step-by-step tutorial to get started.
- ▶️ Replay the live stream to watch Attila build the tool for stock analysis.
- 🎓 Explore our full list of tutorials for more time-series fun!
New #remote-friendly events & community
[Virtual watercooler]: Timescale Monthly Office Hours (August 3rd) >>
Join us Tuesday, August 3rd, for monthly Office Hours. This session will be hosted by Timescale Developer Advocate, Ryan Booz. Learn about our newest features and upcoming releases, watch demos and ask any questions you have for our engineers.
- 🗓 Reserve your spot for the upcoming session.
- 💬 If you can’t join but have a question, reach out to our engineering team on Slack.
TimescaleDB tips, reading list & more
[Reading list]: What are time-weighted averages and why should you care? >>
In his latest blog post, Timescale engineer David Kohn details what time-weighted averages are, why they’re so powerful for data analysis, and how to use TimescaleDB hyperfunctions to calculate them faster – all using SQL.
- 👉 Read the blog post for a time-weighted averages overview, sample queries, and more.
- 💬 Visit the GitHub discussion page to post comments, ask questions, and share feedback.
- 🧾 See the hyperfunctions docs to get started with time-weighted averages in your projects.
In the world of databases, cardinality refers to the number of unique values contained in a particular column, or field, of a database, and with time-series data, things get a bit more complex. Our engineers cover what causes high-cardinality, how it looks in the real world, and how different time-series databases handle this "problem."
[Community spotlight]: How I power a (successful) cryptobot with TimescaleDB >>
Our friend Felipe Queis shares how he combines ML, TimescaleDB, and Node.js to power a crypto trading bot that’s netted several successful trades (+487%!). He details how his bot works, why he selected TimescaleDB, sample queries, favorite resources, and beyond.
- 💰 See Felipe’s Reddit AMA for even more tips and technical details.
[Reading list - Community]: Utilizing TimescaleDB for handling time-series data >>
Get Atlantbh’s take on why time-series data is so important, their suggested criteria for choosing a time-series database, tips for getting get started with TimescaleDB, and lots more.
[Podcast]: Timescale: Time-series databases with Mike Freedman >>
Timescale CTO and co-founder Michael Freedman talks all things time-series with Jeff Meyerson at Software Daily. Listen to learn more about how and why we built TimescaleDB, our "help-first" approach, the challenges we're looking to solve next, and more
Big congratulations to Mike Freedman, our CTO & co-founder, who was just named the Robert E. Kahn Professor of Computer Science at Princeton University 🎓.
- Learn more about Robert E. Kahn – Turing Award winner and widely considered one of the "fathers of the internet."
We’re celebrating the release of PostgreSQL by rewinding it back with some of our favorite posts.
- ️ Read about the top 5 favorites #PostgreSQL extensions (selected by the TimescaleDB community.
- Read this blog post on how and why to become a PostgreSQL contributor to start contributing to Postgres (or to contribute more!)
- Read our PostgreSQL INSERT cheatsheet to get 13 ways to improve your database performance.
[Developer survey]: Take part in the ‘Developer Nation’ survey >>
SlashData’s annual ‘Developer Nation Survey’ is now open. The survey includes questions about your favorite tools and platforms for developers and no-code software creators – and participants will have access to results and emerging trends after the survey closes.
Tweets of the week 🏆 (July newsletters winning tweets!)
🙌 Shoutout to @Adamln0ue for sharing his experiences with compression.Thanks for being such an awesome member of the TimescaleDB community!
- Visit our docs to read more about compression and how to enable it to save storage and speed up your queries.
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.
The Timescale Team
📆 To see past issues of this newsletter, check out our archives.