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
  #31  
Old Jun 12, 2011, 05:31 AM
Cedille Cedille is offline
Senior Member
 
Join Date: Sep 2007
Location: Tokyo
Posts: 2,026
Default

And what's about sound engineers?
Reply With Quote
  #32  
Old Jun 12, 2011, 05:37 AM
Gigablah's Avatar
Gigablah Gigablah is offline
VGMdb Administrator
 
Join Date: May 2007
Posts: 2,403
Default

"Audio Engineer" -> Mix/Master/Recording Engineers.
Reply With Quote
  #33  
Old Jun 12, 2011, 05:54 AM
Cedille Cedille is offline
Senior Member
 
Join Date: Sep 2007
Location: Tokyo
Posts: 2,026
Default

I just added the person who is consistently credited as "Sound Engineer", so I wanted to know if there was a better way than just replacing him by somebody else.

On the other hand, subdividing performer credits is pretty nice. We currently can't even see what they perform at their discography pages, although I'm also concerned the list of "instrumentalist" will be super inflated, if we eventually have to add every instrument that has ever existed in the world.
Reply With Quote
  #34  
Old Jun 12, 2011, 06:18 AM
Gigablah's Avatar
Gigablah Gigablah is offline
VGMdb Administrator
 
Join Date: May 2007
Posts: 2,403
Default

Instruments will be denoted by a freetext field at first. That'll also save us the trouble of going through this entire list =)
Reply With Quote
  #35  
Old Jun 12, 2011, 08:46 PM
Revoc's Avatar
Revoc Revoc is offline
VGMdb Advisor
 
Join Date: Dec 2007
Posts: 801
Default

Nice feature. And what's about conductors?
Reply With Quote
  #36  
Old Jun 12, 2011, 09:20 PM
Gigablah's Avatar
Gigablah Gigablah is offline
VGMdb Administrator
 
Join Date: May 2007
Posts: 2,403
Default

That would be a separate role, if we have a need for it.

By the way, it's "what about", not "what's about"...
Reply With Quote
  #37  
Old Jun 13, 2011, 12:57 PM
Revoc's Avatar
Revoc Revoc is offline
VGMdb Advisor
 
Join Date: Dec 2007
Posts: 801
Default

Currently, we don't consider conductors as performers, like Cedille said here. Perhaps could be interesting a specific role. I suppose that conductors are close to the performance issue than other roles that are already available, such as mastering engineer.

Btw, what about producers?
Reply With Quote
  #38  
Old Jun 13, 2011, 03:46 PM
Gigablah's Avatar
Gigablah Gigablah is offline
VGMdb Administrator
 
Join Date: May 2007
Posts: 2,403
Default

It would be better if you guys compile a list of roles you want to see in the database =)

(And make it a separate thread for discussion)
Reply With Quote
  #39  
Old Jun 29, 2011, 08:38 AM
Gigablah's Avatar
Gigablah Gigablah is offline
VGMdb Administrator
 
Join Date: May 2007
Posts: 2,403
Default

June 29, 2011
  • Romaji tracklists now show "transliterated by" rather than "translated by"
Reply With Quote
  #40  
Old Nov 4, 2011, 06:49 AM
Gigablah's Avatar
Gigablah Gigablah is offline
VGMdb Administrator
 
Join Date: May 2007
Posts: 2,403
Default

November 4, 2011
  • Album table and viewcounter table converted to InnoDB, index added to product field; album pages should load much faster now


For a graphical representation of the effects:



The brown area is the average time spent on querying the albums table; the first dip at 07:29 is due to the switch to InnoDB, while the second (and most significant) dip at 07:43 is due to the added index.
Reply With Quote
  #41  
Old Nov 4, 2011, 07:21 AM
Secret Squirrel's Avatar
Secret Squirrel Secret Squirrel is offline
VGMdb Administrator
 
Join Date: May 2007
Location: Cleveland, OH
Posts: 8,138
Default

It's interesting that inserting into vgmdb_track_albums spiked at each of those changes. It's still a potential looming problem as that table becomes gargantuan, but it seems under control for now.

These are some impressive speed gains.
Reply With Quote
  #42  
Old Nov 4, 2011, 08:39 AM
Gigablah's Avatar
Gigablah Gigablah is offline
VGMdb Administrator
 
Join Date: May 2007
Posts: 2,403
Default

Forgot to mention that I also changed the vgmdb_track_albums table into PARTITION BY LINEAR KEY based on albumid. Querying all views for a particular album should be blazing fast now.

By the way, if anyone's interested in the service I used to generate that performance graph, it's New Relic. Really easy to set up and use.
Reply With Quote
  #43  
Old Nov 4, 2011, 08:47 AM
Secret Squirrel's Avatar
Secret Squirrel Secret Squirrel is offline
VGMdb Administrator
 
Join Date: May 2007
Location: Cleveland, OH
Posts: 8,138
Default

