Timescale Newsletter Roundup: June 2022
Hello, hello! This issue of our newsletter roundup is full of special SQL sauce! June was our SQL month, so you will find an array of SQL-related content, from interviews to thought-leadership articles.
There is also a TimescaleDB patch fix to prevent the silent corruption of indexes in PostgreSQL 14, and you can also watch many of our sessions in recent events from the comfort of your home (or anywhere, really).
See you next month! 👋 If you enjoyed this content and wish to get new updates every two weeks, don't forget to subscribe to our newsletter (no fluff, no jargon, just lots of resources to perfect your time-series mastery!).
State of PostgreSQL 2022
In June, we announced that the third State of PostgreSQL survey was open for submissions and invited PostgreSQL users around the world to join the movement and share their answers with the rest of the community. Check out our blog post to learn more about this initiative and read some of the findings from previous surveys. Thank you for being a part of the community and especially to those who have already shared their PostgreSQL experiences with us!
Technical Content, Videos & Updates
[Read] OpenTelemetry: Where the SQL Is Better Than the Original >> OpenTelemetry provides a united front for instrumenting code and collecting observability data. But how do you query all that data? Can an old friend solve the query Babel tower without resorting to user interfaces? James Blackwood-Sewell answers these questions.
[Read] NLP’s Cloud Story on Using TimescaleDB to Monitor API Endpoints >> Julien Salinas, full-stack developer and founder of NLP Cloud, shares how his team monitors an advanced API that performs natural language processing tasks in several programming languages using TimescaleDB.
[Watch] Animating Time-Series Data (From PyCon US 2022)>> In her talk at PyCon US 2022, Miranda used play-by-play data from the NFL 2018 season to demonstrate the power of data animation for analysis and how you can animate data plots.
[Watch] All the Talks at the Prometheus and DoK Community Days >> Learn how you can connect Prometheus and OpenTelemetry Data for faster troubleshooting, how Prometheus indexes data (and why you should care), how you can store continuous benchmarking data in Prometheus, and how to integrate third-party, non-Prometheus-native services without writing.
[⚠️ Maintenance Event] >> We scheduled a maintenance event on June 21 for our Timescale Cloud users that includes an important PostgreSQL 14 patch fix to avoid silent corruption of indexes. As any other update, you will be upgraded in your next Timescale Cloud maintenance window.
- ☁ Timescale Cloud is a worry-free platform that ensures effortless upgrades fully managed by our team without downtime. On-demand patch updates? No worries, we got it. Enjoy your peace of mind.
[Read] How Prometheus Querying Works (and Why You Should Care) >> Learn how Prometheus indexing works to unlock the performance secrets of your PromQL queries. Plus, some tips to optimize your queries for supersonic results.
[Read] Processing and Protecting Hundreds of Terabytes of Blockchain Data: Zondax’s Story >> It’s not an easy job, but somebody’s gotta do it. Zondax, a software company specializing in Ledger apps development, shares how they achieved fast, responsive services in real time using TimescaleDB’s hypertables and other optimizations.
[Read] SQL Isn’t That Hard (When…) >> Is SQL hard to learn? We always hear this question, so we decided to answer it. Check out our interviews for the best learning resources, SQL tips, and inspiring community leaders (Robert Haas, Lætitia Avrot, and Postgres Tutorial, to name a few). Don’t forget to follow us on Twitter and LinkedIn—SQL was our June jam, and we launched one SQL tip weekly, along with other surprises.
- 💡 Read how an electrochemist turned database enthusiast got into SQL.
- 📚 A learner by exploration shares her favorite SQL resources and tools.
[Watch] Getting Started With Timescale >> If you haven’t tried TimescaleDB yet or are just getting started, we have the right playlist for you. Developer advocate Miranda Auhl will guide you through 11 lessons (plus intro) on Getting Started With Timescale. From basic SQL queries to saving space with SQL data compression, this free YouTube course has everything you need for a successful time-series kick off.
[Watch] Lesson 8: Foundations of PostgreSQL and TimescaleDB >> In this lesson, David Kohn explains the difference between a view and a materialized view in PostgreSQL, and how we made continuous aggregates work for time-series use cases.
Where We Were
[Event] European Women in Technology (June 8-9, Amsterdam) >> We were incredibly excited and proud to attend and support Europe’s largest tech event for women.
- 📺 Help us break the bias; watch the inspiring stories of Women in Tech in this YouTube series.
[Event] Security Best Practices with PostgreSQL Extensions at Postgres Vision (June 14-15, Virtual) >> Installing PostgreSQL extensions can pose a security risk if not done adequately. Ryan Booz guided event attendants on analyzing extension vulnerabilities in advance and using pgspot, a new open-source tool, to examine the extensions you’re regularly creating.
[Event] OTel Community Day (June 20, Austin, US) >> John Pruitt, senior software engineer at Timescale, presented a hands-on workshop on Analyzing and Visualizing OpenTelemetry Traces With SQL for the first edition of OTel Community Day.
[Event] Postgres Webinar Series (June 21, Virtual) >> Worried about creating performant aggregate functions in C and getting lost in the function-maintenance haze? At the Postgres Webinar Series, James Blackwood-Sewell walked you through creating, testing, and deploying custom aggregates with a little help from pgx, a framework for developing PostgreSQL extensions in Rust.