Yesterday, after long period of API testing, new version was submitted gor review, the most important changes:

  • trakt.tv synchronization
  • switched to our own API – currently only for updating data, in next version for all operations

New API is built using Python 3.3 with Flask framework and MySql database

Well, first rule – you should not do this. But if there is good reason, consider using such query for searching in index-based arrays:

In case you have assoc array serialized you can use:

Of course it won’t be very fast but in small tables should be enough

Just use:

where first param UNIX_TIMESTAMP(‘2012-11-13 16:00:00’) is start value, second UNIX_TIMESTAMP(‘2012-11-13 23:00:00’) is end value, it has to be repeated twice like shown here: