Rust + Next-Gen SQL Databases = 😍

We look at distributed databases CockroachDB and YugabyteDB and how to integrate with them in a Rust application using the SQLx crate. Also a discussion about how they compare to PostgreSQL and AWS DynamoDB.

[dreamsofcode]

Excellent video, dude. I'm excited to try both of these out!

[cockroachdb]

What an excellent video! We’re delighted to see that you had such a great experience with CockroachDB.

[NotherPleb]

This is really nice, you can start with vanilla postgres and scale it later if needed with these!

[nicomiebach]

When making your selection, pay close attention to which features you want to use. Neither of them have 100% feature parity of Standard Postgres. YugabyteDB tends to have more feature parity. CockroachDB, for example, does not support triggers.

[fdmk]

Oracle had Flashback as it's Time Travel functionality for ages. So it isn't a groundbreakingly new feature. But it is nice to see other DBs implementing something similar.

[thebutlah]

CrockroachDB is not open source, so if all else is equal, id pick the FOSS one

[virusblitz]

the way you present information is just perfect! i love learning from your videos and they're easy to follow

[ishaanmalhotra]

Thanks for this video. Would love to see a review on Neon DB as well!

[bitfluent]

I've been looking into Postgres with Citus as a way to get scalable Postgres, even in self-hosted environments. Might be a good video idea, if you have the fortitude to set it up!

[RootsterAnon]

Very good video! SurrealDB is on my radar for some time and I would like to make real project using it.

[conceptsound]

Whats the app for the sql schema drawings

[martinbecker]

Would you please do a Video on ORMs? I'm currently trying to use Ormlite but now I'm wondering if it's actually usable at the moment and should switch to SeaORM

[edgeeffect]

I like a comparison between these databases and the mariaDB cluster at my old job.

[willi]

neon is an other postgres db that i am rooting for

[hi_im_julian_kirsch]

TIL I learned, I don't need to load the UUID extension explicitly in recent versions of PG :D

[veetaha]

Isn't the usage of the raw functions `sqlx::query/sqlx::query_as` discouraged? The primary usage pattern of `sqlx` is via macros that validate SQL at compile time, and they also make sure all types match. Do I understand that you use raw functions here because macros just don't support these next-gen SQL DBs?

UPD, aha, you used the macro syntax for INSERT, but didn't do that for SELECT. Anyway, I thought macro syntax isn't supported with the next-gen SQL DBs

[mgs...]

For basic queries and simple DB designs, SQLx create works quite nice. But if you need performant or more complex queries, then I would look else where.
There are issues with enums, flattening, prefixes, types serialization, performance ... not to mention each new version brakes code and CLI (expected, but annoying).

[alisterlee]

Topical! I'm trialling Yugabyte for a side-project which I leant towards because of its slightly more openness and the neat tablespace location tricks. I'd like to use sqlx but I'm struggling to use the cluster-aware yugabyte drivers with it. Always-on SPA's called from serverless functions backed by such global databases should be within reach soon with this stack.

[recursion.]

onlyfans model be watching bros videos

[egm]

hey bro I am very noob at Rust and also with strong typed languages, can you make a series of videos for this kind of guys that come from a javascript background and want to start coding on Rust? thanks for the video!