Timescale Newsletter Roundup: June 2021

Timescale Newsletter Roundup: 
June 2021

In this edition, we're sharing a blog post filled with advice and tips about how to start contributing to Postgres (or contribute more!), where to get the latest updates on our #AlwaysBeLaunching initiative, recorded talks from recent virtual events we attended, and an assortment of our favorite tools, tips, and advice to help you do more with your time-series data.

We round out the list with a few of our favorite 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).

New technical content, videos & tutorials

[NEW]: How (and why) to become a PostgreSQL contributor >>

Contributing to open-source projects can be intimidating – and PostgreSQL is no exception. As a long-time PostgreSQL contributor, Aleksander Alekseev shares tips to help you make your first contribution or contribute more.

[NEW]: Save money and improve performance by carefully managing your time-series data >>

Managing your time-series data is essential to high-performance and cost-effective applications  – but what does it mean to “manage” your time-series data? Ryan breaks down 5 core components, why it’s especially complex for time-series data, and ways to use TimescaleDB’s built-in features (like compression, data retention, user-defined actions, and continuous aggregates) to solve common problems.

  • 👉 Get a quick breakdown of how to store, query, and archive your time-series data.
  • ▶️ Watch the video to see TimescaleDB’s built-in features in action, plus tips for getting started.

[Recap]: #AlwaysBeLaunching May 2021 roundup >>

In May, we kicked off our “Always Be Launching” (#ABL) initiative with an ambitious target: 10+ launches in 1 month. May was a jam-packed month, from our Series B fundraising news 🎉 to 6 Timescale Forge releases, 2 TimescaleDB releases, 1 Promscale release, and the State of PostgreSQL 2021 survey results.

[Replay]: Postgres.tv with Timescale CTO and co-founder, Mike Freedman >>

Mike Freedman joined Postgres.tv for an hour-long Q&A, covering a range of general computing and Timescale-specific topics. Learn about TimescaleDB’s origins, how we’ve designed core features, ways to find the proper chunk size, and lots more.

[Watchlist - Community]: Using Promscale + Prometheus+ PostgreSQL to go from Observation to Understanding DoK #51 >>

Replay this livestream to hear Matvey Arye speak on all things Promscale. Matvey covers topics ranging from architecture design and ways to create flexibility when querying your time-series data to the overall vision for Promscale and Tobs.

New #remote-friendly events & community

[Virtual Watercooler]: Timescale Monthly Office Hours (August 3rd) >>

Our monthly Office Hours series continues! Timescale Developer Advocate, Ryan Booz will be hosting our upcoming session on Tuesday, August 3rd. Anyone and everyone are welcome, whether you’re new to TimescaleDB, an experienced database pro, or somewhere in the middle – our technical team is happy to answer all questions.

[Virtual Event]: HasuraCon 2021 >>

Timescale Developer Advocate, Jonatas Paganini, spoke at HasuraCon 2021 on how to monitor the health of your database with TimescaleDB compression and GraphQL subscription endpoints in Hasura.

[Virtual Event]: Postgres Vision 2021 >>

Replay our talks from Postgres Vision 2021. We shared our thoughts on the future of data and breaking down the most interesting findings from the State of PostgreSQL 2021 report.

Talk 1: The Future of Data in a Cloud Native World

Talk 2: The State of Postgres: Insights from surveying 400+ developers

TimescaleDB tips, reading list & more

[Timescale Tip]: Get 94-97% compression rates (and other performance improvements) from best-in-class algorithms >>

Over the last few weeks, we looked more closely at some of TimescaleDB’s most popular features – and our built-in compression was up first. Learn how TimescaleDB uses time-series compression algorithms to give you the best possible compression rate, so you save on storage and compute without sacrificing query speed.

[Timescale Tip]: Analyze your time-series data with the power of full SQL in your favorite visualization tool >>

SQL is the most used language to access Postgres (according to the State of Postgres 2021 survey report). So we’ve rounded up a few resources to help you build fast and powerful dashboards while using the power of full SQL and accessing advanced features for time-series analysis.

[Reading List]: 13 tips to improve PostgreSQL database insert performance >>

Get our cheatsheet of best practices for optimizing your database ingest performance, including advice for vanilla Postgres and a few TimescaleDB-specific tips.

[Reading List]: Time-series data: Why (and how) to use a relational database instead of NoSQL >>

In this classic post, we detail how traditional databases handle time-series data, why neither option is quite right, and how TimescaleDB takes a different approach. The result: a relational database with minimized memory usage, robust index support, and scale (including 15x+ INSERT rate improvements 📈).

[Reading List]: How to use Grafana variables to make more interactive dashboard visualizations >>

Learn how to add features that allow you, your teammates, and your stakeholders to drill into specific details, see all results, and quickly get the info you need.

[Reading List - Community]: Using Postgres and TimescaleDB with Node.js series >>

In this 3-part series, David Fekke provides step-by-step instructions for installing and getting TimescaleDB running on your development machine, complete with a demo dataset.

Part 1

  • 👉 Read the blog post for more details about PostgreSQL and the differences between SQL and NoSQL databases.
  • ▶️ Watch the demo to learn how to install Postgres on docker, create a database and add data using Node.js.

Part 2

Part 3

  • 👉 Read the blog post to learn how to use TimescaleDB as an extension of Postgres.
  • ▶️ Watch the demo to learn about hypertables and how to create them in TimescaleDB.
  • 👏 Big thank you to @polyglotengine1 for this awesome project write-up and for sharing it with us! (We always love to hear how community members use TimescaleDB).

[TimescaleDB GitHub Poll]: Support for bucketing using months, years, and timezones for continuous aggregates >>

We’re keen to get community member feedback about continuous aggregates, specifically around support for variable-sized time_buckets (e.g., months and years) and the ability to materialize data based on a specific timezone.

This month in #remote-team fun: Cawfee Tawks 🍩☕ ️Julia  (top left), Eméry (top right), and Ajay (bottom) swapping fun facts.

What are Cawfee Talks? Learn how we're building a remote-first team culture for details – and tons of remote team-building ideas that you’re welcome to steal.

This month in #remote-bonding fun: To celebrate 🏳️‍🌈 Pride Month, we themed last month´s All Hands meeting “bright-colored shirt day”.

We're hiring! Check out our careers page to view all of our open positions.

Wrapping Up

And that concludes this month’s newsletter roundup. We’ll continue to release new content, events, and more - posting monthly updates for everyone.

If you’d like to get updates as soon as they’re available, subscribe to our newsletter (2x monthly emails, prepared with 💛 and no fluff or jargon, promise).

Happy building!

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