Announcements

Help Wizard

Step 1

NEXT STEP

Shazam synchronization

Status: Case Closed
0 Likes

I don't know how many times in past year I had problems with synchronization of Shazam with Spotify. I work as ETL developer and when I see problems with loading one table it makes me so confused. You should shave **bleep** of developer responsible for that integration and send him back to school. 

 

1. There is no callback which checks if list was updated, so You have to restart application to see any of new songs added to list. Is it so hard to create one global timestamp calculated across all tables and make update if any of tables was changed? 

 

I can help You with that: 

 

https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions060.htm

 

SELECT GREATEST( PROFILE_TIMESTAMP,  SHAZAM_TIMESTAMP,  XXX_TIMESTAMP )  as darn

FROM 

A LEFT JOIN B  ON A.X=X.B

LEFT JOIN C.Y=A.Y  

 

2. Some of the songs even if they are identified they are invisible on list, but they are available in Spofify's library so they are identified  

 

3. I had this type of problems in past I was forced to remove list and upload once again, because there was no possibility to see new tracks. 

 

4. Name of list is changing somtimes I have local name in Polish "Twoje utwory w Shazam" and sometimes "Your shazzam tracks" are You really so ignorant to identify if there is Shazam list already, no matter what's the language settings on device ? 

 

Regards & be more serious

 

2018-01-05 16_30_08-A R I Z O N A - I Was Wrong - Acoustic.png
Screenshot_20180105-163001.png

Hey @rafal_wardas!

 

Thank you for this very detailed report and all the info. We'll be passing this on to the right team to take a closer look.

 

If anything else comes up, don't hesitate to give us a shout.

 

All the best.

Comments
Alfredo
Status changed to: Case Closed

Hey @rafal_wardas!

 

Thank you for this very detailed report and all the info. We'll be passing this on to the right team to take a closer look.

 

If anything else comes up, don't hesitate to give us a shout.

 

All the best.