Giải quyết một trong những điểm yếu lớn nhất của PostgreSQL.

Storing large amounts of data, such as time series data, in a single table is often a challenge when it comes to PostgreSQL. There are other databases out there that can be used for timeseries, however, it does mean giving up many of the features that makes postgres so desirable.

Fortunately, there is another option. TimeScaleDB is a postgres extension that is optimized for time series data. In this video, we provide a brief introduction into TimeScale DB and put it to the test.

This video was sponsored by TimeScaleDB. If you're looking to use a time series database for your own needs, then I highly recommend TimeScale, you can get set up with a free trial using the link below.

https://console.cloud.timescale.com/signup/?utm_source=dreams-of-code&utm_medium=youtube&utm_campaign=kol-q3-2023&utm_content=signup

Join this channel to get access to perks:

https://www.youtube.com/channel/UCWQaM7SpSECp9FELz-cHzuQ/join

My socials:

Discord: https://discord.com/invite/eMjRTvscyt

Twitter: https://twitter.com/dreamsofcode_io

My Equipment:

Voice over: https://kit.co/dreamsofcode/voiceover

Coding: https://kit.co/dreamsofcode/coding

Video Links:

Github Repo: https://github.com/dreamsofcode-io/timescaledb-taxidata

TimeScaleDB: https://www.timescale.com/?utm_source=dreams-of-code&utm_medium=youtube&utm_campaign=kol-q3-2023&utm_content=homepage

00:00 - Intro

00:56 - Timeseries Data

02:40 - Getting Started

07:33 - HyperTables

12:38 - Continuous Aggregates

16:39 - Results