• About TC
  • Affiliate Disclaimer
  • Privacy Policy
  • TOS
  • Contact
Wednesday, July 2, 2025
Techcratic
  • TC
  • AI
    Artificial Intelligence

    EgoDex: Learning Dexterous Manipulation from Large-Scale Egocentric Video

    Artificial Intelligence

    Instruction-Following Pruning for Large Language Models

    Artificial Intelligence

    How to Combine Streamlit, Pandas, and Plotly for Interactive Data Apps

    Artificial Intelligence

    Tailor responsible AI with new safeguard tiers in Amazon Bedrock Guardrails

    Artificial Intelligence

    Automate Data Quality Reports with n8n: From CSV to Professional Analysis

    Artificial Intelligence

    NewDay builds A Generative AI based Customer service Agent Assist with over 90% accuracy

    Artificial Intelligence

    5 Things You Need to Know About Agentic AI

    Artificial Intelligence

    Normalizing Flows are Capable Generative Models

    Artificial Intelligence

    Update on the AWS DeepRacer Student Portal

  • App Zone
    Top 3 Launcher Apps for Apple: Features, Pros, and Cons

    Top 3 Launcher Apps for Apple: Features, Pros, and Cons

    Top 3 Launcher Apps for Android: Features, Pros, and Cons

    Top 3 Launcher Apps for Android: Features, Pros, and Cons

    Top 3 Card Game Apps of 2025: Features, Pros, and Cons

    Top 3 Card Game Apps of 2025: Features, Pros, and Cons

    Top 3 Medical Apps of 2025: Features, Pros, and Cons

    Top 3 Medical Apps of 2025: Features, Pros, and Cons

    Top 3 Travel Apps of 2025: Features, Pros, and Cons

    Top 3 Travel Apps of 2025: Features, Pros, and Cons

    Top 3 Casual Game Apps for 2025: Features, Pros, and Cons

    Top 3 Casual Game Apps for 2025: Features, Pros, and Cons

    Top 3 Food Apps for 2025: Features, Pros, and Cons

    Top 3 Food Apps for 2025: Features, Pros, and Cons

    Top 3 Sport Apps for 2025: Features, Pros, and Cons

    Top 3 Sport Apps for 2025: Features, Pros, and Cons

    Top 3 Productivity Apps for 2025: Features, Pros, and Cons

    Top 3 Productivity Apps for 2025: Features, Pros, and Cons

  • Apple
    M4 iPad Pro, iPad A16, Apple Pencil Pro, AirTag, more 9to5Mac

    M4 iPad Pro, iPad A16, Apple Pencil Pro, AirTag, more 9to5Mac

    iPhone expansion, Foxconn India drops Chinese experts, mystery

    Qantas data breach exposes personal details of millions

    Qantas data breach exposes personal details of millions

    July 2, 2025 – iPhone Fold, Apple vs DOJ

    Five new Apple products are launching early this year, here’s what’s coming

    Apple is launching 15+ new products this fall, here’s what’s coming

    iOS 26’s new Liquid Glass design looks like a major win for Apple

    iOS 26’s new Liquid Glass design looks like a major win for Apple

    OLED MacBook Pro still expected for 2026 release

    OLED MacBook Pro still expected for 2026 release

    Trump Vietnam deal, costs, AirPods, iPad, Apple Watch, Mac mini

    Trump Vietnam deal, costs, AirPods, iPad, Apple Watch, Mac mini

    iPadOS 26 is perfect for the larger iPad model that’s coming

    Apple’s ‘iPad Fold’ won’t be launching any time soon, per new report

  • Retro Rewind
    Retro Rewind: Electronic Games April 1995

    Retro Rewind: Electronic Games April 1995

    Retro Rewind: Electronic Gaming Monthly Magazine Number 55 February 1994

    Retro Rewind: Electronic Gaming Monthly Magazine Number 57 April 1994

    Retro Rewind: Blast from the Past – 35 Iconic Commercials of 1988!

    Retro Rewind: Blast from the Past – 35 Iconic Commercials of 1988!

    Retro Rewind: PC World Magazine August 1998

    Retro Rewind: PC World Magazine August 1998

    Retro Rewind: Computer Shopper Magazine September 1997

    Retro Rewind: Computer Shopper Magazine September 1997

    Retro Rewind: PC Magazine December 2015

    Retro Rewind: PC Magazine December 2015

    Retro Rewind: EDGE Magazine RETRO #1: The Guide to Classic Videogame Playing and Collecting

    Retro Rewind: EDGE Magazine RETRO #1: The Guide to Classic Videogame Playing and Collecting

    Retro Rewind: Computer Gaming World Magazine Issue 73 December 1998

    Retro Rewind: Computer Gaming World Magazine Issue 73 December 1998

    Retro Rewind: Electronic Gaming Monthly Magazine Number 55 February 1994

    Retro Rewind: Electronic Gaming Monthly Magazine Number 55 February 1994

  • Tech Deals
    TAGRY Bluetooth Headphones True Wireless Earbuds 60H Playback LED Power Display…

    TAGRY Bluetooth Headphones True Wireless Earbuds 60H Playback LED Power Display…

    SABRENT 13 Port High Speed USB 2.0 Hub with Power Adapter and 2 Control Switches…

    SABRENT 13 Port High Speed USB 2.0 Hub with Power Adapter and 2 Control Switches…

    ORICO MiniTower 2 Bay RAID Enclosure Compatible NVMe SSD 10Gbps with Expansion Hub…

    ORICO MiniTower 2 Bay RAID Enclosure Compatible NVMe SSD 10Gbps with Expansion Hub…

    Blue Yeti USB Mic for Recording and Streaming on PC and Mac with Blue VOCE Effects, 4…

    Blue Yeti USB Mic for Recording and Streaming on PC and Mac with Blue VOCE Effects, 4…

    Lenovo V15 Laptop | 15.6″ FHD Anti-Glare Display | AMD Ryzen 7 7730U | 40GB RAM | 1TB…

    Lenovo V15 Laptop | 15.6″ FHD Anti-Glare Display | AMD Ryzen 7 7730U | 40GB RAM | 1TB…

    SABRENT 1TB Rocket Nano XTRM External SSD, USB 3.2 / Thunderbolt 3, Speeds Up to…

    SABRENT 1TB Rocket Nano XTRM External SSD, USB 3.2 / Thunderbolt 3, Speeds Up to…

    MIXAGE 64GB CompactFlash Card UDMA7, 120MB/s Read 45MB/s Write, 85TB TBW, for Canon…

    MIXAGE 64GB CompactFlash Card UDMA7, 120MB/s Read 45MB/s Write, 85TB TBW, for Canon…

    2Pack 3.5Ah Battery Replacement for Hitachi 10.8V-12V Battery BCL1015 BCL1015 BCL1015S…

    2Pack 3.5Ah Battery Replacement for Hitachi 10.8V-12V Battery BCL1015 BCL1015 BCL1015S…

    AC/DC Adapter for G-Technology G-Drive 0G03050 Thunderbolt 4TB G-Tech External Hard…

    AC/DC Adapter for G-Technology G-Drive 0G03050 Thunderbolt 4TB G-Tech External Hard…

  • Tech Eats
    Cheesy Broccoli Rice Mug: 5-Minute Super Comfort Food

    Cheesy Broccoli Rice Mug: 5-Minute Super Comfort Food

    Top 10 Vegetarian Recipes for 2025: Easy and Nutritious Meals for Busy People

    Top 10 Vegetarian Recipes for 2025: Easy and Nutritious Meals for Busy People

    Bacon Mug Lasagna: 5-Minute Microwave Meat Lover’s Dream

    Bacon Mug Lasagna: 5-Minute Microwave Meat Lover’s Dream

    Bacon Fried Rice Mug: 5-Minute Microwave Meal

    Bacon Fried Rice Mug: 5-Minute Microwave Meal

    Bacon & Cheddar Mug Biscuit: 2-Minute Savory Comfort

    Bacon & Cheddar Mug Biscuit: 2-Minute Savory Comfort

    Loaded Bacon Cheesy Potato Mug: 5-Minute Comfort Food

    Loaded Bacon Cheesy Potato Mug: 5-Minute Comfort Food

    Peanut Butter Banana Mug Muffin: 5-Minute Protein Snack

    Peanut Butter Banana Mug Muffin: 5-Minute Protein Snack

    Oreo Mug Cake: 2-Minute Cookie & Cake Combo!

    Oreo Mug Cake: 2-Minute Cookie & Cake Combo!

    Tiramisu Mug Cake: Coffee Lover’s Dream in 2 Minutes!

    Tiramisu Mug Cake: Coffee Lover’s Dream in 2 Minutes!

  • Tesla
    Femuar Car Trunk Organizer with Large Capacity Waterproof Car Accessories for Women &…

    Femuar Car Trunk Organizer with Large Capacity Waterproof Car Accessories for Women &…

    [Replacement] 4Pcs Roof Rack Cover Cap Rail End Shell for Tesla for Model 3 2017 2018…

    [Replacement] 4Pcs Roof Rack Cover Cap Rail End Shell for Tesla for Model 3 2017 2018…

    Lower Center Console Organizer Tray for Tesla Model Y 2021-2024 & Model 3 2021-2023,…

    Lower Center Console Organizer Tray for Tesla Model Y 2021-2024 & Model 3 2021-2023,…

    Tesla unveils new cheaper, but nerfed ‘Long Range’ Cybertruck

    Tesla confirms Cybertruck sales are down to just ~5,000 units

    OEDRO Floor Mats Fit for Tesla Model 3 Highland 2024 2025, All Weather Waterproof…

    OEDRO Floor Mats Fit for Tesla Model 3 Highland 2024 2025, All Weather Waterproof…

    Tesla (TSLA) confirms 384,000 deliveries in Q2 2025, right on expectations

    Tesla (TSLA) confirms 384,000 deliveries in Q2 2025, right on expectations

    2025 Upgraded NACS to CCS Adapter, 500A/1000V, 250 kW DC Fast Charging for Ford, Rivian,…

    2025 Upgraded NACS to CCS Adapter, 500A/1000V, 250 kW DC Fast Charging for Ford, Rivian,…

    for Tesla Model 3 Floor mat, 3D Custom car mat for Model 3 2017-2025, All Weather Floor…

    for Tesla Model 3 Floor mat, 3D Custom car mat for Model 3 2017-2025, All Weather Floor…

    Metal Tesla Letters Emblem Trunk Logo Decal Tailgate Rear 3m Adhesive Compatible with…

    Metal Tesla Letters Emblem Trunk Logo Decal Tailgate Rear 3m Adhesive Compatible with…

  • UFO
    Paranormal Activity: The Ghost Dimension | official trailer (2015)

    Paranormal Activity: The Ghost Dimension | official trailer (2015)

    Interstellar Secrets of Ancient Civilizations | Ancient Aliens

    Interstellar Secrets of Ancient Civilizations | Ancient Aliens

    UFO Shape LED Dual Purpose Lamp, Portable Adjustable Light Color and Brightness Outdoor Lamp, Motion Sensor Night Lamp, Magnetic Fixation, Rechargeable Flying Saucer Shape Lamp (White)

    UFO Shape LED Dual Purpose Lamp, Portable Adjustable Light Color and Brightness Outdoor Lamp, Motion Sensor Night Lamp, Magnetic Fixation, Rechargeable Flying Saucer Shape Lamp (White)

    UFO – Unidentified Flying Object (Drum Cover)

    UFO – Unidentified Flying Object (Drum Cover)

    Mademark x MTV – Cryptid MTV Logo Featuring Bigfoot, UFO, Aliens & Nessie T-Shirt

    Mademark x MTV – Cryptid MTV Logo Featuring Bigfoot, UFO, Aliens & Nessie T-Shirt

    Area 51 Security Costume T-Shirt

    Area 51 Security Costume T-Shirt

    New UFO Sightings Caught on Camera in 2025! (Watch Closely)

    New UFO Sightings Caught on Camera in 2025! (Watch Closely)

    Area 51 Security t-Shirt, Extraterrestrial Being, UFO, Designed and Screen Printed in Los Angeles.

    Area 51 Security t-Shirt, Extraterrestrial Being, UFO, Designed and Screen Printed in Los Angeles.

    Top 5 Sky Phenomena That Look Straight Out of a Movie #shorts

    Top 5 Sky Phenomena That Look Straight Out of a Movie #shorts

