QuestDB 🛡️ The Time Traveler's Database (Open Source)

A concise introduction to QuestDB and how it can make working with time series data so much easier and less costly. Includes ingesting data using the official QuestDB Rust crate.

---

[ScottKohlmann]

Thanks! This video saved our company a lot of time!

[jimmangefrida]

Postgres query: select date_trunc('month', time), avg(PriceUSD) from btc group by 1. To be clear, QuestDB looks interesting and I can see some advantages to it, but I don't think you were being fair to Postgres.

[nikensss]

omg! port is over 9000! (6.28)

Aside from that, excellent video, looks pretty interesting

[narwodev]

I really like the way you present your videos, the reviews are great, but I'd like to see more tutorials on learning and using rust. Maybe a series on developing an actual app that uses state machines, threads/async etc. Giving details about the rust way of doing those things.

[StevenHodder]

Super useful - dealing with time series data is always a pain.

[logeshkumarrajkumar]

Very useful. Thank you. Do you think questsb is a good choice to store and retrieve social media analytics like impressions, engagements etc? Also can I use it as a replacement for a traditional relational database as well?

[TobiasFrei]

Certainly a great video, and the first time I hear about QuestDB. Now as a Postgres fan I have to look up/experiment how QuestDB compares to TimescaleDB (which I didn't touch in a while). 🤓

[kwako]

This was very informative. Great video!

[qmster]

1. How does it compare and contrast with InfluxDB?
2. What does the wire format of submitting data look like?

[seannewell]

Pretty cool! Any more typesage SDKs for QuestDB in rust or other langs (ts?) cause i really like diesel/sqlx/prisma/drizzle

[rajbiswas]

As a MongoDB fan, I would absolutely love to test it against Mongo now that MongoDB has write and read optimised TS collections.

[gamcd]

The keyboard sounds nice, is it a custom?

[mogest]

Ever since PostgreSQL 14 you've been able to do this:

SELECT date_bin('30 days', time, '2000-01-01'), avg("PriceUSD") FROM btc GROUP BY 1

Or to group on months, instead of 30 days, it's even easier:

SELECT date_trunc('month', time), avg("PriceUSD") FROM btc GROUP BY 1

There are other benefits of time series databases, but PostgreSQL is pretty great!

[Zzznmop]

Oh so I should’ve used a DB to analyze my perf test with millions of timestamped rows?
I think this video (and excel crashing) are the push I needed to actually dive into databases below surface level

[mhmdkzr]

How would you compare it to TimescaleDB?

[AlbertCloete]

Is the time series database also a lot faster with 'sample by' queries, or is it just that the query is easier to write?

[alandto]

i would love a video ccomparing surrealDB and questDB

[forrestbajbek]

Couldn't you just use `SELECT time, AVG(PriceUSD) OVER (RANGE BETWEEN INTERVAL 30 DAY PRECEDING AND CURRENT ROW)` in Postgres? Not discounting how concise the QuestDB syntax is. Will definitely check this out.

[oneito]

how much different is this from also new surrealdb

[vzuzukin]

What is the most beginner-friendly database for a new developer for a small project? Would it be MongoDB or a similar document store?