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
https://adventofcode.com/ – Advent of Code is going onhttps://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 Codehttps://github.com/josevalim/livebooks/ – José Valim's collection of shared public Livebookshttps://github.com/rosaan/advent-of-code-2022 – Some shared solutionshttps://twitter.com/josevalim/status/1597880468032040960 – Explorer v0.4.0 is outhttps://hexdocs.pm/explorer/0.4.0https://hexdocs.pm/explorer/0.4.0/Explorer.Query.html – Explorer.Query is a new API for writing expressive and performant querieshttps://podcast.thinkingelixir.com/104 – Chris Grainger talked about Explorer with us in episode 104https://tips.nerves-project.org/ – Nerves website gets a new “tips” viewhttps://twitter.com/josevalim/status/1597943279164993537 – José Valim announced he was migrating to the genserver.social Mastadon serverhttps://genserver.social/josevalim – José's genserver.social profilehttps://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 teasedhttp://codebeammexico.com/ – Code BEAM Lite México, March 3-4 2023 in México Cityhttps://thetinycto.com/blog/writing-a-game-using-chatgpt – Writing an Elixir LiveView game using ChatGPThttps://thetinycto.com/gpt-game – The generated gamehttps://chat.openai.com/chat – ChatGPTDo you have some Elixir news to share? Tell us at @ThinkingElixir or email at [email protected]
https://github.com/bitfo/timescale – Timescale and Elixirhttps://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/ – Hypertableshttps://docs.timescale.com/api/latest/hyperfunctions/ – Hyperfunctionshttps://codebeamamerica.com/talks/accessible-time-series-data-with-timescaledb/https://fly.io/docs/postgres/managing/enabling-timescale/https://www.whoop.com/ – Dave's biometric watchhttps://www.postgresql.org/docs/current/rules-materializedviews.htmlhttps://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.htmlhttps://www.milkroad.com/https://docs.google.com/presentation/d/1c2gCxfigeQNz-Z32IaLrpdxt0JYwMc6Lam_vvUND31Y/edit?usp=sharing – Slides for Dave's Timescale talk from Code BEAM Americahttps://hexdocs.pm/timescale/intro.html – Dave's “Intro to Timescale” Livebook from the Elixir Timescale docshttps://twitter.com/davydog187 – on Twitterhttps://github.com/davydog187/ – on Githubhttps://davelucia.com/ – BlogMessage the show - @ThinkingElixirMessage the show on Mastadon - @[email protected]Email the show - [email protected]Mark Ericksen - @brainlidMark Ericksen on Mastadon - @[email protected]David Bernheisel - @bernheiselDavid Bernheisel on Mastadon - @[email protected]Cade Ward - @cadebwardCade Ward on Mastadon - @[email protected]Sponsored By:
- Fly.io: Fly.io is a great place to deploy your next Phoenix application! Check them out!