Hacker News: daamien

The strange case of the underestimated Merge Join node

daamien — Mon, 19 Jan 2026 15:00:07 +0000

Article URL: https://blog.dalibo.com/2026/01/12/under-estimated-mergejoin.html

Comments URL: https://news.ycombinator.com/item?id=46679737

Points: 27

# Comments: 0

New comment by daamien in "How about trailing commas in SQL?"

daamien — Tue, 11 Feb 2025 17:13:26 +0000

OP is one of 7 PostgreSQL core team members. That's kind of his job to massively overthink this :)

New comment by daamien in "PostgreSQL Anonymizer"

daamien — Sat, 18 Jan 2025 00:50:13 +0000

Hi !

I'm the main developer of this extension. Happy to answer any question you have about this project and anonymization in general!

New comment by daamien in "PostgreSQL Anonymizer"

daamien — Sat, 18 Jan 2025 00:48:11 +0000

Pseudonymizing functions are just one way to mask the data.

There are many other masking functions that will actually anonymize the data.

And the extension does not force you to respect the foreign keys.

It's really up to you to decide how you want to implement your masking policy

New comment by daamien in "PostgreSQL Anonymizer"

daamien — Sat, 18 Jan 2025 00:44:12 +0000

PostgreSQL Anonymizer developer here : this was possible with version 0.8 which is now completely unmaintained. This extension is currently not available on RDS but it is available on many others DBaaS providers : Azure SQL, Google Cloud SQL, Crunchy Bridge, ....

New comment by daamien in "PostgreSQL Anonymizer"

daamien — Sat, 18 Jan 2025 00:42:54 +0000

Both approach are possible

* Static Masking will destroy the authentic data once for all

* Dynamic Masking will only alter the data the "masked users". Regular users will continue to view the real data.

Both techniques have their own advantage depending on your context.

New comment by daamien in "PostgreSQL Anonymizer"

daamien — Sat, 18 Jan 2025 00:38:51 +0000

This is called "Privacy By Default"

https://postgresql-anonymizer.readthedocs.io/en/stable/priva...

New comment by daamien in "PostgreSQL Anonymizer"

daamien — Sat, 18 Jan 2025 00:36:27 +0000

Of course there's no perfect solution for anonymizing a dataset...

The extension offers a large panel of masking functions : some are pseudonymizing functions but others are more destructive. For instance there's large collection of fake data generators ( names, address, phones, etc. )

It's up to the database administrator or the application developer to decide which columns need to be masked and how it should be masked.

In some use cases, pseudonymization is enough and others anonymization is required....

New comment by daamien in "PostgreSQL Anonymizer"

daamien — Sat, 18 Jan 2025 00:27:35 +0000

Version 2.0 was released a few days ago. It's a complete rewrite in Rust.

Performance should be better than with v1.x

New comment by daamien in "PostgreSQL Anonymizer"

daamien — Sat, 18 Jan 2025 00:26:11 +0000

This called "Masking Data Wrappers"

https://postgresql-anonymizer.readthedocs.io/en/stable/maski...

New comment by daamien in "PostgreSQL Anonymizer"

daamien — Sat, 18 Jan 2025 00:23:05 +0000

PostgreSQL Anonymizer developer here : this was possible with version 0.8 which is now completely unmaintained.

This extension is currently not available on RDS but it is available on many others DBaaS providers : Azure SQL, Google Cloud SQL, Crunchy Bridge, ....

New comment by daamien in "PostgreSQL Anonymizer"

daamien — Sat, 18 Jan 2025 00:11:26 +0000

PostgreSQL Anonymizer developer here : the problem you are describing here only affects version 1.x

Version 2.0 was released a few days ago with a branch new masking system that does not block database migrations.

New comment by daamien in "Debunking the Myth of "Anonymous" Data"

daamien — Mon, 13 Nov 2023 10:58:41 +0000

Actually the GDPR "just" requires to protect the data against "reasonably likely" attacks.

« To determine whether a natural person is identifiable, account should be taken of all the means reasonably likely to be used, such as singling out, either by the controller or by another person to identify the natural person directly or indirectly.

To ascertain whether means are reasonably likely to be used to identify the natural person, account should be taken of all objective factors, such as the costs of and the amount of time required for identification, taking into consideration the available technology at the time of the processing and technological developments. »

https://www.privacy-regulation.eu/en/r26.htm

Pipeline Mode in Psycopg

daamien — Mon, 19 Sep 2022 16:03:22 +0000

Article URL: https://blog.dalibo.com/2022/06/01/psycopg-row-factories.html

Comments URL: https://news.ycombinator.com/item?id=32900147

Points: 1

# Comments: 0

How Psycopg row factories help you write safer applications

daamien — Thu, 02 Jun 2022 15:44:59 +0000

Article URL: https://blog.dalibo.com/2022/06/01/psycopg-row-factories.html

Comments URL: https://news.ycombinator.com/item?id=31596300

Points: 6

# Comments: 0

New comment by daamien in "Show HN: pg_flame – flamegraph visualizations of PostgreSQL query plans"

daamien — Mon, 28 Oct 2019 13:44:26 +0000

See PEV2 : https://github.com/dalibo/pev2

New comment by daamien in "The dangers of streaming across versions of glibc: A cautionary tale (2014)"

daamien — Tue, 08 Jan 2019 14:54:07 +0000

This is still an issue :

https://postgresql.verite.pro/blog/2018/08/27/glibc-upgrade....

New comment by daamien in "TextQL: Execute SQL Against CSV or TSV"

daamien — Sat, 07 Apr 2018 17:21:21 +0000

... and with dozens of other data sources:

https://wiki.postgresql.org/wiki/Foreign_data_wrappers

New comment by daamien in "TextQL: Execute SQL Against CSV or TSV"

daamien — Sat, 07 Apr 2018 17:13:40 +0000

PostgreSQL does this out of the box with :

  CREATE EXTENSION file_fdw;
  CREATE SERVER import FOREIGN DATA WRAPPER file_fdw;
  CREATE FOREIGN TABLE foo (
    col1 text,
    col2 text,
    ...
  ) SERVER import 
  OPTIONS ( filename '/path/to/foo.csv', format 'csv' );
  SELECT col1 FROM foo WHERE col2='x';

Again Riddle

daamien — Mon, 08 May 2017 06:42:17 +0000

Article URL: http://riddle.link/

Comments URL: https://news.ycombinator.com/item?id=14289709

Points: 1

# Comments: 0