Introduction to Timescale
Meet the Cast
HOST
David Flanagan
@rawkode
Stay ahead in cloud native
Tutorials, deep dives, and curated eventsβno fluff.
In this episode, we'll be covering everything you need to know to get started with Timescale.
πΏ Rawkode Live
Hosted by David McKay / π¦ https://twitter.com/rawkode
Website: https://rawkode.live
Discord Chat: https://rawkode.live/chat
#RawkodeLive
π° Timeline
00:00 - Holding screen
00:50 - Introductions
02:35 - What is Timescale? (Slides)
13:30 - Launching a cloud Timescale instance with Forge
19:00 - Installing psql and pgAdmin4
24:30 - Enabling the Timescale extension
25:30 - Connecting to Timescale with psql
30:10 - Importing the New York taxi data
59:00 - Querying our data
1:13:40 - Advanced demo of geospatial time series data with Grafana
π₯ About the Guests
Avthar Sewrathan
πΏπ¦ Born and raised in KwaZulu-Natal, South Africa
π π§² As a child, I loved science. I went on to represent South Africa at the International Physics Olympiad (IPhO) and International Junior Science Olympiad (IJSO)
π¨π· My life changed when I was 17: I moved across the world to live and learn with 150 other young, ambitious people from 70+ countries at United World College Costa Rica (UWC) without knowing a word of Spanish.
π― π I studied Computer Science at Princeton UniversityΒ
π» Current work: Developer Advocate at Timescale. I help developers be successful with time-series data for things like IoT, DevOps and Analytics.
π Previous work: From my college dorm room, I co-founded and built Afari a social network that gave people more privacy and ownership over their data. It was funded by a premier crypto fund.
π΄ Favorite football team: Manchester United
ββοΈ Favorite musician: The Weeknd
π Favorite country to visit: Thailand
π Favorite comedian: Trevor Noah
π½Current City: New York City
π¦ https://twitter.com/avthars
π§© https://github.com/avthars
π https://avthar.com/
π¨ About the Technologies
Timescale
TimescaleDB is an open-source database designed to make SQL scalable for
time-series data. It is engineered up from PostgreSQL and packaged as a
PostgreSQL extension, providing automatic partitioning across time and space
(partitioning key), as well as full SQL support.
π https://www.timescale.com/
π¦ https://twitter.com/timescaledb
π§© https://github.com/timescale/timescaledb
π Show Links
https://docs.timescale.com
https://tsdb.co/timescale-newsletter
https://tsdb.co/TimescaleSlack
https://tsdb.co/get-started-cloud
Related Videos
Fuck you, Hashicorp ... an IBM Company.
HashiCorp archived the repo without warning. Here is why their excuse about "product market fit" is a lie.
Replace Your GitHub Actions YAML with CUE
Are you tired of copy-pasting YAML between repositories only to be bitten by typos after pushing?
MinIO, we won't miss you.
MinIO just announced maintenance mode for their community edition β and honestly? Good riddance.
Relaunching Klustered ... with Heroku Vibes
Building and Launching a Marketing Page on Heroku with AI in Under 20 Minutes
Comments