TimescaleDB in 100 Seconds

#programming #database #100secondsofcode

💬 Chat with Me on Discord

🔗 Resources

🔥 Get More Content - Upgrade to PRO

Use code YT25 for 25% off PRO access

🎨 My Editor Settings

- Atom One Dark
- vscode-icons
- Fira Code Font

🔖 Topics Covered

- What is TimescaleDB?
- TimescaleDB basics tutorial
- Timescale vs Postgres
- Postgres as a vector database
- Postgres extensions for RAG stack and AI apps
- How to make SQL queries faster

[Thiccolo]

These ads have been getting creative I see

[zyncc]

Now I can put timescale db in my resume

[attiquerehman]

reminds of the comment "there is video in your ad"

[shinichido]

We are hiring!

Requirement:
•10+ years experience with TimescaleDB

[danthepyroman]

I’m a fan of you getting bread and the channel in general. Sponsorships need to be disclosed in the beginning and in the description and title

[NicolasPL_]

Honestly, not a fan of sponsored "in 100 seconds" videos because it seems like it inhibits you from making your usual jokes which is what gave this channel its personality and why I'm subscribed in the first place.

[rida_brahim]

Once you see this as an ad you can't unsee it.

[thegiverion]

Been using TimescaleDB for about a year now, no complains, work as charm!

[WolfPhoenix]

So these 100-second videos are now becoming ads themselves? Fireship has truly embraced his inner AI persona. 😂

[alexandroslekkas]

I coincidentally started using TimescaleDB after I had watched this video and I came back as I was trying to remember where I had heard someone talking about it before. Good sponsorship.

[troglodytto]

1:07 They actually changed the graphic LoL

[voxvolhynia]

Finally, an ad that I can watch when I'm in the mood for the subject, with a soothing voice and creative humor as always, on a topic that's at least to me (okay maybe not THIS topic in particular, but most Fireship ones!). Keep it up!

[shadowspyes]

1. timescale devs can't be bothered keeping documentation up to date for usecases outside of their "timescale" cloud option. one example is simple backup/restore using pg_dump -> pg_restore breaks on hypertables with default behaviour without any information documenting how to fix this properly. Their pg_dump/pg_restore documentation just says it is supported. There is a relatively simple fix, but no mention of it whatsoever in their documentation. They don't do anything about this because problems like this serve as reasons for using their timescale service.

2. the main selling points of timescaledb for most usecases are automatic partitioning and compression of chunks. automatic partitioning can be done somewhat easily in regular postgres, but the easiest way is to use external scripts/cron jobs for this. timescaledb helps put everything in one place. As for compression, it's not trivial to get in regular postgres.

3. regular postgres is only slow compared to hypertables if you suck at partitioning and indexing. hypertables do nothing differently when it comes to query performance on non-compressed tables.

[krtirtho]

Just like react is the solution to everything in frontend, Postgres is the solution to everything in the backend

[Steelrat]

So, this is interval-based parititioning brought to the next level. Love it.

[kamilgregorczyk]

The best thing about timescaledb is that it's a postgres extension, you can add it to any postgresql db where you can install extensions. No need for yet another cloud account.

[adityavardhanjain]

IOT Smart Toilet is actually a good project if you take it seriously.

[sierragutenberg]

Thanks for getting me to update my resumee!

[rubberbandpromax]

any new groundbreaking javascript framework launched or not this month?

[watchoutharry]

Got it! putting timescale DB 4 yr experience in my resume 😄