Add PostgreSQL support
还没有人认领这个 Issue。
评估
调研方向
No project files or tests are named. Start by reviewing the psycopg2 approach and Google's PostgreSQL extension linked in the issue, then determine how PostgreSQL loading should integrate with PyDP. Done means PostgreSQL data can use differential-privacy-compliant operations, with custom Sum and Count behavior that prevents direct privacy-unsafe queries.
由索引模型根据 Issue 内容生成。
描述
Description
Right now, to load data into pydp, the way to use load it manually using pandas or some other method and then apply DP operations by passing it to a list.
A good way to use is to enable postgres support within DP so you don't have a scope of opening up a list.
In google's repo, they have added a postgres extesnsion. While this works in the DB, in the code, it becomes bit difficult to use.
What we could do is build support on top of the psycopg2 module, thus the SQL operations would be DP compliant.
Breakdown
What can be done is we disable Sum, Count operation from psycopg2 and define our custom functions so in no-case shall privacy be violated.
Who else?
We might need research team support for SQL queries but doesn't seem likely for statistical functions.
- 主要语言
- Python
- 星标
- 550
- 派生
- 143
- PR 合并指标
- 30 天内没有已合并 PR
环境准备
从这里开始
- 先读完整个 Issue，再读项目的贡献指南。
- 在 Issue 下留言说明你要接手 —— 这能避免两个人做同样的事。
- Fork 仓库，在一个分支上完成修改。
- 提交 Pull Request，并在描述里引用这个 Issue 编号。
OpenMined/PyDP 的其他 Issue
-
Type: New Feature :heavy_plus_sign:
难度 4/5 3-5 天 新手友好度 45/100
-
Type: Question :grey_question:
难度 3/5 1-2 天 新手友好度 25/100
-
Type: Question :grey_question:
难度 4/5 3-5 天 新手友好度 32/100
-
Type: Improvement :chart_with_upwards_trend:
难度 3/5 1-2 天 新手友好度 35/100
-
Type: New Feature :heavy_plus_sign:
难度 3/5 1-2 天 新手友好度 38/100
相似的 Issue
-
documentation
难度 2/5 1-3 小时 新手友好度 70/100
kristofdegrave/homeassistant-smart-charging#1413 ·
维护者通常 1 天内回复
-
难度 2/5 1-3 小时 新手友好度 88/100
nasa/earthdata-varinfo#113 ·
-
curriculum documentation quality
难度 2/5 1-3 小时 新手友好度 88/100
githubnext/gh-aw-workshop#3849 ·
维护者通常 2 天内回复
-
难度 2/5 1-3 小时 新手友好度 90/100
-
难度 2/5 1-3 小时 新手友好度 84/100
维护者通常 1 天内回复