No Result
View All Result
  • TC
  • AI
    Artificial Intelligence

    EgoDex: Learning Dexterous Manipulation from Large-Scale Egocentric Video

    Artificial Intelligence

    Instruction-Following Pruning for Large Language Models

    Artificial Intelligence

    How to Combine Streamlit, Pandas, and Plotly for Interactive Data Apps

    Artificial Intelligence

    Tailor responsible AI with new safeguard tiers in Amazon Bedrock Guardrails

    Artificial Intelligence

    Automate Data Quality Reports with n8n: From CSV to Professional Analysis

    Artificial Intelligence

    NewDay builds A Generative AI based Customer service Agent Assist with over 90% accuracy

    Artificial Intelligence

    5 Things You Need to Know About Agentic AI

    Artificial Intelligence

    Normalizing Flows are Capable Generative Models

    Artificial Intelligence

    Update on the AWS DeepRacer Student Portal

  • App Zone
    Top 3 Launcher Apps for Apple: Features, Pros, and Cons

    Top 3 Launcher Apps for Apple: Features, Pros, and Cons

    Top 3 Launcher Apps for Android: Features, Pros, and Cons

    Top 3 Launcher Apps for Android: Features, Pros, and Cons

    Top 3 Card Game Apps of 2025: Features, Pros, and Cons

    Top 3 Card Game Apps of 2025: Features, Pros, and Cons

    Top 3 Medical Apps of 2025: Features, Pros, and Cons

    Top 3 Medical Apps of 2025: Features, Pros, and Cons

    Top 3 Travel Apps of 2025: Features, Pros, and Cons

    Top 3 Travel Apps of 2025: Features, Pros, and Cons

    Top 3 Casual Game Apps for 2025: Features, Pros, and Cons

    Top 3 Casual Game Apps for 2025: Features, Pros, and Cons

    Top 3 Food Apps for 2025: Features, Pros, and Cons

    Top 3 Food Apps for 2025: Features, Pros, and Cons

    Top 3 Sport Apps for 2025: Features, Pros, and Cons

    Top 3 Sport Apps for 2025: Features, Pros, and Cons

    Top 3 Productivity Apps for 2025: Features, Pros, and Cons

    Top 3 Productivity Apps for 2025: Features, Pros, and Cons

  • Apple
    M4 iPad Pro, iPad A16, Apple Pencil Pro, AirTag, more 9to5Mac

    M4 iPad Pro, iPad A16, Apple Pencil Pro, AirTag, more 9to5Mac

    iPhone expansion, Foxconn India drops Chinese experts, mystery

    Qantas data breach exposes personal details of millions

    Qantas data breach exposes personal details of millions

    July 2, 2025 – iPhone Fold, Apple vs DOJ

    Five new Apple products are launching early this year, here’s what’s coming

    Apple is launching 15+ new products this fall, here’s what’s coming

    iOS 26’s new Liquid Glass design looks like a major win for Apple

    iOS 26’s new Liquid Glass design looks like a major win for Apple

    OLED MacBook Pro still expected for 2026 release

    OLED MacBook Pro still expected for 2026 release

    Trump Vietnam deal, costs, AirPods, iPad, Apple Watch, Mac mini

    Trump Vietnam deal, costs, AirPods, iPad, Apple Watch, Mac mini

    iPadOS 26 is perfect for the larger iPad model that’s coming

    Apple’s ‘iPad Fold’ won’t be launching any time soon, per new report

  • Retro Rewind
    Retro Rewind: Electronic Games April 1995

    Retro Rewind: Electronic Games April 1995

    Retro Rewind: Electronic Gaming Monthly Magazine Number 55 February 1994

    Retro Rewind: Electronic Gaming Monthly Magazine Number 57 April 1994

    Retro Rewind: Blast from the Past – 35 Iconic Commercials of 1988!

    Retro Rewind: Blast from the Past – 35 Iconic Commercials of 1988!

    Retro Rewind: PC World Magazine August 1998

    Retro Rewind: PC World Magazine August 1998

    Retro Rewind: Computer Shopper Magazine September 1997

    Retro Rewind: Computer Shopper Magazine September 1997

    Retro Rewind: PC Magazine December 2015

    Retro Rewind: PC Magazine December 2015

    Retro Rewind: EDGE Magazine RETRO #1: The Guide to Classic Videogame Playing and Collecting

    Retro Rewind: EDGE Magazine RETRO #1: The Guide to Classic Videogame Playing and Collecting

    Retro Rewind: Computer Gaming World Magazine Issue 73 December 1998

    Retro Rewind: Computer Gaming World Magazine Issue 73 December 1998

    Retro Rewind: Electronic Gaming Monthly Magazine Number 55 February 1994

    Retro Rewind: Electronic Gaming Monthly Magazine Number 55 February 1994

  • Tech Deals
    TAGRY Bluetooth Headphones True Wireless Earbuds 60H Playback LED Power Display…

    TAGRY Bluetooth Headphones True Wireless Earbuds 60H Playback LED Power Display…

    SABRENT 13 Port High Speed USB 2.0 Hub with Power Adapter and 2 Control Switches…

    SABRENT 13 Port High Speed USB 2.0 Hub with Power Adapter and 2 Control Switches…

    ORICO MiniTower 2 Bay RAID Enclosure Compatible NVMe SSD 10Gbps with Expansion Hub…

    ORICO MiniTower 2 Bay RAID Enclosure Compatible NVMe SSD 10Gbps with Expansion Hub…

    Blue Yeti USB Mic for Recording and Streaming on PC and Mac with Blue VOCE Effects, 4…

    Blue Yeti USB Mic for Recording and Streaming on PC and Mac with Blue VOCE Effects, 4…

    Lenovo V15 Laptop | 15.6″ FHD Anti-Glare Display | AMD Ryzen 7 7730U | 40GB RAM | 1TB…

    Lenovo V15 Laptop | 15.6″ FHD Anti-Glare Display | AMD Ryzen 7 7730U | 40GB RAM | 1TB…

    SABRENT 1TB Rocket Nano XTRM External SSD, USB 3.2 / Thunderbolt 3, Speeds Up to…

    SABRENT 1TB Rocket Nano XTRM External SSD, USB 3.2 / Thunderbolt 3, Speeds Up to…

    MIXAGE 64GB CompactFlash Card UDMA7, 120MB/s Read 45MB/s Write, 85TB TBW, for Canon…

    MIXAGE 64GB CompactFlash Card UDMA7, 120MB/s Read 45MB/s Write, 85TB TBW, for Canon…

    2Pack 3.5Ah Battery Replacement for Hitachi 10.8V-12V Battery BCL1015 BCL1015 BCL1015S…

    2Pack 3.5Ah Battery Replacement for Hitachi 10.8V-12V Battery BCL1015 BCL1015 BCL1015S…

    AC/DC Adapter for G-Technology G-Drive 0G03050 Thunderbolt 4TB G-Tech External Hard…

    AC/DC Adapter for G-Technology G-Drive 0G03050 Thunderbolt 4TB G-Tech External Hard…

  • Tech Eats
    Cheesy Broccoli Rice Mug: 5-Minute Super Comfort Food

    Cheesy Broccoli Rice Mug: 5-Minute Super Comfort Food

    Top 10 Vegetarian Recipes for 2025: Easy and Nutritious Meals for Busy People

    Top 10 Vegetarian Recipes for 2025: Easy and Nutritious Meals for Busy People

    Bacon Mug Lasagna: 5-Minute Microwave Meat Lover’s Dream

    Bacon Mug Lasagna: 5-Minute Microwave Meat Lover’s Dream

    Bacon Fried Rice Mug: 5-Minute Microwave Meal

    Bacon Fried Rice Mug: 5-Minute Microwave Meal

    Bacon & Cheddar Mug Biscuit: 2-Minute Savory Comfort

    Bacon & Cheddar Mug Biscuit: 2-Minute Savory Comfort

    Loaded Bacon Cheesy Potato Mug: 5-Minute Comfort Food

    Loaded Bacon Cheesy Potato Mug: 5-Minute Comfort Food

    Peanut Butter Banana Mug Muffin: 5-Minute Protein Snack

    Peanut Butter Banana Mug Muffin: 5-Minute Protein Snack

    Oreo Mug Cake: 2-Minute Cookie & Cake Combo!

    Oreo Mug Cake: 2-Minute Cookie & Cake Combo!

    Tiramisu Mug Cake: Coffee Lover’s Dream in 2 Minutes!

    Tiramisu Mug Cake: Coffee Lover’s Dream in 2 Minutes!

  • Tesla
    Femuar Car Trunk Organizer with Large Capacity Waterproof Car Accessories for Women &…

    Femuar Car Trunk Organizer with Large Capacity Waterproof Car Accessories for Women &…

    [Replacement] 4Pcs Roof Rack Cover Cap Rail End Shell for Tesla for Model 3 2017 2018…

    [Replacement] 4Pcs Roof Rack Cover Cap Rail End Shell for Tesla for Model 3 2017 2018…

    Lower Center Console Organizer Tray for Tesla Model Y 2021-2024 & Model 3 2021-2023,…

    Lower Center Console Organizer Tray for Tesla Model Y 2021-2024 & Model 3 2021-2023,…

    Tesla unveils new cheaper, but nerfed ‘Long Range’ Cybertruck

    Tesla confirms Cybertruck sales are down to just ~5,000 units

    OEDRO Floor Mats Fit for Tesla Model 3 Highland 2024 2025, All Weather Waterproof…

    OEDRO Floor Mats Fit for Tesla Model 3 Highland 2024 2025, All Weather Waterproof…

    Tesla (TSLA) confirms 384,000 deliveries in Q2 2025, right on expectations

    Tesla (TSLA) confirms 384,000 deliveries in Q2 2025, right on expectations

    2025 Upgraded NACS to CCS Adapter, 500A/1000V, 250 kW DC Fast Charging for Ford, Rivian,…

    2025 Upgraded NACS to CCS Adapter, 500A/1000V, 250 kW DC Fast Charging for Ford, Rivian,…

    for Tesla Model 3 Floor mat, 3D Custom car mat for Model 3 2017-2025, All Weather Floor…

    for Tesla Model 3 Floor mat, 3D Custom car mat for Model 3 2017-2025, All Weather Floor…

    Metal Tesla Letters Emblem Trunk Logo Decal Tailgate Rear 3m Adhesive Compatible with…

    Metal Tesla Letters Emblem Trunk Logo Decal Tailgate Rear 3m Adhesive Compatible with…

  • UFO
    Paranormal Activity: The Ghost Dimension | official trailer (2015)

    Paranormal Activity: The Ghost Dimension | official trailer (2015)

    Interstellar Secrets of Ancient Civilizations | Ancient Aliens

    Interstellar Secrets of Ancient Civilizations | Ancient Aliens

    UFO Shape LED Dual Purpose Lamp, Portable Adjustable Light Color and Brightness Outdoor Lamp, Motion Sensor Night Lamp, Magnetic Fixation, Rechargeable Flying Saucer Shape Lamp (White)

    UFO Shape LED Dual Purpose Lamp, Portable Adjustable Light Color and Brightness Outdoor Lamp, Motion Sensor Night Lamp, Magnetic Fixation, Rechargeable Flying Saucer Shape Lamp (White)

    UFO – Unidentified Flying Object (Drum Cover)

    UFO – Unidentified Flying Object (Drum Cover)

    Mademark x MTV – Cryptid MTV Logo Featuring Bigfoot, UFO, Aliens & Nessie T-Shirt

    Mademark x MTV – Cryptid MTV Logo Featuring Bigfoot, UFO, Aliens & Nessie T-Shirt

    Area 51 Security Costume T-Shirt

    Area 51 Security Costume T-Shirt

    New UFO Sightings Caught on Camera in 2025! (Watch Closely)

    New UFO Sightings Caught on Camera in 2025! (Watch Closely)

    Area 51 Security t-Shirt, Extraterrestrial Being, UFO, Designed and Screen Printed in Los Angeles.

    Area 51 Security t-Shirt, Extraterrestrial Being, UFO, Designed and Screen Printed in Los Angeles.

    Top 5 Sky Phenomena That Look Straight Out of a Movie #shorts

    Top 5 Sky Phenomena That Look Straight Out of a Movie #shorts

