December 13, 2022

129: Time series data with Timescale DB

53 minutes

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]