1. 10

  2. 1

    Basically he is rolling his own crypto. Far better advices are the possibilities given in https://wiki.postgresql.org/wiki/Pseudo_encrypt (skip32 and xtea) which has not constant key. If one has to keep existent key, one could use two different prefix for old and new key.

    1. 1

      The 32bit version from the postgresql site:


      Looks like a great approach for this problem and will outperform using UUIDs.