SQLite For Beginners: Indexes, beyond the basics

preview_player
Показать описание
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.

  1. Mycelial
Рекомендации по теме
SQLite For Beginners: 0:09:32

SQLite For Beginners: Indexes, beyond the basics

SQLite For Beginners: 0:04:23

SQLite For Beginners: Statistics: Clustered Index & WITHOUT ROWID optimization.

SQL - SQLite 0:06:37

SQL - SQLite index

SQLite for beginners: 0:10:10

SQLite for beginners: Fixing Slow Queries

SQLite for beginners: 0:10:04

SQLite for beginners: Full Text Search

SQLite For Beginners: 0:16:06

SQLite For Beginners: Journal Modes

SQLite Tutorial Part 0:10:53

SQLite Tutorial Part 9 - INDEX

How To use 0:07:48

How To use SQLite Index And Explain Query Plan Command On Ubuntu Linux

SQLite for Beginners: 0:07:01

SQLite for Beginners: Dates

SQLite for beginners: 0:08:38

SQLite for beginners: Datatypes

SQLite for beginners: 0:06:16

SQLite for beginners: extensions

Sqlite indexes and 0:12:14

Sqlite indexes and query plan analysis

SQLite for beginners: 0:06:44

SQLite for beginners: JSON

Distributed Fractional Indexing 0:08:07

Distributed Fractional Indexing in SQLite

SQLite for beginners: 0:08:52

SQLite for beginners: Vacuuming

Vector databases are 0:03:22

Vector databases are so hot right now. WTF are they?

Partial Indexes - 0:05:09

Partial Indexes - only index the data that needs it

SQLite Tutorial Part 0:19:46

SQLite Tutorial Part 11 - UNIQUE INDEX

SQLite For Beginners: 0:06:06

SQLite For Beginners: Statistics

SQL : SQLite 0:01:37

SQL : SQLite - Create and index for every field

Day 38: Indexing 0:00:57

Day 38: Indexing Databases with SQLite & Python - #shorts #365daysofml

SQLite for Beginners: 0:08:43

SQLite for Beginners: Database Backups

Tutorial SQLite 2023 0:18:12

Tutorial SQLite 2023 N° 44 - Índice

15 futuristic databases 0:08:42

15 futuristic databases you’ve never heard of

Комментарии
Автор

This is gold content. Thanks for sharing.

ahmelq
Автор

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

joao.penteado
Автор

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

joeljuca
Автор

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

brunoseys
Автор

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

dannydevelops
Автор

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

thedelanyo