SQLite for beginners: Full Text Search

Рет қаралды 7,500

Күн бұрын

SQLite has an extension called FTS5, which provides full text search capabilities to your SQLite database.
So, how do you use the full text search features in SQLite?
Watch this short video to learn more.
www.sqlite.org/fts5.html
mycelial.com/#newsletter
/ mycelial
github.com/mycelial
/ discord

Пікірлер: 20

@nickang6647 Жыл бұрын

This is an amazing tutorial - I particularly liked the series of questions and answers format. Thanks James!

@mohamedhurab5045 Ай бұрын

Thank you, Very helpful .

@joranmulderij 11 ай бұрын

Absolutely phenomenal series!

@MrThierriOliveira 8 ай бұрын

Very high quality content. Congrats!

@nodidog 2 ай бұрын

This is a fantastic explantation, thank you!

@eric0793 Жыл бұрын

Really helpful for a biginner, thank you!

@hitori_dev Жыл бұрын

Great video! Thanks

@atimney 2 ай бұрын

Great video, very well explained

@MVMaestro Жыл бұрын

Awesome video!

@abhaypatil9210 6 ай бұрын

Awesome. Just Awesome!!

@shadygoat9146 Жыл бұрын

It would be quite nice to have ether a github or a pastebin with the sql written in this video!

@antonioorsatti3270 11 ай бұрын

I was wondering, does that means the size of the db file is doubled?

@iMajed 9 ай бұрын

Thanks :)

@Promar22 Жыл бұрын

excellent video! I have some questions: Why do you have to perform a join operation between the virtual and original table if they are always set to be in sync after setting up the triggers? Could you not just query the virtual table directly? How does something like fts5 compare to lucene based search indexes? When would it make sense to use on over the other?

@klipronhoward Жыл бұрын

I think the reason for the join is if you want additional information about the movies that are found in the search. For example the year of the movie wouldn't be included in the full text search table so you would be able to select that from the original table.

@boot-strapper Жыл бұрын

im really wondering if you can have fts search across all tables. Like, in my case they are searching for d&d stuff, and wont necessarily know exactly what table to search. Would I want to make a table to has a relation to another table and a blob of text that is the search column?

@kishanbsh 5 ай бұрын

Does this MATCH do a fuzzy find ? How does the search work?

@Cong_Le Жыл бұрын

Thank you!

@baxiry. 3 ай бұрын

AWESOME!

@jonathanlarsson4608 Жыл бұрын

I have a problem with getting a search function to work in my js file: const sql = "SELECT Journal.title AS Journal_title, Article.a_id, Article.title AS Article_title, Article.i_id AS Article_i_id, Article.au_id AS Article_au_id, Issue.number (SELECT GROUP_CONCAT(Author.name, '; ') FROM Journal.title INNER JOIN Issue ON Issue.j_id=Journal.j_id INNER JOIN Article ON Article.title=Journal.title INNER JOIN Author ON Author.au_id=Article.au_id) ORDER BY Issue FROM Article WHERE Author.name LIKE '%" + q + "%'"; According to the command prompt, its a syntax error. What have I done wrong?