Dave Bunten comments

Results 95 comments of


                                            Dave Bunten

Performance issues using ORDER BY and LIMIT with large OFFSETs on wide tables

@msf best wishes on your upcoming talk at DuckCon 5! Just in case, wanted to share along a workaround which @Teggy very helpfully mentioned through the DuckDB Discord. If using...

Food Ontology Import Issue

I came across this issue when trying to run the full RTX-KG2 workflow. In addition or perhaps alongside the changes mentioned regarding a pickled version of the original data, would...

Add retry capabilities for `kg2_util.download_file_if_not_exist_locally` to avoid systemic failures

Sounds good, thank you as well @saramsey ! If it'd be helpful, may I submit a PR towards this cause? I can also understand if you wouldn't suggest it.

Add data description and provenance for "SMPDB PubMed annotations" (`SMPDB_pubmed_IDs.csv`)

Thank you @saramsey !

Bug: get an error in pycytominer/init.py it was fixed coming back to the previous commit

Thanks Paula and Ken! I opened a draft PR for a fix for this which should be able to check for the configuration option before attempting to apply it. As...

Bug: get an error in pycytominer/init.py it was fixed coming back to the previous commit

Thanks @PaulaLlanos ! Based on what you mentioned I looked into Pandas 2.2.0 to find out more about the config option availability. Pandas 2.2.0 I believe makes the the `copy_on_write`...

Bug: get an error in pycytominer/init.py it was fixed coming back to the previous commit

Thank you @PaulaLlanos for the updates and sorry to hear this is impacting another person. Based on what you've mentioned I've moved #415 out of draft status and will seek...

Bug: get an error in pycytominer/init.py it was fixed coming back to the previous commit

Thanks @kenibrewer ! @PaulaLlanos , a fix has been applied as of f3ce7928903aed1eca8e4922037ab5d12fe92b2f which I believe should mitigate the exception you mentioned. Just the same, I recommend double checking your...

Bug: get an error in pycytominer/init.py it was fixed coming back to the previous commit

Thanks again @PaulaLlanos for opening this issue and for working with us as we applied a fix. I'm going to close this as we applied a fix and guidance here....

Bug: get an error in pycytominer/init.py it was fixed coming back to the previous commit

Closing after merge of #415