No Result
View All Result
Techcratic
No Result
View All Result
Home Hacker News

PostgreSQL Anonymizer

Hacker News by Hacker News
January 17, 2025
in Hacker News
Reading Time: 5 mins read
128
A A
0

2025-01-14 02:36:00
postgresql-anonymizer.readthedocs.io

PostgreSQL Anonymizer

PostgreSQL Anonymizer is an extension to mask or replace
personally identifiable information (PII) or commercially sensitive data from
a Postgres database.

The project has a declarative approach of anonymization. This means you can
declare the masking rules using the PostgreSQL Data Definition Language (DDL)
and specify your anonymization policy inside the table definition itself.

The main goal of this extension is to offer anonymization by design. We
firmly believe that data masking rules should be written by the people who develop
the application because they have the best knowledge of how the data model works.
Therefore masking rules must be implemented directly inside the database schema.

Once the masking rules are defined, you can apply them using 5 different
masking methods :

Each method has its pros and cons. Different masking methods may be used in
different contexts. In any case, masking the data directly inside the PostgreSQL
instance without using an external tool is crucial to limit the exposure and
the risks of data leak.

In addition, various Masking Functions are available : randomization, faking,
partial scrambling, shuffling, noise or even your own custom function!

Finally, the extension offers a panel of detection functions that will try to
guess which columns need to be anonymized.