Seems like it could be a useful tool for performance tuning. For example, the result you posted may indicate that the query to the market wishlist table could be improved (perhaps it's not indexed ideally, or maybe there's something extra slowing it down -- I should take a look at that to satisfy my curiosity.)
Reply With Quote
  #44  
Old Nov 5, 2011, 07:17 AM
Secret Squirrel's Avatar
Secret Squirrel Secret Squirrel is offline
VGMdb Administrator
 
Join Date: May 2007
Location: Cleveland, OH
Posts: 8,138
Default



You can tell when I added an albumid index to the vgmdb_market_wish table (and a few other things too.)
Reply With Quote
  #45  
Old Nov 5, 2011, 09:20 AM
Secret Squirrel's Avatar
Secret Squirrel Secret Squirrel is offline
VGMdb Administrator
 
Join Date: May 2007
Location: Cleveland, OH
Posts: 8,138
Default

While playing around with speeding up the code, I noticed that the code I wrote to put those little "pencil" icons up for the artist fields was very inefficient and required several calls to the modq database. I completely rewrote this and broadened the scope, so now the little pencil shows up in virtually every album data field. These only show up when a regular (non-staff, non-trusted) editor makes and edit to an album that for which he wasn't the submitter. This should make it easier to identify unapproved edits when glancing at an album page.
Reply With Quote
  #46  
Old Nov 9, 2011, 09:58 PM
Gigablah's Avatar
Gigablah Gigablah is offline
VGMdb Administrator
 
Join Date: May 2007
Posts: 2,403
Default

November 10, 2011
  • Price now shows "Free" rather than "Not For Sale" if an album is marked as "Event Only" with zero price.
Reply With Quote
  #47  
Old Mar 17, 2012, 05:03 AM
Secret Squirrel's Avatar
Secret Squirrel Secret Squirrel is offline
VGMdb Administrator
 
Join Date: May 2007
Location: Cleveland, OH
Posts: 8,138
Default

I didn't know the vBulletin calendar didn't go past 2011. Anyway, I've bumped it up a few years, so we can now add events for this year.
Reply With Quote
  #48  
Old Jun 4, 2012, 03:10 PM
Secret Squirrel's Avatar
Secret Squirrel Secret Squirrel is offline
VGMdb Administrator
 
Join Date: May 2007
Location: Cleveland, OH
Posts: 8,138
Default

I made a change to Org linking so that if an album doesn't fall between an Organizations start and end date (if specified), with a 1 year leeway in each direction, then that Org doesn't show up in the linker's list. This should prevent instances of hooking up the wrong label for labels who change names, and change back to the old name (Nippon Columbia, BMG, etc.)
Reply With Quote
  #49  
Old Aug 2, 2014, 09:16 PM
Illidan's Avatar
Illidan Illidan is offline
VGMdb Administrator
 
Join Date: Feb 2014
Location: Italy
Posts: 1,345
Default

There were a number of small changes over the past few weeks, here's a list:
  • The history pages are now using a proper diff engine that should make it a lot easier to see the exact changes. The "↩" symbol is used to denote added/removed newlines.
    Now it can also be accessed using the "Show History" link in the dropdown menu where all the other edit links are.
    If you didn't know about this kinda hidden feature, now is the time to go check what edits were made in the albums you previously submitted, and learn from them!
  • Twitter integration for artists is back. Remember that when you submit the twitter account name in the artist page, you should omit the @ at the beginning.
  • Added color coding to product search results.
  • The PM that gets sent when a new album/artist is rejected now contains its name, so users will be able to tell which one of their submissions got rejected in case they made more than one.
  • The maximum year for album release dates is now automatically updated.

If you notice any bug, especially with the new history, be sure report it in the bug reports thread.
__________________
Music | Projects | Anime

Last edited by Illidan; Aug 4, 2014 at 11:21 PM.
Reply With Quote
  #50  
Old Aug 2, 2014, 11:45 PM
Dag's Avatar
Dag Dag is offline
VGMdb Advisor
 
Join Date: Dec 2007
Posts: 1,348
Default

Plese let the arrow link come back, good sir (leave the edit menu link too).
Ancient conventions should be kept!
Reply With Quote
  #51  
Old Aug 3, 2014, 12:52 AM
Phonograph's Avatar
Phonograph Phonograph is offline
Senior Member
 
Join Date: Jun 2010
Posts: 4,323
Default

I preferred the arrow link too, just use a different color for the arrow
also, illidan has access to the site? other staff too?
Reply With Quote
  #52  
Old Aug 3, 2014, 01:59 AM
Illidan's Avatar
Illidan Illidan is offline
VGMdb Administrator
 
Join Date: Feb 2014
Location: Italy
Posts: 1,345
Default

Quote:
Originally Posted by Dag View Post
Plese let the arrow link come back, good sir (leave the edit menu link too).
Ancient conventions should be kept!
That was SS idea :P I don't see any issue in having both links (in fact, I found myself clicking the arrow several time today), so I suppose he can add it back.

