This is an amazing tutorial - I particularly liked the series of questions and answers format. Thanks James!
@cincoer8 күн бұрын
is it really tho?
@MrThierriOliveira10 ай бұрын
Very high quality content. Congrats!
@cincoer8 күн бұрын
r u sur about that?
@joranmulderij Жыл бұрын
Absolutely phenomenal series!
@nodidog4 ай бұрын
This is a fantastic explantation, thank you!
@cincoer8 күн бұрын
i dont think so
@antonioorsatti3270 Жыл бұрын
I was wondering, does that means the size of the db file is doubled?
@eric0793 Жыл бұрын
Really helpful for a biginner, thank you!
@atimney3 ай бұрын
Great video, very well explained
@mohamedhurab50452 ай бұрын
Thank you, Very helpful .
@shadygoat9146 Жыл бұрын
It would be quite nice to have ether a github or a pastebin with the sql written in this video!
@hitori_dev Жыл бұрын
Great video! Thanks
@MVMaestro Жыл бұрын
Awesome video!
@abhaypatil92107 ай бұрын
Awesome. Just Awesome!!
@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.
@kishanbsh6 ай бұрын
Does this MATCH do a fuzzy find ? How does the search work?
@iMajed10 ай бұрын
Thanks :)
@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?
@cincoer8 күн бұрын
Im starting to see red bruh you better stop aksing questions the yap is crazy
@Cong_Le Жыл бұрын
Thank you!
@baxiry.5 ай бұрын
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?