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