129: Time series data with Timescale DB

Tracking, analyzing and visualizing time series data can add a lot of business value to a project! We met up with Dave Lucia to learn more about Timescale DB, a PostgreSQL extension that adds time series tools to our regular database. Dave also created a timescale hex package to make it easier to work with hypertables and hyperfunctions. We learn why Timescale DB makes sense over other options, how to get started with it, example use cases, helpful resources and more! Show Notes online - http://podcast.thinkingelixir.com/129 Elixir Community News https://adventofcode.com/ – Advent of Code is going on https://gist.github.com/marpo60/bcf7dd45003adfe01b5581d03157a5de – Marcelo Dominguez' Livebook template for working on the daily problems. https://genserver.social/notice/AQAdGQAE5sgRL8x1g8 – José Valim created a repository to share all the Livebooks he has worked on, including talks and last year's Advent of Code https://github.com/josevalim/livebooks/ – José Valim's collection of shared public Livebooks https://github.com/rosaan/advent-of-code-2022 – Some shared solutions https://twitter.com/josevalim/status/1597880468032040960 – Explorer v0.4.0 is out https://hexdocs.pm/explorer/0.4.0 https://hexdocs.pm/explorer/0.4.0/Explorer.Query.html – Explorer.Query is a new API for writing expressive and performant queries https://podcast.thinkingelixir.com/104 – Chris Grainger talked about Explorer with us in episode 104 https://tips.nerves-project.org/ – Nerves website gets a new “tips” view https://twitter.com/josevalim/status/1597943279164993537 – José Valim announced he was migrating to the genserver.social Mastadon server https://genserver.social/josevalim – José's genserver.social profile https://genserver.social/notice/AQIfjB7SQcuEwPGEAC – José teased something "really big". Already released by the time you hear this. https://genserver.social/notice/AQIlH84yjkrh856rS4 – The graphic he teased http://codebeammexico.com/ – Code BEAM Lite México, March 3-4 2023 in México City https://thetinycto.com/blog/writing-a-game-using-chatgpt – Writing an Elixir LiveView game using ChatGPT https://thetinycto.com/gpt-game – The generated game https://chat.openai.com/chat – ChatGPT Do you have some Elixir news to share? Tell us at @ThinkingElixir or email at [email protected] Discussion Resources https://github.com/bitfo/timescale – Timescale and Elixir https://www.timescale.com/ https://docs.timescale.com/ https://www.bitfo.com/ https://defirate.com/ https://www.bitcoinprice.com/ https://ethereumprice.org/ https://docs.timescale.com/api/latest/hypertable/ – Hypertables https://docs.timescale.com/api/latest/hyperfunctions/ – Hyperfunctions https://codebeamamerica.com/talks/accessible-time-series-data-with-timescaledb/ https://fly.io/docs/postgres/managing/enabling-timescale/ https://www.whoop.com/ – Dave's biometric watch https://www.postgresql.org/docs/current/rules-materializedviews.html https://www.influxdata.com/ https://fly.io/docs/postgres/managing/enabling-timescale/ – Fly.io command to add timescale DB - fly pg config update --shared-preload-libraries timescaledb --app https://www.crunchydata.com/ https://docs.timescale.com/api/latest/hypertable/ https://docs.timescale.com/api/latest/hyperfunctions/ https://docs.timescale.com/timescaledb/latest/timescaledb-edition-comparison/ https://hexdocs.pm/timescale/intro.html https://www.milkroad.com/ https://docs.google.com/presentation/d/1c2gCxfigeQNz-Z32IaLrpdxt0JYwMc6Lam_vvUND31Y/edit?usp=sharing – Slides for Dave's Timescale talk from Code BEAM America https://hexdocs.pm/timescale/intro.html – Dave's “Intro to Timescale” Livebook from the Elixir Timescale docs Guest Information https://twitter.com/davydog187 – on Twitter https://github.com/davydog187/ – on Github https://davelucia.com/ – Blog Find us online Message the show - @ThinkingElixir Message the show on Mastadon - @[email protected] Email the show - [email protected] Mark Ericksen - @brainlid Mark Ericksen on Mastadon - @[email protected] David Bernheisel - @bernheisel David Bernheisel on Mastadon - @[email protected] Cade Ward - @cadebward Cade Ward on Mastadon - @[email protected] Sponsored By:Fly.io: Fly.io is a great place to deploy your next Phoenix application! Check them out!