@Phonograph: I don't actually have access to the server, I'm just helping a bit with these small things
__________________
Music | Projects | Anime
Reply With Quote
  #53  
Old Aug 3, 2014, 02:30 AM
Phonograph's Avatar
Phonograph Phonograph is offline
Senior Member
 
Join Date: Jun 2010
Posts: 4,323
Default

I wondered because it's normally SS who speaks about that
Reply With Quote
  #54  
Old Aug 3, 2014, 05:54 AM
Myrkul's Avatar
Myrkul Myrkul is online now
VGMdb Staff
VGM Artist
 
Join Date: Sep 2007
Location: France
Posts: 3,122
Default

I am also asking the return of the history link with the arrow
We'r all so used to that..
Reply With Quote
  #55  
Old Aug 3, 2014, 06:00 AM
Nisto's Avatar
Nisto Nisto is offline
VGMdb Advisor
 
Join Date: Sep 2009
Posts: 1,189
Default

I agree. You don't have to remove the link from the Edit menu of course.
Reply With Quote
  #56  
Old May 16, 2020, 06:45 PM
Secret Squirrel's Avatar
Secret Squirrel Secret Squirrel is offline
VGMdb Administrator
 
Join Date: May 2007
Location: Cleveland, OH
Posts: 8,138
Default

Haven't used this thread for ages, but here are some recent changes.

New Platforms: Pachislot Machine, Pachinko Machine, Tabletop

New New Artist Role: Scriptwriter

New Media Type: Download Card

Album Classifications:
  • New categories: "Live Action", "Tokusatsu/Puppetry", "Multimedia Franchises" added with new colors.
  • Online help revised to explain all of the categories.
  • When a normal album is submitted without a Category, the category displayed on the album page is "Artist Discography". (Color is still blue)
  • When a doujin album is submitted without a Category, the category displayed on the album page is "Doujin Music". (Color is still blue)

Product Classifications:
  • "Video" changed to "Animation"
  • New categories: "Live Action", "Tokusetsu/Puppetry", "Multimedia Franchises" added with new colors.

Content filtering added to the Artist and Calendar pages.

2 changes to improve moderation queue activities.
Reply With Quote
  #57  
Old May 18, 2020, 03:52 PM
Secret Squirrel's Avatar
Secret Squirrel Secret Squirrel is offline
VGMdb Administrator
 
Join Date: May 2007
Location: Cleveland, OH
Posts: 8,138
Default

Added a new forum for albums under Miscellaneous Discussion. Now:

Video Game Music Discussion/Album Discussions <-- All albums categorized as Game.
Anime Music Discussion/Album Discussions <-- All albums categorized as Animation (unless they are also in Game.)
Miscellaneous Discussion/Album Discussions <-- All albums that are not classified as Anime or Game.
Reply With Quote
  #58  
Old May 22, 2020, 02:12 PM
Secret Squirrel's Avatar
Secret Squirrel Secret Squirrel is offline
VGMdb Administrator
 
Join Date: May 2007
Location: Cleveland, OH
Posts: 8,138
Default

Modified the database queries for displaying the most recently updated albums, media, and ratings. The pages load much faster now (instant vs 15 seconds for worst cases), though the results are limited to the last 3 months (which should be no problem.)
Reply With Quote
  #59  
Old Jun 3, 2020, 06:01 AM
Illidan's Avatar
Illidan Illidan is offline
VGMdb Administrator
 
Join Date: Feb 2014
Location: Italy
Posts: 1,345
Default

  • Replaced the flash covers upload with a JS alternative. Now it also supports drag-dropping the images in the upload box.
  • Replaced the flash graphs (ratings, statistics) with a JS alternative
  • Added a new statistics graph: Anime Album Release Frequency by Year
  • Added row highlighting on mouseover for artists "Manage Credits" page

If you're having any issue, please post here.
__________________
Music | Projects | Anime
Reply With Quote
  #60  
Old Jun 4, 2020, 04:35 AM
Illidan's Avatar
Illidan Illidan is offline
VGMdb Administrator
 
Join Date: Feb 2014
Location: Italy
Posts: 1,345
Default

  • Covers upload now attempts to automatically select the correct scan caption by using the file name.
  • Added twitter field and timeline to products.
  • Added twitter field and timeline to labels.
  • Updated twitter timeline to the latest version, should fix the visual issues and load faster.
  • Merged recent and upcoming works for products and labels, to be consistent with artists.
  • Added new roles (Assistant, Assistant Engineer, Scriptwriter) to advanced search.
  • Podcast and radio links were down and are now hidden.
  • Unconfirmed and banned users can no longer leave ratings.
  • Fixed artist->artist links not being cleaned up when deleting an unit that still had members.
    Orphaned entries already in the db (showing up as empty lines in the Units section of artists) were cleaned up manually (thanks SS!)
__________________
Music | Projects | Anime
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