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?
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.
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?
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?
This is an amazing tutorial - I particularly liked the series of questions and answers format. Thanks James!
is it really tho?
Very high quality content. Congrats!
r u sur about that?
It would be quite nice to have ether a github or a pastebin with the sql written in this video!
Absolutely phenomenal series!
Oh just what I was looking for!
This is a fantastic explantation, thank you!
i dont think so
I was wondering, does that means the size of the db file is doubled?
i think even more.
Amazing tutorial. thank you
Really helpful for a biginner, thank you!
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?
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.
This helped a ton--thank you!
Great video, very well explained
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?
Awesome. Just Awesome!!
Awesome video!
Great video thankyou.
Thank you, Very helpful .
Great video! Thanks
Does this MATCH do a fuzzy find ? How does the search work?
Thanks :)
Im starting to see red bruh you better stop aksing questions the yap is crazy
AWESOME!
Thank you!
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?