#40
  • Created on
    2007-05-09 08:22
  • Reported by
    swiss
  • Status
    Fixed
  • Priority
    Normal (3)
  • Assigned to
    -
  • Milestone
    1.19
  • Plan Level
    -
  • Due Date
    -

Attachments

Related Tickets

Add new subtask or bug

Store fingerprint of ID3 images for music

Change the 'file_id' column in the mp3_albumart table to reference a hash of the picture and reference the hash instead of the actual picture ID. This would allow a single picture to be shared by multiple tracks and reduce the size of the database files (assuming that it's the same albumart for all songs in an album!).
User picture
  on 2011-03-30 11:40 *
By swiss
Milestone set to Undecided
User picture
  on 2011-03-30 11:40 *
By Pernod
Status changed from New to closed
(In revision:864) Changed the storage of images from media files. Images found in media tags are now stored in a new table MEDIA_ART and are referenced by their SHA1 hash value. This allows album art to be stored only once and will greatly reduce the size of the art table.

The table MP3_ALBUMART will be dropped with this update. A media search will be required (with metadata refresh) to populate the new table.

Fixes* 40
User picture
  on 2011-03-30 11:40 *
By Pernod
Milestone changed from Undecided to Undecided
(In revision:864) Changed the storage of images from media files. Images found in media tags are now stored in a new table MEDIA_ART and are referenced by their SHA1 hash value. This allows album art to be stored only once and will greatly reduce the size of the art table.

The table MP3_ALBUMART will be dropped with this update. A media search will be required (with metadata refresh) to populate the new table.

Fixes* 40
User picture
  on 2011-04-01 14:41 *
By Pernod
Component changed from None to Database
User picture
  on 2011-04-22 20:35 *
By Pernod
Status changed from Closed to Fixed
Updating tickets (#63, #65, #75, #84, #87, #89, #93, #185, #10, #57, #64, #69, #70, #74, #79, #80, #82, #83, #85, #86, #88, #90, #91, #96, #97, #98, #99, #100, #101, #104, #105, #109, #115, #116, #117, #120, #126, #128, #130, #131, #133, #135, #153, #163, #169, #171, #173, #179, #180, #181, #184, #187, #188, #194, #195, #198, #203, #205, #218, #220, #226, #231, #236, #239, #240, #242, #247, #252, #5, #6, #11, #20, #25, #26, #27, #29, #30, #38, #40, #42, #43, #44, #46, #49, #50, #51, #52, #53, #55, #58, #59, #60, #61, #71, #92, #102, #103, #106, #107, #108, #112, #113, #114, #118, #119, #121, #129, #137, #140, #141, #144, #145, #146, #147, #149, #150, #151, #152, #154, #156, #157, #158, #160, #161, #162, #165, #167, #168, #172, #176, #182, #183, #191, #192, #193, #196, #197, #204, #206, #210, #215, #217, #222, #228, #230, #232, #234, #235, #237, #243, #249, #1, #4, #9, #12, #13, #16, #62, #78, #164, #166, #189, #190, #199, #200, #208, #209, #211, #212, #19, #47, #48)