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 Apr 10, 2008, 09:18 AM
Gigablah's Avatar
Gigablah Gigablah is offline
VGMdb Administrator
 
Join Date: May 2007
Posts: 2,397
Default In preparation for "clean" URL rewrites

Now that we have an increasing number of sites linking to our content pages, there's a pressing need to finalize our URL format. My plan is to turn an address like this:

http://www.vgmdb.net/db/albums.php?id=14

Into this:
http://www.vgmdb.net/db/albums/id/14-einhander-original-soundtrack/

For listings:
http://www.vgmdb.net/db/albums/title/0-9/1/
http://www.vgmdb.net/db/albums/title/a/3/
http://www.vgmdb.net/db/albums/catalog/s/5/
...

And similarly for artist pages:

http://www.vgmdb.net/db/artists/id/294-kenichiro-fukui/


And so on. I don't plan on changing the URLs for the forums or submission pages -- only for the pages that display primary information.

There'll be 301 redirection for legacy and malformed URLs -- for example, accessing

http://www.vgmdb.net/db/albums.php?id=14

or
http://www.vgmdb.net/db/albums/id/14-gibberish-here/

will get you redirected to the proper address. This will prevent URLs from being broken whenever the album title (and the corresponding URL portion, or "slug") gets changed.


Any comments, particularly regarding the proposed URL format?
Reply With Quote
  #2  
Old Apr 10, 2008, 10:15 AM
Secret Squirrel's Avatar
Secret Squirrel Secret Squirrel is offline
VGMdb Administrator
 
Join Date: May 2007
Location: Cleveland, OH
Posts: 5,935
Default

Will there be any problems with having some of the more unusual symbols in the titles, or will those all be omitted from the URL? I can't find any examples, but I know there are some with stars or hearts.
Reply With Quote
  #3  
Old Apr 10, 2008, 10:49 AM
Gigablah's Avatar
Gigablah Gigablah is offline
VGMdb Administrator
 
Join Date: May 2007
Posts: 2,397
Default

The URI syntax restricts the characters that can be used. All accented characters will be converted to non-accented ones, "&" will be converted to "and", and punctuation and other symbols will be removed. Spaces will be replaced by dashes.

Some examples of the conversion:

"Donkey Kong Country 3 ~ Dixie's Double Trouble! Original Soundtrack (US)" => "donkey-kong-country-3-dixies-double-trouble-original-soundtrack-us"

"[-Aka-] Complete Edition Original Soundtrack - Primitive" => "aka-complete-edition-original-soundtrack-primitive"
Reply With Quote
  #4  
Old Apr 10, 2008, 11:51 AM
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

Looks good to me. Reminiscent of the way GFF is handled.
Reply With Quote
  #5  
Old Apr 10, 2008, 06:08 PM
Secret Squirrel's Avatar
Secret Squirrel Secret Squirrel is offline
VGMdb Administrator
 
Join Date: May 2007
Location: Cleveland, OH
Posts: 5,935
Default

I don't know much about SEO, but I'd say that this scheme looks like a fine one.
Reply With Quote
  #6  
Old Jun 14, 2008, 05:40 AM
Gigablah's Avatar
Gigablah Gigablah is offline
VGMdb Administrator
 
Join Date: May 2007
Posts: 2,397
Default

I've done a bit of re-thinking about this.

I'm now considering scrapping the title slug completely, and just having ID numbers like
http://www.vgmdb.net/db/album/14/
http://www.vgmdb.net/db/album/287/

The reason being that, since we're a strictly informational site, there's really no reason for us to play the SEO game. Considering the nature of names and album titles, the generated title slugs would actually end up making the URLs dirtier. Having shorter, ID-based URLs also makes it a lot simpler to manually construct links, too.
Reply With Quote
  #7  
Old Jun 14, 2008, 05:50 AM
Secret Squirrel's Avatar
Secret Squirrel Secret Squirrel is offline
VGMdb Administrator
 
Join Date: May 2007
Location: Cleveland, OH
Posts: 5,935
Default

If that's the case, why change them at all? We've already got thousands of links pointing at our content.

And I agree. We've got great search-engine presence without playing any tricks, so it's probably not worth it.
Reply With Quote
  #8  
Old Jun 14, 2008, 09:07 AM
Liontamer's Avatar
Liontamer Liontamer is offline
VGMdb Staff
VGM Artist
 
Join Date: Sep 2007
Location: Atlanta, GA
Posts: 419
Default

No pressure implied, but whatever happens to finalize things with all of the URLs, I'll be glad so we can finally start linking things at OC ReMix. :-)
__________________
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 Jun 16, 2008, 11:17 PM
R-T's Avatar
R-T R-T is offline
Member
 
Join Date: Dec 2007
Posts: 43
Default

If you want to drop the album title part, how about reducing URLs to http://vgmdb.net/a272 for albums
http://vgmdb.net/m112 for artists (musicians?)
Reply With Quote
  #10  
Old Jun 17, 2008, 10:25 AM
mrnutz's Avatar
mrnutz mrnutz is offline
Member
 
Join Date: Feb 2008
Location: Los Angeles, CA, USA
Posts: 98
Default

I can understand the desire to move to a cleaner format. However, this implies supporting backwards compatibility (the redirects) forever doesn't it? That seems like extra work. Are there other advantages?
Reply With Quote
  #11  
Old Jun 17, 2008, 11:11 AM
Gigablah's Avatar
Gigablah Gigablah is offline
VGMdb Administrator
 
Join Date: May 2007
Posts: 2,397
Default

The redirects can be done with 2-3 lines of code in .htaccess, as long as we don't include stuff like the album title in the URL (otherwise we'd have to do it via the script). The other advantages (apart from short, clean addresses) would probably only make sense to a web developer (abstraction, masking, etc).

R-T's proposed format is certainly attractive (and it's currently in use at vndb.org).
Reply With Quote
  #12  
Old Jun 24, 2008, 02:51 AM
R-T's Avatar
R-T R-T is offline
Member
 
Join Date: Dec 2007
Posts: 43
Default

Quote:
Originally Posted by Gigablah View Post
R-T's proposed format is certainly attractive (and it's currently in use at vndb.org).
..who borrowed the idea from Anidb.net.
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
VICL-60677: Kohei Tanaka 20 Shuunen Na Yoru "Top o Nerae!"Kara"Yuushao Gaogaiga"Made Zhane Masaki Album Discussions 0 Jan 25, 2015 01:00 AM
For Sale: Haruomi Hosono's "Video Game Music" and "Super Xevious" Mondeyano Video Game Music Discussion 0 Feb 21, 2013 05:40 PM
FVCG-1173: Science Adventure Dance Remix "CHAOS;HEAD" "STEINS;GATE" kami68k Album Discussions 0 Sep 29, 2011 12:47 PM
COCX-36021~2: COBRA THE ANIMATION "THE PSYCHOGUN" & "TIME DRIVE" COMPLETE SOUNDTRACK Phonograph Album Discussions 1 Feb 18, 2011 10:06 PM
Merge "Independent" and "Doujin/Fanmade" publisher types back into "Doujin/Indie"? Gigablah Questions and Comments 20 Feb 15, 2010 07:34 PM