SQLite For Beginners: Indexes, beyond the basics

If you want to level up your database skills, the area you should probably focus on first is Indexes.
So, are you familiar with the various types of indexes you can create?
Check out this video to learn more.
mycelial.com/#...
/ mycelial
github.com/myc...
/ discord

[@joeljuca]

Amazing content! Thank you for recording and sharing. In regard to non-sensitive queries, SQLite has case-insensitivate collates to be used for this purpose: create table variables (key text collate nocase, value);

[@brunoseys6705]

Going through this series of videos I am picking up interesting SQLITE stuff and knowledge. Thanks for that and keep it up.

[@joao.penteado]

Very good content and presentation as usual! Please keep it up 👍

[@dannydevelops]

Only a minute in but this is so well presented and useful. Thank you

[@ahmelq]

This is gold content. Thanks for sharing.

[@jakobhec]

Great explanation, thanks a lot!

[@thedelanyo]

Great. If your db keeps updating frequently, creating covering index, might not be efficient? Right

[@oussamasethoum1665]

very good content thank you

[@paulcosta8297]

INDICES