How to use PostgreSQL partitions with Django


Partitions in PostgreSQL(and MySQL too :)) are very useful when we have to store large data dividing them by attribute for future works. In my case I have logs of working on projects, which are stored in partition for each project.

Using partitions in django project is not very difficult, but there is one issue with “returning id” for insert statement in database. Function, which will insert a record to right table, must return trigger, but not id of last record as django expects.

Let's make a support of partitions step by step:

read full ⇝

    2014-10-13 08:00:56      django postgresql partitions

Sony Action Cam firmware update error on Mac OS X


If you has error on firmware update and proposition to restart your camera and start update again, you have to

  1. copy update tool from dmg image to your local hard drive and
  2. select "Get Info" from context menu
  3. set check box "Prevent App Nap"
  4. restart update tool and finish firmware update (if not work, make hard reset before this step)

Algorithm for hard reset:

  1. remove battery and AC adapter(USB cable)
  2. press REC for a one minute
  3. put battery back
    2014-09-15 20:00:01      sony firmware macos