Posts Tagged ‘Blog’

« Previous 1 2 3 4 5 6 7 8 14

Rocksmith Song Search 2.0 [Update: 2018-08-15]

Posted: , By Patcoola

Song packs are now searchable using a cross reference table containing artist and song IDs. Doing so was a major undertaking, 262 packs were modified and audited while 1094 reference entries were manually added into the database.

Big news, the search query has been greatly refined to just five generated conditions. The refinement is a big logic break through. I basically discovered that anything can be accurately found just by looking for the first and last word in the search terms. The spelling pattern now applies to words greater than four characters and has a simply applied “s” clause.

Read more…

Rocksmith Song Search 2.0 [Update: 2018-08-03]

Posted: , By Patcoola


  • Database now has song duration (complete)
  • Database now supports song music video
  • Database now supports song rift video
  • Database now supports song lyrics
  • Administration now has new add song form

Exciting news, the current 1200+ songs have been updated to include song duration. A new addition has been added to provide searchers with the option to view and watch Youtube videos on site. Searchers can watch a song’s music video, rift video, and read lyrics on site.

Read more…

Rocksmith Song Search 2.0 [Update: 2018-04-25]

Posted: , By Patcoola

The new relationship database came with an audit of artists listed. Officially Rocksmith has 476 artists (bands) in my database, however, an audit expanded the artists, groups, and composers to 490 which was refined to 481.

Read more…

Rocksmith Song Search 2.0 [Announcement]

Posted: , By Patcoola

The Rocksmith Song Search will be moving to its own blog. The dedicated song blog will feature many new improvements over the current database.

  • New relationship database
  • Simple interface
  • Single search field with optional advance option

Rocksmith currently has 476 artists, 1207 songs, and 262 song packs. The new database is more manageable and provides more development opportunities. Artist search now has more search terms, allowing for improved results for miss spellings.

Read more…

Blog Update 2016-03-04

Posted: , By Patcoola

My blog’s layout is now one inch wider, and can switch to a slightly smaller width when resized. For a long time the headline images was made with a 720 pixel width, and was displayed at 645 pixels. Now we can all enjoy the full size of the images. Users of the Rocksmith Song Search service will be happy to take advantage of the wider area. Some blog theme issues have also been fixed.

Recently I finished an administrative service I call the Backup Module. This module creates ZIP archives for backup profiles. Very handy for downloading the server files or uploading files. Next on the list of things to do, is design the theme for my I.T. website. I hope to go into production of my video game in May.

Blog Update 2016-01-09

Posted: , By Patcoola

The blog is now more mobile friendly. Thanks to a mobile theme adaptation I designed. Visitors can now browse my blog with their mobile devices easier.

Browser Pusher, a web browser detection script I created has also been updated for better mobile detection and can detect the Edge browser. Mobile users will automatically view the mobile layout.

Visitors will also notice that the top menu now floats at the top of the screen. Except for the oldest browser I support: Internet Explorer 7.

Page titles now display the correct bread crumbs for categories.

Loading pages no longer flash the background.

Rearrangement of JavaScript placement should help decrease page rendering time, pages should load faster.

A fix for the footer has been made for Microsoft’s Edge browser which had a height issue.

The projects page has updated to list projects from 2015 (last year).