Quick Start

Step 0. Launch docker image of the project

ANON_IMG=registry.gitlab.com/dalibo/postgresql_anonymizer
docker run --name anon_quickstart --detach -e POSTGRES_PASSWORD=x $ANON_IMG
docker exec -it anon_quickstart psql -U postgres

Step 1. Create a database and load the extension in it

CREATE DATABASE demo;
ALTER DATABASE demo SET session_preload_libraries="anon"

\connect demo
You are now connected to database "demo" as user "postgres".

Step 2. Create a table

CREATE TABLE people AS
    SELECT  153478       AS id,
            'Sarah'      AS firstname,
            'Conor'      AS lastname,
            '0609110911' AS phone
;
SELECT * FROM people;
   id   | firstname | lastname |   phone
--------+-----------+----------+------------
 153478 | Sarah     | Conor    | 0609110911

Step 3. Create the extension and activate the masking engine

CREATE EXTENSION anon;
ALTER DATABASE demo SET anon.transparent_dynamic_masking TO true;

Step 4. Declare a masked user

CREATE ROLE skynet LOGIN;

SECURITY LABEL FOR anon ON ROLE skynet IS 'MASKED';

GRANT pg_read_all_data to skynet;

Step 5. Declare the masking rules

SECURITY LABEL FOR anon ON COLUMN people.lastname
  IS 'MASKED WITH FUNCTION anon.dummy_last_name()';

