Timescale Newsletter Roundup: July 2022
Welcome to our July newsletter roundup! We had a lot going on this month—join us along for the ride. First, we share the results of our worldwide survey on the PostgreSQL community: the State of PostgreSQL report is back for the third year to share how PostgreSQL users work, the tools they use, and what are their thoughts on the community.
Second, learn how to do better and faster aggregation on PostgreSQL and how to write truly efficient queries for time-series analysis, courtesy of our #AlwaysBeLaunching week.
And third, check out our resources on SQL, PostgreSQL, observability, and much more. There's a bit of everything for everyone, from views and materialized views in PostgreSQL (a lengthy and incredibly detailed explanation by Timescale's own David Kohn) to Observability and metrics, as we round off a series of three blog posts with an article that compares Prometheus and OpenTelemetry metrics.
Enjoy! See you next month!
State of PostgreSQL 2022
The State of PostgreSQL 2022 results are in! Our goal was to learn more about how people around the world use PostgreSQL—and we hope you find the results as interesting as we do. Thank you to everyone who took the time to share your experience with PostgreSQL. 🙏
[Read] State of PostgreSQL: How to Contribute to PostgreSQL and the Community >> As we prepared the full report of the 2022 State of PostgreSQL survey, one theme remained: PostgreSQL users still find that contributing to PostgreSQL can be slightly challenging. We sifted through our initial results to provide help and tips on being an active community member.
[Read] State of PostgreSQL 2022: 13 PostgreSQL Tools That Aren't psql >> Performance and tooling are frequently debated in the State of PostgreSQL survey, and this year was no exception. With psql remaining the number one tool for querying and admin among PostgreSQL users, we decided to compile a list of tools— that aren’t psql—to broaden your options.
[Read] What PostgreSQL Contributor Heikki Linnakangas Has to Say About the State of PostgreSQL 2022 >> PostgreSQL celebrates its 25th birthday this year. For a deeper look into its community, we asked PostgreSQL developer and committer Heikki Linnakangas to comment on the survey results of the newly released State of PostgreSQL 2022 report. Read what he had to say.
Technical Content, Videos & Tutorials
[Read] How PostgreSQL Views and Materialized Views Work and How They Influenced Continuous Aggregates’ Design in TimescaleDB >> Continuous aggregates are one of TimescaleDB’s most popular features. Still, it’s challenging to fully understand them without some context on PostgreSQL views and materialized views. In this blog post, we fill that gap and tell you the story of how views and materialized views shaped the design of this feature.
- 📖 Check our docs to learn more about continuous aggregates, and read all about their latest revamp in this blog post.
[Read] Prometheus vs. OpenTelemetry Metrics: A Complete Guide >> Prometheus or OpenTelemetry? As you monitor your systems, we believe this is a choice you will have to make sooner or later, which is why we rounded off our three-part series on metrics by explaining the differences, similarities, and integration between the metrics in both systems.
📒 Read our metrics series' first two blog posts: deep dive into the four types of Prometheus metrics, and then examine how metrics work in OpenTelemetry.
#AlwaysBeLaunching Week—Product Updates
[Read] How We Made Data Aggregation Better and Faster on PostgreSQL With TimescaleDB 2.7 >> Continuous aggregates are now better and faster: check out our two benchmarks with real-world datasets to see how we made PostgreSQL queries up to 44,000x faster and 60 % lighter 💰.
- Read our release notes to learn everything that’s changed in our 🆕 continuous aggregates, and compare our benchmark figures in this blog post.
[Read] How We Fixed Long-Running PostgreSQL now( ) Queries (and Made Them Lightning Fast) >> Questions around slow now() queries featured regularly in our forum and Community Slack. Not anymore. Learn how we fixed this issue in TimescaleDB 2.7 and made it up to 400x quicker! now()that is fast!
- ☁ If you’re a Timescale Cloud user, you will be automatically upgraded to TimescaleDB 2.7. Using TimescaleDB in your own instances? Read our docs for instructions on how to upgrade.
[Read] How to Write Better Queries for Time-Series Analysis With Custom SQL Functions >> TimescaleDB hyperfunctions make it easier to manipulate and analyze time-series datasets with fewer lines of SQL code. With more than 70 hyperfunctions already available, we show you some of the most popular ones and how you can use them for a more effective time-series analysis.
- 💻💨 If you’d like to learn more about hyperfunctions and how to leverage them for your use cases, read our How-To Guide and our docs.
[Read] Slow Grafana Performance? Learn How to Fix It Using Downsampling >> Are your large datasets making your Grafana graphs slow or difficult to read? See how you can replace large sets of data points for smaller ones (a.k.a. downsampling) using two TimescaleDB’s hyperfunctions to rev up your visualizations.
- 📊 Looking for more Grafana guides? Check out our Grafana tutorials and the Grafana 101 Creating Awesome Visualizations for more support on visualizations in Grafana.
[Read] What Is SQL Used For? To Build Environments Where Devs Can Experiment >> Nikolay Samokhvalov has worked with SQL for over 20 years. In this blog post, he shares some favorite resources to update your SQL knowledge and starting advice: “go big or go home!”.
[Read] What Is SQL Used For? Kubernetes and Secure Infrastructures >> Vettabase’s PostgreSQL consultant Michael Aboagye reveals SQL tips for beginners, his favorite query, the best tools to solve Kubernetes issues, and the real reason why he got into computing: learning You Got Served dance moves.
[Read] SQL Isn’t That Hard (When You Don’t Approach It From an Object-Oriented Point of View) >> Having used SQL for many years, Timescaler John Pruitt has carved a career in the database space. In this interview, he shares his experience and tips for learning the programming language.
[Read] SQL Isn’t That Hard (If You Have the Freedom to Experiment) >> Haki Benita says he made every mistake in the book when it comes to database management, but that didn’t prevent him from becoming a respected voice in the field. Read his SQL starter tips, favorite educational blog posts, and why he changed from Oracle to PostgreSQL.
[Join] Twitter SQL Community >> If you use Twitter, and Twitter Communities is available in your country, you may want to join the new SQL Twitter community that our community manager has initiated. The goal is to share SQL hints and tips with the community and also be a vendor-neutral safe space to ask and receive SQL advice. Take a look?
Catch Up With Us
[Event] PGConf.Brasil 2022 (August 26-27) >> PGConf Brasil is the PostgreSQL event in all of Latin America. Do not miss Timescale engineer Jonatas Paganini’s talk on how to remember the commands and understand the interface flow when using SQL in the terminal.
[Watch] Workshop: Analyzing and Visualizing OpenTelemetry Traces With SQL >> In this workshop, learn how to use tracing analysis as a proactive tool to spot issues before your customers do. You will ingest OpenTelemetry traces into a TimescaleDB database and learn how to build powerful custom dashboards in Grafana using SQL, giving you deep insights into your distributed systems and helping you make the most out of your tracing data.
Our July newsletter roundup is over—we hope you enjoyed it as much as we did!
In the meantime, don't forget to subscribe to our newsletter for updates sent straight to your inbox every two weeks!