daamien

6 ms·

1.
The strange case of the underestimated Merge Join node(blog.dalibo.com)
27 points by daamien 8mo ago|0 comments
2.
by daamien 2y ago
OP is one of 7 PostgreSQL core team members. That's kind of his job to massively overthink this :)
3.
by daamien 2y ago
Hi ! I'm the main developer of this extension. Happy to answer any question you have about this project and anonymization in general!
4.
by daamien 2y ago
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
5.
by daamien 2y ago
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 SQ
6.
by daamien 2y ago
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
7.
by daamien 2y ago
This is called "Privacy By Default" https://postgresql-anonymizer.readthedocs.io/en/stable/priva...
8.
by daamien 2y ago
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
9.
by daamien 2y ago
Version 2.0 was released a few days ago. It's a complete rewrite in Rust. Performance should be better than with v1.x
10.
by daamien 2y ago
This called "Masking Data Wrappers" https://postgresql-anonymizer.readthedocs.io/en/stable/maski...
11.
by daamien 2y ago
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 SQ
12.
by daamien 2y ago
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.
13.
by daamien 3y ago
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, s
14.
Pipeline Mode in Psycopg(blog.dalibo.com)
1 points by daamien 4y ago|0 comments
15.
How Psycopg row factories help you write safer applications(blog.dalibo.com)
6 points by daamien 4y ago|0 comments
16.
by daamien 7y ago
See PEV2 : https://github.com/dalibo/pev2
17.
by daamien 8y ago
This is still an issue : https://postgresql.verite.pro/blog/2018/08/27/glibc-upgrade....
18.
by daamien 8y ago
... and with dozens of other data sources: https://wiki.postgresql.org/wiki/Foreign_data_wrappers
19.
by daamien 8y ago
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 &#x27
20.
Again Riddle(riddle.link)
1 points by daamien 9y ago|0 comments
21.
by daamien 11y ago
direct link to the PDF : http://www.postgresql.org/message-id/attachment/43080/Postgr...
22.
Oracle's letter to Russian IT companies(postgresql.org)
217 points by daamien 11y ago|91 comments
23.
Spotify PostgreSQL Metrics(github.com)
2 points by daamien 11y ago|0 comments
24.
by daamien 11y ago
Temporary index and Hypothetical index are two different things. Temporary index is a real index that's usually dynamically created by the optimizer to speed up a query. But it's kind of useless because most of the time the cost o
25.
PostgreSQL 9.4.1 Released(postgresql.org)
6 points by daamien 12y ago|0 comments
26.
A new vmstat-like tool for PostgreSQL(github.com)
1 points by daamien 12y ago|0 comments
27.
by daamien 12y ago
Hi ! I'm involved in both projects. Here' s some insight : OPM and POWA are not related. They were born at different times and developed by two different R&D teams at DALIBO, a French PostgreSQL company. The fact that they&#x2
28.
by daamien 12y ago
fixed.
29.
PostgreSQL Benchmark On Amazon EC2 And Rackspace (mobisoftinfotech.com)
1 points by daamien 13y ago|0 comments
30.
Mongo + Postgres = Mongres(github.com)
2 points by daamien 13y ago|0 comments

More ›