VGMdb
Go Back   VGMdb Forums > VGMdb Site Related > Questions and Comments
Register FAQ Calendar Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old Sep 25, 2008, 04:10 AM
Gigablah's Avatar
Gigablah Gigablah is offline
VGMdb Administrator
 
Join Date: May 2007
Posts: 2,397
Default Artist name autocomplete

I'm testing out the jQuery javascript library on VGMdb, which allows for easy implementation of some advanced techniques such as dynamic autocomplete. You can see it in action on the artist fields on the album submission page (new album / album edit). It activates with a minimum of three characters, with the comma as separator.




If it works out, I'd be extending this to other areas of the site, such as replacing the current collection tree view script.
Reply With Quote
  #2  
Old Sep 25, 2008, 09:28 AM
Liontamer's Avatar
Liontamer Liontamer is offline
VGMdb Staff
VGM Artist
 
Join Date: Sep 2007
Location: Atlanta, GA
Posts: 419
Default

Looks good! Very nice work.
__________________
Larry "Liontamer" Oji
Community Manager & Submissions Judge, OverClocked ReMix
OC ReMix ~ twitter.com/ocremix ~ facebook.com/ocremix ~ youtube.com/ocremix
Reply With Quote
  #3  
Old Sep 25, 2008, 10:45 AM
seanne's Avatar
seanne seanne is offline
VGMdb Staff
 
Join Date: May 2007
Location: Sweden
Posts: 1,202
Default

This should come in handy. Nice work!
__________________
VGMdb group on last.fm
Reply With Quote
  #4  
Old Sep 25, 2008, 12:55 PM
Kaleb.G's Avatar
Kaleb.G Kaleb.G is offline
VGMdb Staff
VGM Artist
 
Join Date: May 2007
Location: California, USA
Posts: 1,024
Default

You could optionally make the query return distinct results. It returns two records for "Brian Davis" for example.
Reply With Quote
  #5  
Old Sep 25, 2008, 05:33 PM
Gigablah's Avatar
Gigablah Gigablah is offline
VGMdb Administrator
 
Join Date: May 2007
Posts: 2,397
Default

That's because there are two records for "Brian Davis", one added by Akumu and the other by Liontamer. You guys might want to sort that out

I'll add the ID display next to the names, so you can differentiate between two artists with the same name.
Reply With Quote
  #6  
Old Sep 28, 2008, 07:37 AM
Eriol's Avatar
Eriol Eriol is offline
VGMdb Staff
 
Join Date: May 2007
Location: U.S.A.
Posts: 194
Default

GigaBlah,
Using jQuery, are you making an Ajax call to a web service that returns XML and using that to build the autocomplete?
Reply With Quote
  #7  
Old Sep 28, 2008, 04:17 PM
Akumu's Avatar
Akumu Akumu is offline
VGMdb Staff
 
Join Date: Sep 2007
Location: Norway
Posts: 282
Default

Quote:
Originally Posted by Gigablah View Post
That's because there are two records for "Brian Davis", one added by Akumu and the other by Liontamer. You guys might want to sort that out

I'll add the ID display next to the names, so you can differentiate between two artists with the same name.
I think they are actually 2 different Brian Davis's. The Brian Davis I added just goes under his real name and released a few cds several years ago, while the one Larry added did alot of work more recent under the remix name Ubik, in a completely different style than the other.
Reply With Quote
  #8  
Old Sep 28, 2008, 05:34 PM
Liontamer's Avatar
Liontamer Liontamer is offline
VGMdb Staff
VGM Artist
 
Join Date: Sep 2007
Location: Atlanta, GA
Posts: 419
Default

Quote:
Originally Posted by Akumu View Post
I think they are actually 2 different Brian Davis's. The Brian Davis I added just goes under his real name and released a few cds several years ago, while the one Larry added did alot of work more recent under the remix name Ubik, in a completely different style than the other.
Yep, 2 different guys. Kenji Yamamoto redux!
__________________
Larry "Liontamer" Oji
Community Manager & Submissions Judge, OverClocked ReMix
OC ReMix ~ twitter.com/ocremix ~ facebook.com/ocremix ~ youtube.com/ocremix
Reply With Quote
  #9  
Old Sep 28, 2008, 09:35 PM
Gigablah's Avatar
Gigablah Gigablah is offline
VGMdb Administrator
 
Join Date: May 2007
Posts: 2,397
Default

Quote:
Originally Posted by Eriol View Post
GigaBlah,
Using jQuery, are you making an Ajax call to a web service that returns XML and using that to build the autocomplete?
Yeah, it's an AJAX call to a php file that grabs a list of names for populating the dropdown select. I don't think it'll place excessive load on the server (since it makes use of the AJAX queue plugin), but if it does we could always switch to an XML file cache.
Reply With Quote
  #10  
Old Sep 29, 2008, 07:59 AM
Eriol's Avatar
Eriol Eriol is offline
VGMdb Staff
 
Join Date: May 2007
Location: U.S.A.
Posts: 194
Default

Quote:
Originally Posted by Gigablah View Post
Yeah, it's an AJAX call to a php file that grabs a list of names for populating the dropdown select. I don't think it'll place excessive load on the server (since it makes use of the AJAX queue plugin), but if it does we could always switch to an XML file cache.
Thanks for the explanation. I was using jQuery for an Ajax call (to a non-XML output PHP file), so I was curious about your basic implementation.

From my past experience, the ajax call should not really cause an excessive load. It would take a massive amount of returned data for that. I actually would be more worried about the browser's memory usage from loading a large XML file than I would about the server load.
Reply With Quote
  #11  
Old Oct 1, 2008, 08:16 AM
Gigablah's Avatar
Gigablah Gigablah is offline
VGMdb Administrator
 
Join Date: May 2007
Posts: 2,397
Default

Added a function to automatically strip trailing commas from the artist fields whenever album info is submitted >_>
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Artist wiki? Gigablah Questions and Comments 6 Oct 15, 2014 03:12 AM
What to use on the ARTIST tag when tagging? Kewing Miscellaneous Discussion 3 Sep 26, 2010 01:15 PM
Artist name variations Gigablah Questions and Comments 21 Jan 15, 2009 07:57 PM
Artist order Kaleb.G Questions and Comments 1 Jan 12, 2008 07:56 AM