22 min listen
129: Time series data with Timescale DB
ratings:
Length:
54 minutes
Released:
Dec 13, 2022
Format:
Podcast episode
Description
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
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
Released:
Dec 13, 2022
Format:
Podcast episode
Titles in the series (100)
19: Elixir and Art with Milada Majáková: We cover the news then talk with Milada Majáková about combining Elixir and art. Milada came new to Elixir from Architecture and Graphic Design. We reject the idea that people are either logical or artistic but not both. She shares her journey, by Thinking Elixir Podcast