SECURITY LABEL FOR anon ON COLUMN people.phone
  IS 'MASKED WITH FUNCTION anon.partial(phone,2,$$******$$,2)';

Step 6. Connect with the masked user

\connect - skynet
You are now connected to database "demo" as user "skynet"

SELECT * FROM people;
   id   | firstname | lastname  |   phone
--------+-----------+-----------+------------
 153478 | Sarah     | Stranahan | 06******11

Success Stories

With PostgreSQL Anonymizer we integrate, from the design of the database,
the principle that outside production the data must be anonymized. Thus we
can reinforce the GDPR rules, without affecting the quality of the tests
during version upgrades for example.

— Thierry Aimé, Office of Architecture and Standards in the French
Public Finances Directorate General (DGFiP)


Thanks to PostgreSQL Anonymizer we were able to define complex masking rules
in order to implement full pseudonymization of our databases without losing
functionality. Testing on realistic data while guaranteeing the
confidentiality of patient data is a key point to improve the robustness of
our functionalities and the quality of our customer service.

— Julien Biaggi, Product Owner at bioMérieux


I just discovered your postgresql_anonymizer extension and used it at
my company for anonymizing our user for local development. Nice work!

— Max Metcalfe

If this extension is useful to you, please let us know !

Support

We need your feedback and ideas ! Let us know what you think of this tool, how
it fits your needs and what features are missing.

