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 [email protected] (mailto:[email protected])
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 - @[email protected] (https://genserver.social/ThinkingElixir)
- Email the show - [email protected] (mailto:[email protected])
- Mark Ericksen - @brainlid (https://twitter.com/brainlid)
- Mark Ericksen on Mastadon - @[email protected] (https://genserver.social/brainlid)
- David Bernheisel - @bernheisel (https://twitter.com/bernheisel)
- David Bernheisel on Mastadon - @[email protected] (https://genserver.social/dbern)
- Cade Ward - @cadebward (https://twitter.com/cadebward)
- Cade Ward on Mastadon - @[email protected] (https://genserver.social/cadebward)

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: