Rust: Diesel tutorial with Sqlite

[@Sheence]

The docs for getting started with SQLite using Diesel are... non existent. This is exactly what I was looking for. Thanks so much!

[@notker88]

Yes this crate is an absolute nightmare in regards to docu

[@majweezy]

bruv exacly what i was looking for good shit keep moving

[@codyziebko7713]

Oh man. I am a new programmer learning rust as my first language and this was so helpful! :DDD

[@CrazcalmsTechStack]

Nice! I wish you the best of luck on your journey!!!

[@sakitanaoto8681]

Nice video man keep up the good work! Rust community needs videos like this

[@ostapsulyk]

Siiiiirrrrr THANK YOU SO MUCH! I don't know what it is but you nailed to answer all the questions i had, and overall its a great video.

[@CrazcalmsTechStack]

Thanks!

[@danielceballos9617]

Gracias por tu apoyo a la comunidad amigo. ¡Me ayudaste mucho! Saludos desde México

[@jocketf3083]

This gives me a very good overview of what Diesel is like. Thank you!

[@rolandbjorn7982]

i know I'm kind of randomly asking but do anyone know of a good site to stream new series online?

[@musaamir1210]

@Roland Bjorn I would suggest Flixzone. Just google for it :)

[@nasirwillie2136]

@Musa Amir Yea, have been using FlixZone for years myself :)

[@rolandbjorn7982]

@Musa Amir Thanks, I went there and it seems to work =) I appreciate it !

[@musaamir1210]

@Roland Bjorn Happy to help =)

[@ajinkyax]

i really like the way you show how to read docs.rs and learn along :)

[@lol-kb8hz]

i like you a lot dude as a person you seem super nice and chill its fun listening to you much love and ofc i subbed

[@CrazcalmsTechStack]

Thanks!!!

[@lol-kb8hz]

@@CrazcalmsTechStack yw buddy im having a real rough time rn and ur vids really help man

[@0xhiro]

Man you are amazing. Love your videos.

[@Vancha112]

Thanks ^^ just halfway through this video! Will continue when I have more time. Looks like it will come in useful ^^

[@duncanmoiyo6069]

I've been trying to develop a desktop app using Tauri with an embedded sqlite db, but it's been challenging. With this tutorial, I guess I will be able to complete the app. Thanks

[@hashkeeper]

dude, rust sqlite tutorial, thank you. that's clutch

[@CrazcalmsTechStack]

No worries! I am glad you found it useful!

[@hashkeeper]

@@CrazcalmsTechStack ORM, that explained an almost existential worry for me! I was wondering how I'd handle that process on my own, seems daunting without the library! thanks again, youre helping me make strides

[@GernotPokorny]

lol. I haven't really looked into it, but it's good to know that it is here :D

[@joelmontesdeoca6572]

Awesome, thanks! I'm going to see if I open an issue with the Diesel project to translate the tutorial to all supported databases. 👍

[@CrazcalmsTechStack]

Thank you!!!

[@joelmontesdeoca6572]

@@CrazcalmsTechStack Yeah, no problem. Here's the issue if anyone else wants to chime in. (github.com/sgrif/diesel.rs-website/issues/130). I used your video to show some of the trouble spots of following the PostgreSQL guide when setting up an SQLite backend. By the way, the Diesel repository has the guide's code example done for SQLite: github.com/diesel-rs/diesel/tree/master/examples/sqlite

[@CrazcalmsTechStack]

Knowing that the source code is in the repo is a big find!!! Thanks again!

[@GernotPokorny]

No need to replace get_result, you can do the following: diesel = { version = "2.1.0", features = ["sqlite", "returning_clauses_for_sqlite_3_35"] }

[@CrazcalmsTechStack]

It looks like this feature was added well after i did the video. github.com/diesel-rs/diesel/commit/fda3410c1715a7cf57ae08f7969e297aa1762217 Thanks for adding the new way of doing things in a comment! I'm glad to see that SQLite support is improving ❤️

[@midwestmetro6361]

best teacher for me

[@CrazcalmsTechStack]

Thanks!

[@jafd7806]

Great tutorial bro. I suscribed to keep follow your videos

[@CrazcalmsTechStack]

Thanks!!!

[@Gubq]

Thank you, nice video!

[@jaydeepsharma9528]

I am having this error LINK : fatal error LNK1181: cannot open input file 'sqlite3.lib' can anyone help?

[@majweezy]

does he have a full tutorial on rust ? cause i could listen to him explain this all day

[@n.d.9796]

Thanks for the video!

[@valderamen4877]

Really great! I was fighting to use it with sqlite, until this video. Btw, which shell do u use? It looks nice

[@CrazcalmsTechStack]

Awwwww! Thanks!!! I use starship in my terminal. starship.rs/

[@m12652]

Seriously folks... learn to write sql and drop the orms, its not hard, you just have to learn it...

[@Sashin9000]

How did you make your terminal give you info on your project? Like how it says "Diesel Demo is..."

[@CrazcalmsTechStack]

I am using starship's default seetings for that. starship.rs/

[@Sashin9000]

@@CrazcalmsTechStack Thanks will check it out! Already using Oh My Zsh, I wonder if they are mutually exclusive.

[@GernotPokorny]

This whole crate is a total nightmare from a documentation perspektive... $ cargo install diesel_cli --no-default-features --features sqlite error: linking with `link.exe` failed: exit code: 1181 ... much text... = note: LINK : fatal error LNK1181: cannot open input file 'sqlite3.lib' error: could not compile `diesel_cli` due to previous error error: failed to compile `diesel_cli v2.1.0`, intermediate artifacts can be found at `C:\Users\pokor\AppData\Local\Temp\cargo-installMxm8vN`

[@047sriramn9]

you need to add the path c\programfiles\sqlite3\version\bin path in the environment variables

[@mhacnagbani]

Nth time I'm watching this as I keep forgetting and the docs are still the same. by the way you can also run `diesel setup --database-url ./data/sqlite.db` to directly provide DATABASE_URL and don't `dotenv` crate. And thanks a ton for the video.