You can either open an issue or send a message at contact@dalibo.com.

Source Link


Keep your files stored safely and securely with the SanDisk 2TB Extreme Portable SSD. With over 69,505 ratings and an impressive 4.6 out of 5 stars, this product has been purchased over 8K+ times in the past month. At only $129.99, this Amazon’s Choice product is a must-have for secure file storage.

Help keep private content private with the included password protection featuring 256-bit AES hardware encryption. Order now for just $129.99 on Amazon!


Start your free Amazon Prime trial
today and unlock unlimited streaming and more!

Support Techcratic

If you find value in Techcratic’s insights and articles, consider supporting us with Bitcoin. Your support helps me, as a solo operator, continue delivering high-quality content while managing all the technical aspects, from server maintenance to blog writing, future updates, and improvements. Support Innovation! Thank you.

Bitcoin Address:

bc1qlszw7elx2qahjwvaryh0tkgg8y68enw30gpvge

Please verify this address before sending funds.

Bitcoin QR Code

Simply scan the QR code below to support Techcratic.

Bitcoin QR code for donations

Please read the Privacy and Security Disclaimer on how Techcratic handles your support.

Disclaimer: As an Amazon Associate, Techcratic may earn from qualifying purchases.

Tags: Hacker News
Share162Share28ShareShare4ShareTweet101
Previous Post

Parallels introduces x86 emulation for Apple Silicon Macs

Next Post

Gotham Knights REVIEW ITS AMAZING

Hacker News

Hacker News

Stay updated with Hacker News, where technology meets entrepreneurial spirit. Get the latest on tech trends, startup news, and discussions from the tech community. Read the latest updates here at Techcratic.

Related Posts

Stop Building AI Agents: Use Smarter LLM Workflows
Hacker News

Stop Building AI Agents: Use Smarter LLM Workflows

July 2, 2025
1.3k
enumura1/chatbot-flow-editor: Visual chatbot flow editor. GUI tool for designing chatbot flows. Create, test, and export as JSON.
Hacker News

enumura1/chatbot-flow-editor: Visual chatbot flow editor. GUI tool for designing chatbot flows. Create, test, and export as JSON.

July 2, 2025
1.3k
Tesla (TSLA) Q2 vehicle deliveries report
Hacker News

Tesla (TSLA) Q2 vehicle deliveries report

July 2, 2025
1.3k
Hackers Target Linux SSH Servers to Deploy TinyProxy and Sing-box Proxy Tools
Hacker News

Hackers Target Linux SSH Servers to Deploy TinyProxy and Sing-box Proxy Tools

July 2, 2025
1.3k
Full-system emulated fuzzing of Qualcomm basebands
Hacker News

