Investigate using DuckDB instead of `read_sql_query`
Nobody has claimed this yet.
Assessment
- Difficulty
- 5/5
- Estimated time
- Over a week
- Newbie friendliness
- 25/100
- Issue type
- Refactor
- Clarity
- Needs clarification
- Activity status
- Stale
- Domain
- databases, performance
Research direction
No file, test, or entry point is named. Start by locating the use of read_sql_query, then read the linked DuckDB article and compare the relevant APIs and performance. Done should include a documented investigation and a clear basis for deciding whether replacement is practical.
Written by the indexing model from the issue text.
Description
We may be able to achieve significant performance boosts by replacing read_sql_query with DuckDB's API. For more info, refer here: https://duckdb.org/2021/05/14/sql-on-pandas.html
- Dominant language
- Python
- Stars
- 10
- Forks
- 0
- PR merge metrics
- No merged PRs in 30d
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from alteryx/featuretools_sql
-
documentation
Difficulty 1/5 Under an hour Newbie friendliness 68/100
alteryx/featuretools_sql#36 ·
-
Difficulty 4/5 3-5 days Newbie friendliness 35/100
alteryx/featuretools_sql#83 ·
-
Difficulty 3/5 1-2 days Newbie friendliness 42/100
alteryx/featuretools_sql#70 ·
-
Difficulty 5/5 Over a week Newbie friendliness 15/100
alteryx/featuretools_sql#56 ·
-
Difficulty 5/5 Over a week Newbie friendliness 25/100
alteryx/featuretools_sql#54 ·
All issues in alteryx/featuretools_sql
Similar issues
-
Difficulty 2/5 1-3 hours Newbie friendliness 88/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 82/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
-
enhancement
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 74/100