Solving one of PostgreSQL's biggest weaknesses.

Опубликовано: 20 Август 2023
на канале: Dreams of Code
203,211
5.2k

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/s...

Join this channel to get access to perks:
   / @dreamsofcode  

My socials:
Discord:   / discord  
Twitter:   / 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/ti...
TimeScaleDB: https://www.timescale.com/?utm_source...

00:00 - Intro
00:56 - Timeseries Data
02:40 - Getting Started
07:33 - HyperTables
12:38 - Continuous Aggregates
16:39 - Results


Смотрите видео Solving one of PostgreSQL's biggest weaknesses. онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Dreams of Code 20 Август 2023, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 203,211 раз и оно понравилось 5.2 тысяч людям.