Timescale Newsletter Roundup: July 2021

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.

[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.

[Product update #3]: Faster ingest and queries, save and retrieve metric meta-data, and improved observability features >>

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.

New technical content, videos & tutorials

[Watchlist #1]: Faster queries with time-series data on PostgreSQL: continuous aggregates in TimescaleDB >>

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.

[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.

[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.

[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.

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.

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.

[Reading list]: What is high cardinality, and how do time-series databases like InfluxDB and TimescaleDB compare? >>

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.

[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

Michael Freedman named Robert E. Khan Professor of Computer Science at Princeton! >>

Big congratulations to Mike Freedman, our CTO & co-founder, who was just named the Robert E. Kahn Professor of Computer Science at Princeton University 🎓.

Happy 25th birthday to PostgreSQL! 🎂 >>

We’re celebrating the release of PostgreSQL by rewinding it back with some of our favorite posts.

  1. Read about the top 5 favorites #PostgreSQL extensions (selected by the TimescaleDB community.
  2. Read this blog post on how and why to become a PostgreSQL contributor to start contributing to Postgres (or to contribute more!)
  3. 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 Francesco for breaking down why Typefully chose TimescaleDB (see Twitter thread for full details).

🙌 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.

Wrapping Up

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.

Thanks!
The Timescale Team

📆 To see past issues of this newsletter, check out our archives.

This post was written by
6 min read
Newsletter
Contributors

Related posts

TimescaleDB - Timeseries database for PostgreSQL

Explore TimescaleDB

Learn more about how TimescaleDB works, compare versions, and get technical guidance and tutorials.

Go to docs Go to products