Uploaded April 2025 | Updated September 2026, 17 hours ago
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: 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: 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:
youtube.com/channel/UCiT_r1GD7JSftnbViKHcOtQ/join
== Jeremy Chone:
- Join this channel - youtube.com/channel/UCiT_r1GD7JSftnbViKHcOtQ/join
- Member Only Videos - youtube.com/playlist?list=UUMOiT_r1GD7JSftnbViKHcOtQ
- Rust Production Coding with AI youtube.com/watch?v=zL1BzPVM8-Y&list=PL7r-PXl6ZPcB2zN0XHsYIDaD5yW8I40AE (using `pro@coder` and `pro@rust10x`)
- Check out AIPACK aipack.ai (Built with Rust) with the
- Video about AIPACK and Production Coding: news.aipack.ai/archive
- Twitter - twitter.com/jeremychone
- Discord general-rust - discord.gg/W2besKCzjx
- Discord genai & aipack - discord.gg/6KkpQBKGFS
- AIPACK - aipack.ai (and then 'aip install jc@coder')
- Rust10x - rust10x.com - Rust resources for production coding.
- Patreon - patreon.com/jeremychone - Any help is a big help (for Rust educational content)
Rust10x - Coding Resources for Production Coding in Rust. ➜ 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)
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: 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: 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:
youtube.com/channel/UCiT_r1GD7JSftnbViKHcOtQ/join
== Jeremy Chone:
- Join this channel - youtube.com/channel/UCiT_r1GD7JSftnbViKHcOtQ/join
- Member Only Videos - youtube.com/playlist?list=UUMOiT_r1GD7JSftnbViKHcOtQ
- Rust Production Coding with AI youtube.com/watch?v=zL1BzPVM8-Y&list=PL7r-PXl6ZPcB2zN0XHsYIDaD5yW8I40AE (using `pro@coder` and `pro@rust10x`)
- Check out AIPACK aipack.ai (Built with Rust) with the
- Video about AIPACK and Production Coding: news.aipack.ai/archive
- Twitter - twitter.com/jeremychone
- Discord general-rust - discord.gg/W2besKCzjx
- Discord genai & aipack - discord.gg/6KkpQBKGFS
- AIPACK - aipack.ai (and then 'aip install jc@coder')
- Rust10x - rust10x.com - Rust resources for production coding.
- Patreon - patreon.com/jeremychone - Any help is a big help (for Rust educational content)
Rust10x - Coding Resources for Production Coding in Rust. ➜ 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)
