Ukuphehlelelwa Inguqulelo entsha yeprojekthi Iposi ye-PostgreSQL engaziwayo 0.6, ebekwe njengaweukhetho olugqwesileyo ebonelela ngokongeza kwi-PostgreSQL DBMS, esombulula ingxaki yokufihla okanye yokutshintsha idatha ebuthathaka okanye ulwazi eyimfihlo yorhwebo.
Idatha inokufihlwa kubhabho ngokusekwe kwimigaqo nakuluhlu ichazwe ngokukodwa kubasebenzisi abaneempendulo kwizicelo ekufuneka zingachazwanga.
Ngokomzekelo, usebenzisa iplagi ekuthethwa ngayo, ungabonelela ngokufikelela kwindawo yogcino lwedatha kubantu besithathuUmzekelo, iinkonzo zeshishini lomntu wesithathu ngokuzenzekelayo ukusika idatha kubo, njengeenombolo zefowuni kunye namakhadi etyala okanye ukusebenzisa iindlela ezintsonkothileyo, ezinje ngokutshintsha amagama abathengi kunye neenkampani kulwazi olungeyonyani.
Ukongeza kokungaziwa xa uqhagamshela ngqo kwi-DBMS, kukho indlela yokwenza iindawo zokuchithwa kwe-SQL ezingaziwayo (into eluncedo pg_dump_anon iyacetyiswa).
IPostgreSQL Isichazi-magama sokwandisa iPostgreSQL DDL (ULwimi lweNkcazo yoLwimi) kwaye ikuvumela ukuba uchaze isicwangciso sokungaziwa kwinqanaba le-schema elichaza ubume betafile.
Iseti enkulu yemisebenzi ibonelelwe ukuqhubekeka idatha Ukutshintshwa: ukurhoxiswa, ukufakwa endaweni yamaxabiso edummy, ukufaka ikhowudi ngokuthe ngqo, ukushukuma, ingxolo, njl.
Ulwandiso ixhasa iindlela ezi-3 ezahlukeneyo zokungaziwaUkwenza imaski enamandla, ukungaziwa endaweni, kunye nokulahla okungaziwayo.
Ikwabonelela ngemisebenzi eyahlukeneyo yokufihla indawo: ukufaka endaweni ethile, ukwenza ngokungafaniyo, ukwenza igama ngokungaziwayo, ukufaka iikhowudi ngokuyinxenye, ukushukuxa, ukongeza ingxolo, kunye nokwenza ngokubanzi.
Imisebenzi yokuchazwa ngokufanayo iyafana nemisebenzi yomgunyathi kuba ivelisa amaxabiso asengqiqweni. Umahluko ophambili kukuba i-pseudonymization ichongiwe: imisebenzi iya kuhlala ibuyisa ixabiso elifanayo lobuxoki.
Yintoni entsha kwiPostgreSQL Anonymizer 0.6?
Inguqulelo entsha yongeza imisebenzi yezazisi kunye nemowudi yokubiza igama ekuvumela ukuba uvelise amaxabiso edummy ayinyani aqhagamshelwe kwidatha yomthombo.
Ukongeza, kunokwenzeka ukuba uqaphele iqonga elivulekileyo eliphuhliswe nguMicrosoft ukubona ukuvuza kolwazi oluyimfihlo lwePresidio.
Iqonga livumela ukuchongwa okanye ukupheliswa kolwazi kumaxwebhu, imibhalo kunye nemifanekiso enedatha yobuqu neyimfihlo, njengegama elipheleleyo, iinombolo zefowuni, i-imeyile, iinombolo zekhadi letyala, izipaji, iidilesi, iinombolo zepaspoti, idatha yezemali, njl.
Ukulungiswa kwezinto ezininzi kugcinwa (ukusuka kwiAmazon S3 ukuya kwiPostgreSQL) kunye neefomathi. Ikhowudi ibhaliwe kwi-Go (kukho ukhetho kwiPython) kwaye isasazwa phantsi kwelayisenisi ye-MIT.
Uyifaka njani i-PostgreSQL Isichazi?
Kulungiselelwe abo banomdla wokukwazi ukufaka okanye ukuvavanya oku kuluncedo, Kuya kufuneka kuqala ufake le ilandelayo postgresql-devel okanye postgresql-server-dev.
Emva koko, sineendlela ezininzi zokufaka usetyenziso kwinkqubo yethu. Indlela yokuqala esinokuyisebenzisa yile ukwenza ukudityaniswa ngokungathi lolunye ulwandiso.
Ngale nto kufuneka sifumane ikhowudi yemvelaphi kwikhonkco elingezantsi. Emva koko, siza kukhupha ipakethe kwaye sidibanise kunye:
make extension sudo make install
Uyenzile le nto, ngoku siza kongeza ulwandiso kumathala eencwadi alayishwe ngaphambili kwiziko ledatha:
ALTER DATABASE foo SET session_preload_libraries='anon';
Sivakalisa ukongezwa kwaye silayisha idatha:
CREATE EXTENSION anon CASCADE; SELECT anon.load();
Enye indlela yokufaka oku kuluncedo ngoncedo lweDocker, ukuze sikwazi ukufaka ngale ndlela kufuneka iDocker sele ifakiwe kwaye isebenza kwinkqubo.
Ukuze ufake umfanekiso, kufuneka sichwetheze lo myalelo ulandelayo:
docker pull registry.gitlab.com/dalibo/postgresql_anonymizer
Kwaye sinokuqhuba isikhongozeli ngalo myalelo ulandelayo:
docker run -d --name anon -p 6543:5432 registry.gitlab.com/dalibo/postgresql_anonymizer
Sidibanisa:
psql -h localhost -p6543 -U postgres
Ulwandiso sele lulayishiwe, ungalusebenzisa ngokuthe ngqo:
SELECT anon.partial_email('daamien@gmail.com');
partial_email
-----------------------
da******@gm******.com
(1 row)
Ukongeza kwezi ndlela, kwabo basebenzisa iiseva okanye iRHEL okanye iCentOS ifakiwe, banokufaka olu lwandiso ngokulula.
Chwetheza lo myalelo ulandelayo:
yum install postgresql_anonymizer12
Okokugqibela, ukuba ufuna ukwazi ngakumbi ngayo okanye ufuna ukudibana noxwebhu kwaye usebenzise imizekelo. Ungajonga konke oku kwaye ngaphezulu kokulandelayo.