Django and HTMX #9 - Database Query Optimization with django-debug-toolbar

[@laszlo.laszlo]

Brilliant! From 305 queries to 6 :-) Great!

[@sudoscientist255]

This is my favorite playlist on KZbin for Django dev. Thank you for the great content and keep up the good work! :)

[@bugbytes3923]

Thank you very much, that means a lot! Glad you are enjoying the content. :)

[@defidelity]

This is actually the best Video in this series, why I'm I not even aware of any of these. Thanks for this amazing series.

[@bugbytes3923]

Thanks man! I appreciate the comment. 🙂

[@defidelity]

@@bugbytes3923 please something that has to do with click to edit next. Thanks

[@AyazAmlani]

wow. thanks dude. I was not aware of the bulk_update function or the n+1 problem. This is so useful!

[@bugbytes3923]

Glad to hear it dude, thank you for watching 🙏

[@MrValVet]

This is awesome. I hope we see more Django query optimization tutorials in the future.

[@bugbytes3923]

Thanks a lot! I did a further video on this in the Django ORM playlist: kzbin.info/www/bejne/l2THhaxuh7RoftE

[@Peterstavrou]

This was excellent! No one really teaches this so thank you for running through it. I'm also loving this playlist so far, one of my favorites! I spent so much time learning JavaScript and Vue.js when I could have simply learnt htmx to do the same thing so much quicker and easier!

[@bugbytes3923]

Thanks Peter! I'm glad you're enjoying the playlist :) And agreed - HTMX solves most requirements for dynamic web pages. Great time-saver for most folks!

[@fhmisml]

i'm glad found this channel from django ninja docs. As a beginner, your contents are really helpful for me, thankyou.. you deserve more sub, keep it up!

[@bugbytes3923]

Thank you! I'm glad you are enjoying.

[@Crunchy409]

You have been an invaluable resource in my adventure into Django land. Thank you so much for your time and efforts with this playlist!

[@bugbytes3923]

Thanks a lot, I'm glad to hear that! Thanks for watching!

[@mayconblopes_]

Oh my, this was a real lesson. Learning a lot with you

[@bugbytes3923]

Glad it's useful, thank you!

[@eimantasnejus390]

Laughed more than necessary at "2 hours later" :D Awesome series!

[@bugbytes3923]

haha thanks!

[@brablc]

There should be a warning at the start of the series, that n+1 and bulk update problems will be solved later ;-) Being a curious person, I had to learn about the Debug Toolbar earlier, because I wanted to see what SQL statements get generated. It would take me much less time after seeing this episode. I wonder if I will learn about Faker (needed in previous lesson).

[@esma3el5551]

this is very informative content , good job man

[@bugbytes3923]

Thank you Ismail! I'm glad you're enjoying :)

[@viniciusstucki]

Very nice content and aplications uses! Stay up with the good work. Thank you for sharing your experience. From Brazil =D

[@bugbytes3923]

Thank you!

[@chazzwhu]

Loving this series, been keen to implement more htmx with django. Will you be doing the independent dropdown? Thanks!

[@bugbytes3923]

Thanks for the comment! I'll be trying to do a few more HTMX videos, and I'll try and have a look into that one.

[@helixaros]

hi there, do you have any advice on implementing nested sortable list ?

[@aafan.kuware]

you are extremely great in Django, I wish I could do the same😊

[@bugbytes3923]

Thanks for the nice comment!

[@owenjones9640]

Really enjoying this series, liking htmx more and more as I discover it. I was wondering if you could do a bit in the next episode where you show how to fix the list with pagination when going back from film details/dragging and dropping to reorder. I've been playing around with it a bit trying to get it to work properly, but it's still kind of borked.

[@bugbytes3923]

Hey Owen, thanks for the comment. I might try and do a video (or part of a video) fixing this. I think I will also do videos where I build a proper app from the ground up, using Django/HTMX, in the near future too. This film app was kind of a throwaway example that's evolved into a way of showing off HTMX features, but I'd like to do something more coherent too, if there's any interest in that. (hope that makes sense!)

[@lexe11]

I love the series, thank you very much! There's one line of code I can't put in my head properly: page_number = len(film_pks_order) / settings.PAGINATE_BY This line is in the pagination section of a sort function in a films app. It would be great if you could answer what we count here an why. Thanks.

[@blabla-kk8bl]

Hi mate so good content, how about safety crf tokens? Is this htmx safe to use? I am confused.

[@LegionLeague]

Have been following the series. Seems like still sort doesn't work well with infinite scrolling. I still get numbers all mixed up when I infinite-scroll down after some draging and dropping. I wonder if it's just me or anyone else has had this issue.

[@justacasualdeveloper]

Noice 😁

[@bugbytes3923]

Thanks!

[@tylersen3318]

I was really enjoying your videos, so I decided that I wanted to give HTMX a try. I cloned your files for video #9 and tried to install the dependencies, but these older versions failed to install... when I installed the new versions of the dependencies, there were numerous bugs in the code. Adding a movie displays the same movie twice in the browser, even though only one record exists in the database. Deleting the movie clones the input forms and places them to the right. Very strange. It might be time to update this tutorial.

[@alnuaimi230]

What about Unpoly js ?!

[@TheGunnarRoxen]

"2 hours later" 😂