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
Kubernetes Disaster Recovery
Flatcar Linux: A Modern OS for the Always-On Infrastructure
Platform Engineering: Asking "Why"? with Evelyn Osman
βToday we had some long conversations about Arc Bash and the future of scripting as well as platforms and the rise and fall of Kubernetes.
Hands-on with Headlamp: The Kubernetes UI
Join us as we explore Headlamp β an extensible, user-friendly Kubernetes UI. Weβll walk through installing, configuring, customizing, and using it in real time.
Comments