Rust + SQLite: Complete Tutorial (Schema, CRUD, JSON & Async)

Learn how to use SQLite in your Rust Programming binary or library in just 30 minutes. This full walkthrough covers schema definition, CRUD operations, JSON/JSONB support, and async concurrency using the rusqlite library.

GitHub repo: https://github.com/jeremychone-channel/rust-xp-sqlite

- 00:00 Intro
- 00:26 Simple CRUD
- 06:12 Join
- 11:46 Dynamic Values
- 17:19 JSON
- 24:34 JSONB
- 28:07 ASYNC

GitHub repo: https://github.com/jeremychone-channel/rust-xp-sqlite

NOTE: For `cargo watch ..`, do `cargo install cargo-watch`. I sometimes use bacon, but I still like the simplicity of cargo watch.

Join this channel for early access to production coding videos and live streams:
https://www.youtube.com/channel/UCiT_r1GD7JSftnbViKHcOtQ/join

== Jeremy Chone:

- Join this channel - https://www.youtube.com/channel/UCiT_r1GD7JSftnbViKHcOtQ/join
- Member Only Videos - https://www.youtube.com/playlist?list=UUMOiT_r1GD7JSftnbViKHcOtQ

- Rust Production Coding with AI https://www.youtube.com/watch?v=zL1BzPVM8-Y&list=PL7r-PXl6ZPcB2zN0XHsYIDaD5yW8I40AE (using `pro@coder` and `pro@rust10x`)
- Check out AIPACK https://aipack.ai (Built with Rust) with the
- Video about AIPACK and Production Coding: https://news.aipack.ai/archive

- Twitter - https://twitter.com/jeremychone
- Discord general-rust - https://discord.gg/W2besKCzjx
- Discord genai & aipack - https://discord.gg/6KkpQBKGFS
- AIPACK - https://aipack.ai (and then 'aip install jc@coder')
- Rust10x - https://rust10x.com - Rust resources for production coding.
- Patreon - https://patreon.com/jeremychone - Any help is a big help (for Rust educational content)

Rust10x - Coding Resources for Production Coding in Rust. ➜ https://rust10x.com

=== 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)

Видео Rust + SQLite: Complete Tutorial (Schema, CRUD, JSON & Async) канала Jeremy Chone