Timescale Newsletter Roundup: May 2022

Timescale Newsletter Roundup: May 2022

Welcome to another newsletter roundup; glad to see you!

In this issue, you will find new blog posts on automatically instrumenting Kubernetes apps using OpenTelemetry and the PostgreSQL community, you can listen to the insights of our co-founder, Ajay Kulkarni, on the Open Source Podcast, and take a deep dive with us on all things metrics.

Plus, tips for growing your developer career and an introduction to a bunch of new cool features of Promscale, our observability backend powered by SQL.

Scroll down for a full snapshot of the content we shared with our readers this month (and don't forget to subscribe to get updates straight to your inbox).

New Technical Content, Videos & Updates

[Read] Point-in-Time PostgreSQL Database and Query Monitoring With pg_stat_statements

Database monitoring is crucial for effective data management and building high-performance applications—cue in pg_stat_statements. In our first article about this PostgreSQL extension, we showed you how you could enable it. Our latest blog post guides you on avoiding one of its pitfalls to suit all your database monitoring needs.

  • Check out how you can transform cumulative data on your database performance into time-series data by regularly storing snapshots of the metrics.

[Read] Teaching Elephants to Fish

Drawing inspiration from his keynote talk at the PGConf NYC last year in New York, Timescale’s director of developer advocacy, Ryan Booz, reflects on the PostgreSQL community and suggests five ways to improve it.

  • Read our blog post to learn how you can lead your community with curiosity and empathy.

[Watch] PostgreSQL Aggregation: How to Create and Use Custom Aggregates

Are you still struggling with PostgreSQL aggregation? Join us in this course on the Foundations of PostgreSQL and TimescaleDB! In our 5th class, we’ll look at everything from functions (transition and final functions), extensions and object creation hooks, developing PostgreSQL extensions in Rust, and more.

[Watch] Data on Kubernetes Talks #126

See how you can automatically instrument Kubernetes apps using OpenTelemetry (without even changing your code!) in this fun talk where Bart Farrell, the incredible Data on Kubernetes’ head of community, welcomed our thunder from down under a.k.a. developer advocate, James Blackwood-Sewell.

[Read] A Deep Dive Into OpenTelemetry Metrics

Learn more about the philosophy behind them, how OTel turns Measurements into Metrics, and the six types of Instruments you can use to capture Measurements.

[Read] Five Lessons for Managing Growth and Career Development in Software Companies

Managing your career growth and development in software companies can be tricky. Drawing from personal experience and based on his talk earlier this year at the Postgres Conference in Silicon Valley, our VP of Engineering, Chad Berkley, shares five lessons for healthy and productive organizations.

[Listen] Open Source Startup Podcast E30

A big shout out to our friends from the Open Source Startup Podcast for having us on their show! Hosts Robby and Tim chatted to our co-founder and CEO, Ajay Kulkarni, about TimescaleDB, our 8,000+ Slack community 🙌  and how we raised over $180 million from investors.

[Read] Observability Powered by SQL: Understand Your Systems Like Never Before With OpenTelemetry Traces and PostgreSQL

You can now access telemetry data and interrogate it with random questions (and get results back in real time) using a good old open-source SQL database. Yeah, we did that. 💪  But wait, there’s more: our latest blog post introduces you to pre-built Grafana dashboards that you can integrate into your Grafana instance for immediate post-deployment insights.

[Update] No-Fuss Alerting: Introducing Prometheus Alerts in Promscale



Do you set alerts in Prometheus to keep track of your systems? Of course you do. Well, you can now use the same standard to define alerts directly within Promscale using PromQL queries.

[Update] Get Down(sampled) With Prometheus Recording Rules in Promscale


You can now configure Recording Rules directly in Promscale using PromQL—and the same configuration file you would use in Prometheus. 🥳 In our new blog post, we walk you through the configuration of Recording Rules in Promscale to get the most of them as a downsampling mechanism.

[Watch] SQL Tricks of an Application DBA

Database administrators have been sharing their rules of thumb with each other for years. In our latest Timescale Community Day, we were lucky to welcome software developer and tech lead Haki Benita, who compiled all his essential tips into one talk.


Where We Were


[Event] o11yfest 2022 (May 9-12, Virtual)


Watch two presentations with the Timescale touch: Easing OpenTelemetry Adoption Using the OpenTelemetry Operator, by product manager Vineeth Pothulapati, and Going Deep Into the (Mis)Behaviors of Your Distributed Systems with OpenTelemetry and SQL, by Ramon Guiu, VP of Observability.

[Event] PostgreSQL Conference Germany (May 13, Leipzig)


One year of lessons in just one session: join Timescale’s senior engineer Oleksii Kliukin as he shares what his team has learned from running a managed PostgreSQL/TimescaleDB service on Kubernetes on AWS for little more than 12 months.

[Event] PrometheusDay Europe 2022 (May 17, Valencia, Spain)


Metrics fanatics, unite! On this day dedicated to observability and the Prometheus community, the Timescale Team delivered not one, not two, but three talks 🎉, including a keynote.

[Event] Write the Docs Portland 2022 (May 22-24, Virtual)


Timescale’s technical writer, Lana Brindley, was at the event on May 23 to provide tips on building and growing a docs team. Watch her talk, where she shared her 17-year experience in documentation management, and get into the specifics of building a docs team—tools and workflow organization included.

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!

The open-source relational database for time-series and analytics.
Try Timescale for free
This post was written by
4 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