SQLite for beginners: Full Text Search

[@nickang6647]

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

[@cincoer]

is it really tho?

[@MrThierriOliveira]

Very high quality content. Congrats!

[@cincoer]

r u sur about that?

[@joranmulderij]

Absolutely phenomenal series!

[@sinanerbezci3699]

Amazing tutorial. thank you

[@StanleyStephen]

Oh just what I was looking for!

[@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.

[@nodidog]

This is a fantastic explantation, thank you!

[@cincoer]

i dont think so

[@eric0793]

Really helpful for a biginner, thank you!

[@shadygoat9146]

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

[@antonioorsatti3270]

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

[@atxorsatti]

i think even more.

[@atimney]

Great video, very well explained

[@DrJayTap]

This helped a ton--thank you!

[@PankajDoharey]

Great video thankyou.

[@mohamedhurab5045]

Thank you, Very helpful .

[@hitori_dev]

Great video! Thanks

[@MVMaestro]

Awesome video!

[@abhaypatil9210]

Awesome. Just Awesome!!

[@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]

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

[@iMajed]

Thanks :)

[@cincoer]

Im starting to see red bruh you better stop aksing questions the yap is crazy

[@Cong_Le]

Thank you!

[@baxiry.]

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?