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 (http://podcast.thinkingelixir.com/129)
Elixir Community News
- https://adventofcode.com/ (https://adventofcode.com/) – Advent of Code is going on
- https://gist.github.com/marpo60/bcf7dd45003adfe01b5581d03157a5de (https://gist.github.com/marpo60/bcf7dd45003adfe01b5581d03157a5de) – Marcelo Dominguez' Livebook template for working on the daily problems.
- https://genserver.social/notice/AQAdGQAE5sgRL8x1g8 (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/ (https://github.com/josevalim/livebooks/) – José Valim's collection of shared public Livebooks
- https://github.com/rosaan/advent-of-code-2022 (https://github.com/rosaan/advent-of-code-2022) – Some shared solutions
- https://twitter.com/josevalim/status/1597880468032040960 (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)
- https://hexdocs.pm/explorer/0.4.0/Explorer.Query.html (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 (https://podcast.thinkingelixir.com/104) – Chris Grainger talked about Explorer with us in episode 104
- https://tips.nerves-project.org/ (https://tips.nerves-project.org/) – Nerves website gets a new “tips” view
- https://twitter.com/josevalim/status/1597943279164993537 (https://twitter.com/josevalim/status/1597943279164993537) – José Valim announced he was migrating to the genserver.social Mastadon server
- https://genserver.social/josevalim (https://genserver.social/josevalim) – José's genserver.social profile
- https://genserver.social/notice/AQIfjB7SQcuEwPGEAC (https://genserver.social/notice/AQIfjB7SQcuEwPGEAC) – José teased something "really big". Already released by the time you hear this.
- https://genserver.social/notice/AQIlH84yjkrh856rS4 (https://genserver.social/notice/AQIlH84yjkrh856rS4) – The graphic he teased
- http://codebeammexico.com/ (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 (https://thetinycto.com/blog/writing-a-game-using-chatgpt) – Writing an Elixir LiveView game using ChatGPT
- https://thetinycto.com/gpt-game (https://thetinycto.com/gpt-game) – The generated game
- https://chat.openai.com/chat (https://chat.openai.com/chat) – ChatGPT
Do you have some Elixir news to share? Tell us at @ThinkingElixir (https://twitter.com/ThinkingElixir) or email at show@thinkingelixir.com (mailto:show@thinkingelixir.com)
Discussion Resources
- https://github.com/bitfo/timescale (https://github.com/bitfo/timescale) – Timescale and Elixir
- https://www.timescale.com/ (https://www.timescale.com/)
- https://docs.timescale.com/ (https://docs.timescale.com/)
- https://www.bitfo.com/ (https://www.bitfo.com/)
- https://defirate.com/ (https://defirate.com/)
- https://www.bitcoinprice.com/ (https://www.bitcoinprice.com/)
- https://ethereumprice.org/ (https://ethereumprice.org/)
- https://docs.timescale.com/api/latest/hypertable/ (https://docs.timescale.com/api/latest/hypertable/) – Hypertables
- https://docs.timescale.com/api/latest/hyperfunctions/ (https://docs.timescale.com/api/latest/hyperfunctions/) – Hyperfunctions
- https://codebeamamerica.com/talks/accessible-time-series-data-with-timescaledb/ (https://codebeamamerica.com/talks/accessible-time-series-data-with-timescaledb/)
- https://fly.io/docs/postgres/managing/enabling-timescale/ (https://fly.io/docs/postgres/managing/enabling-timescale/)
- https://www.whoop.com/ (https://www.whoop.com/) – Dave's biometric watch
- https://www.postgresql.org/docs/current/rules-materializedviews.html (https://www.postgresql.org/docs/current/rules-materializedviews.html)
- https://www.influxdata.com/ (https://www.influxdata.com/)
- https://fly.io/docs/postgres/managing/enabling-timescale/ (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://www.crunchydata.com/)
- https://docs.timescale.com/api/latest/hypertable/ (https://docs.timescale.com/api/latest/hypertable/)
- https://docs.timescale.com/api/latest/hyperfunctions/ (https://docs.timescale.com/api/latest/hyperfunctions/)
- https://docs.timescale.com/timescaledb/latest/timescaledb-edition-comparison/ (https://docs.timescale.com/timescaledb/latest/timescaledb-edition-comparison/)
- https://hexdocs.pm/timescale/intro.html (https://hexdocs.pm/timescale/intro.html)
- https://www.milkroad.com/ (https://www.milkroad.com/)
- https://docs.google.com/presentation/d/1c2gCxfigeQNz-Z32IaLrpdxt0JYwMc6Lam_vvUND31Y/edit?usp=sharing (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 (https://hexdocs.pm/timescale/intro.html) – Dave's “Intro to Timescale” Livebook from the Elixir Timescale docs
Guest Information
- https://twitter.com/davydog187 (https://twitter.com/davydog187) – on Twitter
- https://github.com/davydog187/ (https://github.com/davydog187/) – on Github
- https://davelucia.com/ (https://davelucia.com/) – Blog
Find us online
- Message the show - @ThinkingElixir (https://twitter.com/ThinkingElixir)
- Message the show on Mastadon - @ThinkingElixir@genserver.social (https://genserver.social/ThinkingElixir)
- Email the show - show@thinkingelixir.com (mailto:show@thinkingelixir.com)
- Mark Ericksen - @brainlid (https://twitter.com/brainlid)
- Mark Ericksen on Mastadon - @brainlid@genserver.social (https://genserver.social/brainlid)
- David Bernheisel - @bernheisel (https://twitter.com/bernheisel)
- David Bernheisel on Mastadon - @dbern@genserver.social (https://genserver.social/dbern)
- Cade Ward - @cadebward (https://twitter.com/cadebward)
- Cade Ward on Mastadon - @cadebward@genserver.social (https://genserver.social/cadebward)