kuburitswa kutsva kweprojekiti , iyo inopa yekuwedzera kuPostgreSQL DBMS inogadzirisa dambudziko rekuhwanda kana kutsiva zvakavanzika kana zvekutengesa zvakavanzika data. Data inogona kuvanzwa panhunzi zvichibva pamitemo yakanyatsotsanangurwa uye rondedzero yevashandisi vane mhinduro kune zvikumbiro dzinofanirwa kusazivikanwa. Code ine rezinesi pasi pePostgreSQL.
Semuenzaniso, nerubatsiro rwekuwedzera-mumubvunzo, unogona kupa mukana kune dhatabhesi kune vechitatu mapato, semuenzaniso, wechitatu-bato rebhizinesi rekuchenjera masevhisi, otomatiki kucheka data kwavari senge nhamba dzenhare uye makadhi echikwereti, kana kushandisa nzira dzakaoma kunzwisisa, dzakadai sekutsiva vatengi nemakambani mazita nemashoko ekunyepedzera. Pamusoro pekuita kusazivikanwa kana uchibatanidza zvakananga kuDBMS, pane nzira yekugadzira isingazivikanwe SQL dumps (iyo pg_dump_anon utility inokurudzirwa).
PostgreSQL Anonymizer PostgreSQL DDL (Data Tsanangudzo Mutauro) uye inokutendera kuti uise zano rekusazivikanwa padanho re schema rinotsanangura chimiro chetafura. Iyo yakakura seti yemabasa inopihwa kuti data igadziriswe itsiviwa: randomization, kutsiva ne dummy values, chikamu. , kukwenya, ruzha, nezvimwe. Iyo vhezheni nyowani inowedzera mabasa ekuzivisa zviziviso, uye zvakare ine pseudonymization modhi inobvumidza iwe kuburitsa echokwadi ekunyepedzera tsika dzakasungirirwa kune sosi data.
Pamusoro pezvo, isu tinogona kucherechedza puratifomu yakavhurika yakagadziridzwa neMicrosoft yekuona kubuda kweruzivo rwakavanzika . Iyi puratifomu inobvumidza iwe kuona kana kudzima ruzivo mumagwaro, zvinyorwa uye mifananidzo ine yemunhu uye yakavanzika data, senge zita rakazara, nhamba dzenhare, email, nhamba dzekadhi rechikwereti, crypto wallet, kero, nhamba dzepasipoti, data rezvemari, nezvimwe. Inotsigira kugadziridzwa kweakasiyana ekuchengetedza (kubva kuAmazon S3 kuenda kuPostgreSQL) uye mafomati. Iyo kodhi yakanyorwa muGo (kune vhezheni muPython) uye pasi peMIT rezinesi.
Source: opennet.ru