Full-system emulated fuzzing of Qualcomm basebands

July 2, 2025
1.3k
Bots Now Account for 30% of Global Web Traffic, Surpassing Human Activity in Some Regions
Hacker News

Bots Now Account for 30% of Global Web Traffic, Surpassing Human Activity in Some Regions

July 2, 2025
1.3k
FileFix Attack Exploits Windows Browser Loophole to Evade Mark-of-the-Web Security
Hacker News

FileFix Attack Exploits Windows Browser Loophole to Evade Mark-of-the-Web Security

July 2, 2025
1.3k
Anthropic MCP Inspector Vulnerability Lets Hackers Run Arbitrary Code Remotely
Hacker News

Anthropic MCP Inspector Vulnerability Lets Hackers Run Arbitrary Code Remotely

July 2, 2025
1.3k
Load More
Next Post
Gotham Knights REVIEW ITS AMAZING

Gotham Knights REVIEW ITS AMAZING

Your Tech Resources

  • 30 Second Tech ™
  • AI
  • App Zone ™
  • Apple
  • Ars Technica
  • CNET
  • ComputerWorld
  • Crypto News
  • Cybersecurity
  • Endgadget
  • Forbes
  • Fossbytes
  • Gaming
  • GeekWire
  • Gizmodo
  • Google News
  • Hacker News
  • Harvard Tech
  • I Like Cats ™
  • I Like Dogs ™
  • LifeHacker
  • MacRumors
  • Macworld
  • Mashable
  • Microsoft
  • MIT Tech
  • PC World
  • Photofocus
  • Physics
  • Random Tech
  • Retro Rewind ™
  • Robot Report
  • SiliconANGLE
  • SlashGear
  • Smartphone
  • StackSocial
  • Tech Art
  • Tech Careers
  • Tech Deals
  • Techcratic ™
  • TechCrunch
  • Techdirt
  • TechRepublic
  • Techs Got To Eat ™
  • TechSpot
  • Tesla
  • The Verge
  • TNW
  • Trusted Reviews
  • UFO
  • VentureBeat
  • Visual Capitalist
  • Wired
  • ZDNet

Tech News

  • 30 Second Tech ™
  • AI
  • Apple Insider
  • Ars Technica
  • CNET
  • ComputerWorld
  • Crypto News
  • Cybersecurity
  • Endgadget
  • ExtremeTech
  • Fossbytes
  • Gaming
  • GeekWire
  • Gizmodo

Tech News

  • Harvard Tech
  • MacRumors
  • Macworld
  • Mashable
  • Microsoft
  • MIT Tech
  • Physics
  • PC World
  • Random Tech
  • Retro Rewind ™
  • SiliconANGLE
  • SlashGear
  • Smartphone
  • StackSocial
  • Tech Careers

Tech News​

  • Tech Art
  • TechCrunch
  • Techdirt
  • TechRepublic
  • Techs Got To Eat ™
  • TechSpot
  • Tesla
  • The Verge
  • TNW
  • Trusted Reviews
  • UFO
  • VentureBeat
  • Visual Capitalist
  • Wired
  • ZDNet

Site Links

  • About Techcratic
  • Affiliate Disclaimer
  • Affiliate Link Policy
  • Contact Techcratic
  • Dealors Discount Store
  • Privacy and Security Disclaimer
  • Privacy Policy
  • RSS Feed
  • Site Map
  • Support Techcratic
  • Techcratic
  • Tech Deals
  • TOS
  • 𝕏
Click For A Secret Deal

Techcratic – Your All In One Tech Hub © 2020 – 2025
All Rights Reserved
∞

No Result
View All Result
  • 30 Second Tech ™
  • AI
  • App Zone ™
  • Apple
  • Ars Technica
  • CNET
  • Crypto News
  • Cybersecurity
  • Endgadget
  • Gaming
  • I Like Cats ™
  • I Like Dogs ™
  • MacRumors
  • Macworld
  • Tech Deals
  • Techcratic ™
  • Techs Got To Eat ™
  • Tesla
  • UFO
  • Wired