MathiasBulte

Client-side SSL

For excessively paranoid client authentication.

---

Updated Apr 5 2019:

because this is a gist from 2011 that people stumble into and maybe you should AES instead of 3DES in the year of our lord 2019.

some other notes:

MathiasBulte

UPDATE activity_fishing_gear
SET type_code = 'TBS'
WHERE id IN (SELECT gear.id FROM activity_gear_characteristic characteristic
              JOIN activity_fishing_gear gear on characteristic.fishing_gear_id = gear.id
              JOIN activity_fishing_activity afa on gear.fishing_activity_id = afa.id
              JOIN activity_fa_report_document afrd on afa.fa_report_document_id = afrd.id
              JOIN activity_flux_report_document fluxReportDocument on afrd.flux_report_document_id = fluxReportDocument.id
              WHERE gear.type_code = 'TBB' AND characteristic.value_measure < 80);