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
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.
- 👉 Read the blog post to learn how to get started contributing to PostgreSQL.
- 🐥 See Aleksander’s Twitter thread to catch some additional highlights.
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.
- 🐥 See Ajay's Twitter thread to catch the big highlights.
- 👉 Visit our #AlwaysBeLaunching library to explore all announcement blogs.
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.
- 🗓 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]: 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.
- ▶️ Watch the Future of Data in a Cloud Native World panel discussion, where Ajay Kulkarni (Timescale CEO) joined other industry leaders to discuss strategies + key considerations for managing big amounts of data in a cloud-native world.
- 👉 See Postgres Vision 2021 for full event details.
- ▶️ See The State of Postgres: Insights from surveying 400+ developers, with Avthar Sewrathan (Timescale PMM) for key takeaways, opportunities, and more.
TimescaleDB tips, reading list & more
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.
- 👉 Get an at-a-glance compression overview.
- 🔎 Check out the TimescaleDB compression docs to get started.
- ▶️ Watch the demo to see it in action.
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.
- ▶️ Watch the Guide to Grafana playlist to get a series of demo-packed technical dashboarding sessions.
[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.
- ▶️ Watch 5 ways to improve your PostgreSQL INSERT performance for step-by-step demos.
- ⛏ Explore the Time-Series Benchmarking Suite to replicate our webinar demo (or benchmark any time-series database's performance).
- ✅ Have questions or want to add a tip to our list? We’d love to hear from you - reach out on Slack.
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 📈).
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.
- 👉 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.
- 👉 Read the blog post to learn how you can store and query data from tables and indexes.
- ▶️ Watch the demo to see how you can create tables and indexes on Postgres.
- 🔎 Explore our Node.js quick start guide for installation tips and sample queries.
- 👉 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.
- 🗳 Check out the GitHub discussion to vote for your preferred option(s) and any comments.
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.
We're hiring! Check out our careers page to view all of our open positions.
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).