Rust Sea-Query + SQLX + ModQL (E02 - Production Web-App)

Rust Programming - Production Coding Series - Episode 02 - SEA-QUERY SQL BUILDER + MODQL for "MongoDB query like."

Second episode of the Rust Production Coding for Web Applications series will focus on upgrading our code to Rust sea-query, a powerful SQL Builder library that supports multiple drivers and databases (PostgreSQL, MySQL, and SQLite).

We will also utilize the MODQL library to enable a potent, composable filters query API for our JSON-RPC layer. This will gradually become protocol independent, adding even more versatility to the code for various types of applications (e.g., web applications, job/message-based services, desktop commands like Tauri commands).

- 00:00 - Intro
- 00:48 - Intro Advanced Filter
- 01:55 - Code/Git structure
- 03:17 - Chapter 1 - sqlb/sqlx -to- sea-query/modql
- 21:57 - Chapter 2 - modql & filters
- 40:33 - Chapter 3 - RPC ListParams and filter demo (quick_dev)

This episode marks a major milestone for the Rust10x Web App blueprint. In the next episode, we will enhance our RPC Routing code with a fully-fledged dynamic RPC Routing system using the "Dyn Handler" pattern, employed by frameworks like Axum and Bevy.

GitHub checkout E02-START:

cd rust-web-app
git checkout -b my_e02 tags/E02-START

Jeremy Chone:

Other popular Rust Programming videos:

Playlists:

Other notes:

- ScreenBrush for the green lines. (Gromit seems to be the equivalent on Linux)
- Sketchapp for some graphics.
- Davinci Resolve and Fusion video editing.
- VSCode with Google Material icon themes (with some customization)

[camorimd]

Clear, concise, straight to the point but with all details needed. Bravo! Et merci beacoup.

[gabrielcournelle]

Thanks once again for this great in depth and easy to follow tutorial.

[ChetanBhasin]

Just found your channel, and this is amazing content! Thank you so much for sharing!

[prashlovessamosa]

Great idk why I didn't get notification.
Glad I checked 😢it.

[zedryas]

Hello, I can't find the episode 1 of the serie - is it the "Rust Axum Production Coding - Rust Web Development" ?

[jaymartinez]

Can you please provide the link to the first video? Thank you for the content 🤲🏾

[bichkhebk]

What tool did you use to record and edit wonderful video?

[吴百川]

Thanks for the great content! i have some trouble when use mysql decimal, it seems modql not impl Decimal

[DESCARTINPHILLIPLANCEB]

I have been watching this video again and again, and I hope you noticed my question. The question is how to add more table references to the UserBmc. It's optional whether I will use the other table or not.